Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Can I run my Access functions in Excel?
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...- eaglehill
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
-
opening forms from another form
Try this: DoCmd.Openform "form42", , , "acctno=" & "'" & Me.AcctNo & "'" you gotta put quotes around the text data type so it looks like: acctno = '4-1000'- eaglehill
- Post #2
- Forum: Microsoft: Access Forms
-
How to Create a Desktop Shortcut for a Form- Access Window Hidden
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...- eaglehill
- Thread
- Replies: 0
- Forum: Microsoft: Access Forms
