|
-
Jan 22nd, 2006, 04:47 AM
#1
Thread Starter
Lively Member
Open Access Link Table Dialog window through code
I know how to use Commandbar and CommandbarPopup vars
to get the correct menuID to use cbars.findControl("ID:=....") to open the correct menuoption. So you get the same effect as you would choose the menuoption, the correct window then opens.I now need this system to open the Acces Table Link window
What i want is following
I open Access through Access automation in my VB6 app, with
Appa.OpenCurrentDatabase FilePath:=Databastand
Then i get an open window with the current database
Normally i choose in that windowmenu, New
then in that opened window i choose Link
So this opens a dialog window where you can browse to your linked table
I want directly go to that step so Table Linkdialog window is opened through code. Need some help for this .
Added Info:
I now found how to open the Add Table window through the code.
I got the menu ID from menu, Insert,Table op the main form.
So i get the window with a listbox where i can choose Import or Link.
I suppose this is sufficient. I gess it's not necesarry that the Link option in the selectbox is selected, maybe this can by different in other access versions or other languages. Or i should find a way to directly open the Link dialog window and allso for the Import dialog window but if not possible i use what i have now.
Last edited by lvermeersch; Jan 22nd, 2006 at 06:24 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|