I would try to add a macro to direct the program to the form in MS Access, is
it possible? Can someone help to write the code if it is possible? If not,
any suggestions?
--
Dennis Cheung

Try this (change code in *BOLD* below to your references):

Code
-------------------
Sub testMSAccess()
Dim appAccess As Object
' Create instance of Access Application object...
Set appAccess = CreateObject("Access.Application")
' Make the Access application visible...
appAccess.Visible = True
' Open Access database...
appAccess.OpenCurrentDatabase "*C:\your directory\YourDB*.mdb", False
' Open form in Access database...
appAccess.DoCmd.OpenForm "*YourForm*", acNormal

'...your code to manipulate Access form goes here...

' Release the Access application...
Set appAccess = Nothing
End Su
-------------------

Hope this helps,
theDud

--
theDud
-----------------------------------------------------------------------
theDude's Profile: http://www.excelforum.com/member.php...fo&userid=1655
View this thread: http://www.excelforum.com/showthread.php?threadid=46869