Jump to content

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



  • 47 When would you like EduGeek EDIT 2025 to be held?

    1. 1. Select a time period you can attend


      • I can make it in June\July
      • I can make it in August\Sept
      • Other time period. Comment below
      • Either time

×
×
  • Create New...