Results 1 to 1 of 1

Thread: Open Access Link Table Dialog window through code

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Oct 2005
    Posts
    91

    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
  •  



Click Here to Expand Forum to Full Width