Jump to content
EduGeek EdSec 2026 is Go! 27th Oct in Derby! Join us for a day of EdTech security focused talks, networking, and an evening social ×

Recommended Posts

Posted (edited)

I have created a GUI with autoit with some buttons, which when pressed execute a .vbs script which prints out various reports from an Access Database:

 

Set objAccess = CreateObject("Access.Application")
objAccess.OpenCurrentDatabase "\\server33\wwwroot\s4\fpdb\s4.mdb"

Set objCommand = objAccess.DoCmd

objCommand.OpenReport "Subject Reports"


objAccess.CloseCurrentDatabase

MsgBox "Reports sent to the printer...",64,"School Reports"

 

It works fine, but the problem is, that when doing it this way, some horizontal lines Ive used in making a table in the report just dont print. On any printer, any time.

 

When opening the database manually and printing the report that way, the lines print OK.

 

Im at a loss... Any idea why doing it this way might make the lines vanish!?

Edited by RabbieBurns

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now



×
×
  • Create New...