Label are cut off on some computers - Visual Basic Discussion Boards

CodingYoshi21-Nov-06 4:04

21-Nov-06 4:04

Hello,

I am trying to make a scheduling application so I have a UI with checkboxes for every weekday and save the values in the DB. When the user wishes to make a new schedule, I don't want to allow conflicts,i.e 2 schedules running on a weekday at the same time. So if the previous schedule is for Monday, Tue, and Wed and the current is for some other days(maybe includes Wed, Mon, and Tue maybe doesn't). Problem is how do I check this, how can I verify that the schedule is not conflicting. I am first comparing the times before the days as if the time is not the same there will be no conflict.

Remember I only have to check the checked days against the stored checkdays in DB, or Do I?

Thanks b4 hand

Yoshimitsu

Re: CheckBoxes

jsampsonPC22-Nov-06 1:51

jsampsonPC

22-Nov-06 1:51

When your user logins to the application, you should probably pull their schedule from the database and put it into a DataTable. This will enable you to quickly evaluate their selections against their pre-existing database content without having to make round-trips back and forth to the database.

Secondly, when the application begins running, you might want to enumerate all of your checkboxes against the DataTable, to find out which ones should be selected and which ones should not be selected, according to the database information stored in the DataTable.

Next, when a CheckBox event Checked is raised, you can take the arguments and pass them to the dataTable to see if they conflict with any data on file. If not, then write to your datatable the new data.

Just be sure to update the DataSource from your DataTable with a DataAdapter once you're finished.

Jonathan Sampson
www.SampsonResume.com

Re: CheckBoxes

CodingYoshi23-Nov-06 4:01

CodingYoshi

23-Nov-06 4:01

Thanks a bunch. I just had to keep going because of time constraint and somehow managed to do it. I was actually saving the contents in an arraylist so I didn't have to make round trips.
Thanks once again.

Yoshimitsu

VBA under Excel

⁷³Zeppelin21-Nov-06 3:13

⁷³Zeppelin

21-Nov-06 3:13

So, my foray into VBA continues. Under Excel, I am developing a financial application. This is my first time using VBA, so I am a little clueless on certain (simple) things. The problem I have is the following:

I have data stored in an array that I write to a column in Excel. The length of the array can vary from calculation to calculation. Thus, I write the data from the array to the A column on the spreadsheet. Let's say the length of the array is n. So I write n elements to column A on the Excel spreadsheet. Now, I am trying to get excel to automatically plot the data in column A on a graph, but n is variable. So in one instance n may be 100. In another n may be 233, for example. The problem is that I don't know how to automatically determine the length of the column so that I can plot the data on an Excel chart. Any assistance would be appreciated.

Thanks in advance.

Re: VBA under Excel

CPallini21-Nov-06 4:16

CPallini

21-Nov-06 4:16

Use the Chart object, as in the following sample:

Dim MyArray(4) As Long
    
    MyArray(0) = -5: MyArray(1) = 1: MyArray(2) = 2: MyArray(3) = 4: MyArray(4) = 7
    
    With Worksheets(1)
        Set a = .ChartObjects(1).Chart
        .ChartObjects(1).Chart.SeriesCollection(1).Values = MyArray
    End With

Hope that's useful Smile | :)

Re: VBA under Excel

User 171649221-Nov-06 4:33

User 1716492

21-Nov-06 4:33

Chapter 6 "Using Excel's Range and Chart Objects" of Microsoft Office 2000 Visual Basic for Applicatio - fundamentals - might help. I will send the text of "Using Excel's Range and Chart Objects" to by e-mail via CP.

modified 1-Aug-19 21:02pm.

Re: VBA under Excel

⁷³Zeppelin21-Nov-06 4:37

⁷³Zeppelin

21-Nov-06 4:37

Richard A. Abbott wrote:
Chapter 6 "Using Excel's Range and Chart Objects" of Microsoft Office 2000 Visual Basic for Applicatio - fundamentals - might help. I will send the text of "Using Excel's Range and Chart Objects" to by e-mail via CP.

Ah, that would be great, thanks. I don't have any reference books handy! (As you can probably tell...) Smile | :)

Label are cut off on some computers

dptalt21-Nov-06 2:20

dptalt

21-Nov-06 2:20

When my application runs on a certain HP computer the last letter on each label on the form is cut off making the labels illegable. On all other computers we installed the application on the labels look fine. Why doesn't the HP computer display the labels correctly?

