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...
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,
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]
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]
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,
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,
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.