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!

Automated Linked Table manager

Status
Not open for further replies.

YoungManRiver

IS-IT--Management
Feb 9, 2004
220
US
All,

I added my auto re-linking code to my "Main Form" init sequence to automatically re-link my linked tables.

However I still am getting errors, before it gets to the code. Looks like I need to link in my code somewhere else to catch the application init instead of the form init.

Where do I do this and how? Was assuming the tools+startup but did not see it there, or maybe I'm blind.

YMR
 
Did you put the code in the Open event procedure of your startup form ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
PHV,

No never had to do this before and code is in class module so normally called with:
Sub Form_Load()
Dim SCRNfields as clsTABLES
Set SCRNfields = New clsTABLES
Set SCRNfields.TargetForm = Me
SCRNfields.Link_TBLs
End Sub
How do I call this in the startup, is there a method or code example of this?

YMR
 
What happens if you move the code from the Load to the Open event procedure ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top