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

Another missing reference question

Status
Not open for further replies.

Zygor

Technical User
Apr 18, 2001
271
US
Is there a way to trap a missing reference error so the program won't stop when it opens?
 
Roy, Thank you for reponding. It seems I can always count on you (and others of course!)

Here's my situation and my resolution

Situation-
I have a database that creates databases and sends them to co-workers. My database has the reference removed, but when it makes a new one, via vba, the new one has the reference and it's sent to others where it errors when they launch it.

Resolution-
In code, (after I create the database, before I bring in all the forms, modules(except one), reports...I need), I first send in a macro that I can run from my program that runs the one module I bring in that removes the reference. Then I finish the rest of the routine.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top