Can I hide the CreateObject 1

[99Chuck99]

I'm tring to print a report from a Access database from web page. The following code prints the report but I would like to hide the Access application from showing on screen objAcc.visible does not seem to work. Any ideas would be greatly appriciated.

<SCRIPT language=vbscript event=onclick for=command0>
Set objAcc = CreateObject("Access.Application")
objAcc.visible=false
objAcc.OpenCurrentDatabase "\\Kscboc2\Share\Jbosc\Rpi\Databases\FERB.mdb"
objAcc.DoCmd.OpenReport "AGENDA"
objAcc.Quit
Set objAcc = Nothing
</SCRIPT>

 

[jasonp45]

When I create the Access.Application object and OpenCurrentDatabase I don't get a window, so I believe the window becomes visible when you open the report.

I would try DoCmd.Minimize before (or after) opening the report. If minimizing isn't acceptable you can investigate hiding the window here:

http://www.tek-tips.com/faqs.cfm?fid=2562

 

[PHV]

You may try this:
objAcc.DoCmd.OpenReport "AGENDA", 0, , , 1

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886