I wrote an Access database that tracks manufacturing data. I have some functions that query the data like this:
GetProcessYieldAvg(ProcessName, TimePeriod, StartTime, EndTime) as Double - example: PlatingProcess, Month, January 08, March 08 would return 93.8%
It returns the average monthly...
Try this:
DoCmd.Openform "form42", , , "acctno=" & "'" & Me.AcctNo & "'"
you gotta put quotes around the text data type so it looks like: acctno = '4-1000'
New Poster Here! Hello!
This routine will create a shortcut on the user's desktop that will just open up a form, the Access main window is hidden.
1- Create a macro that opens the form in Window Mode: Dialog
2- (optional)I usually have a "Close" command button that is coded...
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.