Visual Basic - Window API MS Access

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Window API MS Access

Leon Johnson

2004-10-27, 3:55 pm

Do anyone know how I can open a MS Access Table from VB, so it will open in a
Access Window. When I do it I just get a blank page. And where on Microsoft
can I find more information about this subject.

Jeff Johnson [MVP: VB]

2004-10-27, 3:55 pm

"Leon Johnson" <Leon Johnson@discussions.microsoft.com> wrote in message
news:2031B4A2-0E93-4BE9-8FF0-A41B78292ACC@microsoft.com...

> Do anyone know how I can open a MS Access Table from VB, so it will open
> in a
> Access Window. When I do it I just get a blank page. And where on
> Microsoft
> can I find more information about this subject.

You would do this by Automating Access. It would look something like this
(warning--air code):

Dim accApp As Object
Set accApp = CreateObject("Access.Application")
accApp.Visible = True
accApp.DoCmd.OpenTable "MyTable"

Sponsored Links