Results 1 to 10 of 10
  1. #1
    luckasx is offline Novice
    Windows 8 Access 2003
    Join Date
    Nov 2013
    Posts
    13

    Print lines on Access

    I'm drawing a barcode on a report with the method .line. When using pdfcreator the print is okay and using the function DoCmd.printOut and clicking on quick impression (print button) also.
    But on normal printing after open report preview this barcode doesn't print. =/
    I tried changing resolution of printer, changing color of line, change printer and nothing. There's one question alike here in stackoverflow without answer.


    Box drawn with line method on Access 2010 report displaying in print preview but not actually printing
    Any solution to this?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,926
    Have you tried installing barcode fonts?

    The code is in OnFormat event?

    Post your code.

    If you want to provide db for analysis, follow instructions at bottom of my post.

    It's quite possible that it is an either/or: Either direct to printer or Preview (then close preview and send direct to printer).
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    luckasx is offline Novice
    Windows 8 Access 2003
    Join Date
    Nov 2013
    Posts
    13
    Quote Originally Posted by June7 View Post
    Have you tried installing barcode fonts?

    The code is in OnFormat event?

    Post your code.

    If you want to provide db for analysis, follow instructions at bottom of my post.

    It's quite possible that it is an either/or: Either direct to printer or Preview (then close preview and send direct to printer).
    It is on Print event, I can't install fonts, I don't have admin rights.
    If I send direct to printer then OK, but I need see the preview before.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,926
    Try code in Detail section Format event instead of report Print event.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    luckasx is offline Novice
    Windows 8 Access 2003
    Join Date
    Nov 2013
    Posts
    13
    Quote Originally Posted by June7 View Post
    Try code in Detail section Format event instead of report Print event.
    There's no difference if format or print or both. =/

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,926
    I found a report where I use code to draw solid vertical lines. I open in Preview, then send to printer. It works.

    My code is in report Page event.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #7
    luckasx is offline Novice
    Windows 8 Access 2003
    Join Date
    Nov 2013
    Posts
    13
    Quote Originally Posted by June7 View Post
    I found a report where I use code to draw solid vertical lines. I open in Preview, then send to printer. It works.

    My code is in report Page event.
    Can you send me this code?

  8. #8
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,926
    I have 6 line controls on report. I use their Left property to set the horizontal position of lines drawn by the code. Could instead use actual numbers and remove the line controls.

    Private Sub Report_Page()
    '1440 twips per inch
    Me.Line (Me.lin1.Left, 720)-(Me.lin1.Left, 15120)
    Me.Line (Me.lin2.Left, 720)-(Me.lin2.Left, 15120)
    Me.Line (Me.lin3.Left, 720)-(Me.lin3.Left, 15120)
    Me.Line (Me.lin4.Left, 720)-(Me.lin4.Left, 15120)
    Me.Line (Me.lin5.Left, 720)-(Me.lin5.Left, 15120)
    Me.Line (Me.lin6.Left, 720)-(Me.lin6.Left, 15120)
    End Sub

    Translated:

    draw vertical line from (X, Y1) to (X, Y2)
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  9. #9
    luckasx is offline Novice
    Windows 8 Access 2003
    Join Date
    Nov 2013
    Posts
    13
    Quote Originally Posted by June7 View Post
    I have 6 line controls on report. I use their Left property to set the horizontal position of lines drawn by the code. Could instead use actual numbers and remove the line controls.

    Private Sub Report_Page()
    '1440 twips per inch
    Me.Line (Me.lin1.Left, 720)-(Me.lin1.Left, 15120)
    Me.Line (Me.lin2.Left, 720)-(Me.lin2.Left, 15120)
    Me.Line (Me.lin3.Left, 720)-(Me.lin3.Left, 15120)
    Me.Line (Me.lin4.Left, 720)-(Me.lin4.Left, 15120)
    Me.Line (Me.lin5.Left, 720)-(Me.lin5.Left, 15120)
    Me.Line (Me.lin6.Left, 720)-(Me.lin6.Left, 15120)
    End Sub

    Translated:

    draw vertical line from (X, Y1) to (X, Y2)
    Thank you for the effort. But this don't solve the question. It must be a problem with the printer I don't know.

  10. #10
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,926
    Maybe. Have you tried other printers? If you want to provide your db for analysis, follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. What are these lines on my access forms?
    By Access_Novice in forum Forms
    Replies: 1
    Last Post: 11-18-2013, 03:45 AM
  2. Replies: 3
    Last Post: 05-16-2012, 02:56 PM
  3. Printing Lines Access 2000
    By MEL117 in forum Access
    Replies: 3
    Last Post: 12-13-2011, 05:56 PM
  4. Replies: 1
    Last Post: 09-07-2011, 01:56 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums