lvermeersch
Jan 22nd, 2006, 03:47 AM
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.
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.