Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Opening an Access Report

Status
Not open for further replies.

cscott

Programmer
Feb 28, 2002
7
US
I'm using the following code:

<Script Language=&quot;vbscript&quot; >
Dim objaccess
Set objaccess = CreateObject(&quot;Access.Application.8&quot;)
objaccess.OpenCurrentDatabase &quot;Reference.mde&quot;
objaccess.visible=True
objaccess.UserControl = True
'objaccess.CloseCurrentDatabase
'set objaccess=Nothing
</Script>

Our system has both Access97 and Access 2002 installed. This seems to work okay except the Access window opens and only has the title bar visible. I've tried the DoCmd.Maximize in the code as well as have the Maximize statement in the autoexec macro.

Is there any other way to decisively force Access97 to open every time and maximize the window? It seems that some computers want to open Access 2002 on occasion regardless.

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top