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

how can I use a global fonction from another DB

Status
Not open for further replies.

KiaKia

Programmer
Mar 30, 2008
59
US
Hi,
I am working on a Access DB and I need to call a global function from a second database in my VB codes.
I know that I have to set a reference but i do not know how.????

Kia

 
Well, in the Add References dialog box you can change "File Type" to look for Access databases (MDB), then browse to the other Access file and choose it. Then you will have access to all it's Public functions.

However, it would probably be a lot simpler to just Copy & Paste the function from the one MDB file to the other. It's more overhead to call the function on another DB, and the reference to the other MDB file will be very easily broken.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top