Re: Label are cut off on some computers

Yona Low21-Nov-06 4:13

Yona Low

21-Nov-06 4:13

I think its a problem with the resolution on that computer

Re: Label are cut off on some computers

Dave Kreskowiak21-Nov-06 4:33

Dave Kreskowiak

21-Nov-06 4:33

Your label boxes are being cut off because your form's layout doesn't allow for different DPI settings or resolutions. I'd direct you to the documentation and some articles on MSDN on the subject, but the MSDN site isn't responding right now.

Dave Kreskowiak
Microsoft MVP - Visual Basic

Re: Label are cut off on some computers

dptalt22-Nov-06 6:55

dptalt

22-Nov-06 6:55

Thanks.
I changed the AutoResizeMode = dpi
This fixed everthing except for some of the label controls. The code defines the location of some of the labels on the form at runtime. The code bases the locations on a 96dpi but if the app runs on a computer with a different dpi the labels are put in the wrong spot. I think I need to know the computer's dpi when calculating the locations of these labels. How can I get that?

Re: Label are cut off on some computers

Dave Kreskowiak22-Nov-06 8:21

Dave Kreskowiak

22-Nov-06 8:21

If think your talking about AutoSizeMode, not ...ResizeMode. If the AutoSizeMode is set to DPI, then you can checks the Forms CurrentAutoScaleDimensions property. It'll return a SizeF object with the current DPI of the screen.

Dave Kreskowiak
Microsoft MVP - Visual Basic

How to know the state of remote computer

farhan6821-Nov-06 2:10

farhan68

21-Nov-06 2:10

Hi there,

