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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. eaglehill

    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...
  2. eaglehill

    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'
  3. eaglehill

    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...

Part and Inventory Search

Back
Top