+ Post New Thread
Results 1 to 2 of 2
Office Software Thread, Strange MSAccess printing problem with .vbs in Technical; I have created a GUI with autoit with some buttons, which when pressed execute a .vbs script which prints out ...
  1. #1

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    4,510
    Blog Entries
    6
    Thank Post
    930
    Thanked 402 Times in 257 Posts
    Rep Power
    141

    [SOLVED] Strange MSAccess printing problem with .vbs

    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:

    Code:
    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!?
    Last edited by RabbieBurns; 31st January 2009 at 08:35 PM.

  2. #2

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    4,510
    Blog Entries
    6
    Thank Post
    930
    Thanked 402 Times in 257 Posts
    Rep Power
    141
    Solved. I increased the thickness of the lines on the table, and they all seem to print fine now. Wierd.

SHARE:
+ Post New Thread

Similar Threads

  1. Bat calling VBS problem
    By MK-2 in forum Scripts
    Replies: 5
    Last Post: 16th December 2008, 12:08 AM
  2. Strange AD Problem
    By Michael in forum Windows
    Replies: 3
    Last Post: 25th February 2008, 03:05 PM
  3. Strange header problem
    By dagza in forum EduGeek Joomla 1.0 Package
    Replies: 2
    Last Post: 21st January 2008, 10:14 PM
  4. Strange Email Problem
    By richard in forum Windows
    Replies: 4
    Last Post: 15th June 2007, 07:58 AM
  5. Very strange problem...
    By Maxell in forum Windows
    Replies: 7
    Last Post: 5th February 2007, 05:01 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •