Set the timer interval to 60000 and in the timer event check the time property if it is equal to 7 PM Hope this helps if not let me know
Jn88
Jn88@att.net
I said “it is a trick” there is actually no way of closing the combo box but by sating the combo box enabled property to false and then back to true it will close itself, I hope you get it. Hope this helps if not let me know
Jn88
Jn88@att.net
Set the forms record looks property to "Edited Record" and then use this in the forms current event
(StartIssue is one of my fields)
Private Sub Form_Current()
On Error GoTo InUse_Err
If Not IsNull(StartIssue) Then
Me!StartIssue = Me!StartIssue
Me.Refresh
End If
Exit Sub...
Public Sub PrintReportCopys(Amount As Integer)
Dim i As Integer
For i = 1 To Amount
DoCmd.OpenReport "ReportName", acViewNormal
Next i
End Sub
Hope this helps if not let me know
Jn88
Jn88@att.net
Don’t put the code in the property window!
Select event procedure and invoke the code builder and past the code in the code window
Hope this helps if not let me know
Jn88
Jn88@att.net
Put this code in the Detail onFormat Event:
If FormatCount < 30 Then Me.NextRecord = False
30 stands for the amount of labels you want to print Hope this helps if not let me know
Jn88
Jn88@att.net
I don’t know how you want to use your help file
but I would do like this
Add a new menu and in the property’s in the on Action put in the function name like this:
=CallHelp()
and write a function in a module "CallHelp" and from there call the help file.
Hope this helps if not let me...
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.