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

Runs from one Database not another?

Status
Not open for further replies.

netrusher

Technical User
Feb 13, 2005
952
US
I have several visual control boards, each one has its own
database. In each database we have a form with the same
buttons running queries and one opens a file on a network
drive. See Code Below. My question is from one database it
opens the file just fine. From another database I get the
following error:
Compile Error: Sub or Function not defined
I cannot figure out why it works from one database and not
the other. I hope someone can straighten me out.

Code:
Private Sub RunPartsMonitorTransfer_Click()

Call ShellExecute(Hwnd, "open", "S:\Eng\VisualControlBoards\Parts Monitor.dtf", 1, vbNullString, 1)

End Sub
 
I found I had a call module in one database and not the other.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top