I am working on an application which checks the remote computer running WinXP/2k that wheather it is locked or not. I have searched every where but not able to find the solution . there is one article on this issue but it only determines the state of the local computer means application have to be installed on local computer. whereas in my case the application will run from central computer w:(hich shall check the status of remote computers on local LAN.

Please help me in this regard

Thanks

Muhammad Farhan Farooq

Re: How to know the state of remote computer

Dave Kreskowiak21-Nov-06 4:57

Dave Kreskowiak

21-Nov-06 4:57

There is no way to determine the workstation status without code running on each workstation you want to check. Even then, there is no function you can call that will tell you if the workstation is locked or not. It must be deduced using other methods. You can read more about a possible solution here[^].

Dave Kreskowiak
Microsoft MVP - Visual Basic

How to load the form in a maximized way.

ashwath197921-Nov-06 2:01

ashwath1979

21-Nov-06 2:01

Hi All,

Can anyone tell me how to load the form in a maximized way.

Re: How to load the form in a maximized way.

Tamimi - Code21-Nov-06 2:06

Tamimi - Code

21-Nov-06 2:06

Me.WindowState = FormWindowState.Maximized

When you get mad...THINK twice that the only advice
Tamimi - Code

Re: How to load the form in a maximized way.

ashwath197921-Nov-06 2:25

ashwath1979

21-Nov-06 2:25

Thank you very much.

Help on Datasets

Pete Newman20-Nov-06 23:27

Pete Newman

20-Nov-06 23:27

running vb.net 2005 & sql 2005

Ive been trying to add what seemed a simple table to a form ... only three four fields plus an update and cancel button

I managed to ( from samples ) add an OleDbConnection connecton, a OleDbDataAdapter complete with select and update commands and a dataset . From previous samples ( win 2003 dataform ) i have the four text boxex reporting back the data from the dataset ... Stage 1 complete. now here is where i was comming a cropper, when trying to update the table i used the following commands

Private Sub btnUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpdate.Click
Try
'Attempt to update the datasource.
Me.UpdateDataSet()
MsgBox(" Update sucessful")
Catch eUpdate As System.Exception
'Add your error handling code here.
'Display error message, if any.
System.Windows.Forms.MessageBox.Show(eUpdate.Message)
End Try
End Sub

Public Sub UpdateDataSet()
'Create a new dataset to hold the changes that have been made to the main dataset.
Dim objDataSetChanges As Boss.net.DebBacsFmDestAccs = New Boss.net.DebBacsFmDestAccs
'Stop any current edits.
Me.BindingContext(DebBacsFMDestAccounts1, "DebBacsFmDestAccs").EndCurrentEdit()
'Get the changes that have been made to the main dataset.
objDataSetChanges = CType(DebBacsFMDestAccounts1.GetChanges, Boss.net.DebBacsFmDestAccs)
'Check to see if any changes have been made.
If (Not (objDataSetChanges) Is Nothing) Then
Try
'There are changes that need to be made, so attempt to update the datasource by
'calling the update method and passing the dataset and any parameters.
Me.UpdateDataSource(objDataSetChanges)
DebBacsFMDestAccounts1.Merge(objDataSetChanges)
DebBacsFMDestAccounts1.AcceptChanges()
Catch eUpdate As System.Exception
'Add your error handling code here.
Throw eUpdate
End Try
'Add your code to check the returned dataset for any errors that may have been
'pushed into the row object's error.
End If

End Sub

Public Sub UpdateDataSource(ByVal ChangedRows As Boss.net.DebBacsFmDestAccs)
Try
'The data source only needs to be updated if there are changes pending.
If (Not (ChangedRows) Is Nothing) Then
'Open the connection.
Me.OleDbConnection1.Open()
'Attempt to update the data source.
OleDbDataAdapter1.Update(ChangedRows)
End If
Catch updateException As System.Exception
'Add your error handling code here.
Throw updateException
Finally
'Close the connection whether or not the exception was thrown.
Me.OleDbConnection1.Close()
End Try

End Sub

The eupdate throws the following error
"Child list for field DebBacsFmDestAccs cannot be created"

Im at a loss as to what to do now, please can anybody help

I really do need help..... all this computer stuff is way over my head !!

How to BindingData to RadioButton

kindman_nb20-Nov-06 23:17

kindman_nb

20-Nov-06 23:17

the problem is I'm designing a dataform which is liked with sql server 2000 table , on the table i have tree or more choices and I want the user to choose only one of them , i use for it a group of RadioButton but i can't binding it to the database

how can i Binding data to the radiobutton ,

thanks for all

jooooo

No one tried to aid me << my project is sopped

kindman_nb21-Nov-06 3:37

kindman_nb

21-Nov-06 3:37

hi

my working now is stopped , any one try to help me , or give me a we
Sigh | :sigh:

jooooo

Re: No one tried to aid me << my project is sopped

Kevin Nicol21-Nov-06 3:46

Kevin Nicol

21-Nov-06 3:46

I don't think anyone can understand the Question, what is you want to bind the Radio buttons to? Do you want the radio button text to come from the Database? Or the useres selection be logged in the database?

Re: No one tried to aid me << my project is sopped

kindman_nb21-Nov-06 3:56

kindman_nb

21-Nov-06 3:56

Thanks my friend

i mean bind the Radio buttons to the useres selection to be logged in the database not the text of it

i wait you

jooooo

Re: No one tried to aid me << my project is sopped

Kevin Nicol21-Nov-06 4:04

Kevin Nicol

21-Nov-06 4:04

I don't think Binding the radio buttons to a database is even possible in that manner, and if it is I don't think its the right way to go about it.

What you would probably want to do is handle the RadioButton.CheckChaged Event and then do an insert or update statement using a SLQDataAdapter or SQLCommand.

Kevin

Re: No one tried to aid me << my project is sopped

kindman_nb21-Nov-06 4:11

kindman_nb

21-Nov-06 4:11

Thanks Kevin

I use the Radio button to binding to field on the table
for ex :
on the table the user will choose between three cases ,

the method of Stock evaluation : choose on
1- FIFO
2- LIFO
3- Cost Average

I want to make the three choice as Radio button and binding it to the tree fields on database

i'm waiting your reply eagly Rose | [Rose]

jooooo

Re: No one tried to aid me << my project is sopped

Kevin Nicol21-Nov-06 7:48

Kevin Nicol

21-Nov-06 7:48

That was pretty vague but if I understand correctly there are 3 fields in a table in the database, and you want to use the radio buttons to choose which field to select from?

<br />
dim Field as string<br />
IF rdb1.checked THEN<br />
field = 'field name<br />
else if rdb2.checked THEN<br />
field = 'field name 2<br />
else<br />
field = 'field name 3<br />
end if<br />

Thas pretty bad programing style but for purpose of explination it will suffice
Now you perform the select statement

<br />
SomeAdapter.SelectCommand.CommandText = "SELECT " & Field & " FROM some table WHERE somecontraints<br />

hope that helps

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.