ACCESS FORM an VB FORM

[Luis Moises Rojas]

Does anyone know how can i execute ACCESS FORM FROM VB?

P.D.: ACCESS 2000 can convert Your ACCESS APP into SQL and IT works FINE. This mean: ANY INFORMATION YOU ADD it is stored in a SQL TABLE. ANY QUESTION or SOMETHING I SHOULD KNOW?

[David Laplante]

Take a look at this thread:
http://forums.vb-world.net/showthread.php?threadid=868

[jtm7699]

real easy

Dim appAccess As Access.Application
Dim strDB As String
Dim strconpathtosamples As String
strconpathtosamples = App.Path & "\has.mdb"

strDB = strconpathtosamples & "has.mdb"

' Create new instance of Microsoft Access.
Set appAccess = _
CreateObject("Access.Application")

' Open database in Microsoft Access window.
appAccess.OpenCurrentDatabase strconpathtosamples

' Open Orders form.
appAccess.DoCmd.OpenForm "Orders"

'open report
appAccess.DoCmd.OpenReport "Audiology Clinic Summary", acViewPreview

appAccess.Visible = True