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?
Printable View
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?
Take a look at this thread:
http://forums.vb-world.net/showthread.php?threadid=868
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