Search results for query: *

Guys, Thanks for responses. seaport - I will give it a try. dhookom - I'm not sure what you mean by your question. I have set up the report so that when you select the parameters via combo boxes then hit a command button the report displays in print preview. I also have created a small...

Guys, I have created a report. In the heading I have created a text box that looks at the combo box that is used to set the criteria for the report and displays it on the form with the following: =[forms]![frmInput]![Combo11] The data from the combo box is displayed during a print preview...

TomCologne, Thanks for your help. mondoray [ponder]

Guys, Can anybody give me help or direct me to a FAQ, etc on how to create multiple page reports. I have a report that has graphs. I need to present two graphs per page. I have eight graphs to present (4 pages). Many thks. mondoray [ponder]

PHV, Many thks. mondoray [ponder]

PHV, With the "Like V" above I need to have the cursor remain on that filed when the validation rule is not met. I have tried: [Aircraft Registration].SetFocus & SendKeys "+{Tab}" both default. Any suggestions? mondoray [ponder]

PHV, Your a star. Many thanks mondoray [ponder]

Guys, I would like to ask another question on validation rule. I have a field which the data has to be either: MEL or MJB or PER or ADL. How do I set the validation rule to have multiple responses? Can I use the above with multiple like criteria? mondoray [ponder]

PHV, Many thanks mondoray [ponder]

lespaul, Many thks. I will give it a try. mondoray [ponder]

Golom, Thanks for your help. I have used your suggestion as below: Private Sub Aircraft_Registration_BeforeUpdate(Cancel As Integer) If Not (Len(Value) = 3 And Left$(Value, 1) = "v") Then MsgBox "Aircraft registration must start with a V...", vbExclamation, "Invalid data..." Else 'Save value...

GingerR, Thks mondoray [ponder]

GingerR, How do I express your above code to ensure the data entered has three letters and starts with a "V"? mondoray [ponder]

GingerR, Thanks a million. mondoray [ponder]

GingerR, Thanks. I wasn't sure that it would prevent the standard msgbox from appearing. My application has the validation rule in the table set to Like"V??" I will give it a try. mondoray [ponder]

Guys, Is there a way to prevent the standard MS Access validation rule warning msgbox appearing and create your own msgbox? mondoray [ponder]

Gnism, I will give it a try. Many thks mondoray [ponder]

Guys, I have a field on a form (and the associated table)that has the input mask set as: 00\-00\-000 As the data is entered it allows the operator to enter without inseting the dashes. When the data is displayed (field lostfocus) the dashes are missing and I'm left with: 0406987 What I'm...

RoyVidar, It is now. Many thks for your help. mondoray [ponder]

Guys, I have used the following code to disable the PgUp and PgDn keys in one of my forms and it is not working. Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) If (KeyCode = vbKeyPageUp) Or (KeyCode = vbKeyPageDown) Then KeyCode = 0 End If End Sub Any suggestions...