Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Dot Matrix Printer & Access 2003

Discussion in 'Information Technology' started by Bob Barnes, Jul 28, 2006.

  1. Bob Barnes

    Bob Barnes
    Expand Collapse
    Guest

    Yes...Dot Matrix, & not really Microsoft.

    Access 2003 installed as Thin Clients...a Dot Matrix now
    Prints ONLY sideways...

    Solution?

    TIA - Bob
     
  2. Loading...

    Similar Threads Forum Date
    SciTech New Quantum Dot Technique Combines Best of Optical and Electron Microscopy Breaking News Jun 17, 2013
    Leisure Is Hell exothermic or endothermic Business, Lifestyle & Leisure Nov 9, 2011
    UK Destitute Punjabis dot London streets Breaking News Jan 28, 2011
    Inspirational The Pale Blue Dot Videos Sep 2, 2010
    Connecting The Dots In History Essays on Sikhism Mar 21, 2009

  3. UpRider

    UpRider
    Expand Collapse
    Guest

    Bob, that's pretty cryptic. Can you state the problem, and what you want as
    the solution? What kind of dot matrix printer is it? What does "not really
    Microsoft" mean? Can we assume the printer is a network printer? Help us
    out here.

    UpRider

    "Bob Barnes" <BobBarnes@discussions.microsoft.com> wrote in message
    news:6453E085-B086-46BD-9C32-1A4AC3685130@microsoft.com...
    > Yes...Dot Matrix, & not really Microsoft.
    >
    > Access 2003 installed as Thin Clients...a Dot Matrix now
    > Prints ONLY sideways...
    >
    > Solution?
    >
    > TIA - Bob
    >
    >
     
  4. Bob Barnes

    Bob Barnes
    Expand Collapse
    Guest

    Uprider,

    I got a Phone call about it.

    I'll find out tomorrow for Brand it is, & post here. I think it's NOT a
    Network
    Printer.

    I remember years ago printing Sideways for Birthday banners, etc.

    "Not really Microsoft" means I'm using the Newsgroups for a Printer question
    probably unrelated to Access. I figured, in here, w/ all the knowledge,
    there would be the Solution --- which is a "non-sideways" (normal) print.

    Will Post again in the AM - I'm East Coast USA.

    Thank you - Bob

    "UpRider" wrote:

    > Bob, that's pretty cryptic. Can you state the problem, and what you want as
    > the solution? What kind of dot matrix printer is it? What does "not really
    > Microsoft" mean? Can we assume the printer is a network printer? Help us
    > out here.
    >
    > UpRider
    >
    > "Bob Barnes" <BobBarnes@discussions.microsoft.com> wrote in message
    > news:6453E085-B086-46BD-9C32-1A4AC3685130@microsoft.com...
    > > Yes...Dot Matrix, & not really Microsoft.
    > >
    > > Access 2003 installed as Thin Clients...a Dot Matrix now
    > > Prints ONLY sideways...
    > >
    > > Solution?
    > >
    > > TIA - Bob
    > >
    > >

    >
    >
    >
     
  5. Bob Barnes

    Bob Barnes
    Expand Collapse
    Guest

    The Printer is an Epson LX-300+ & is NOT a Network Printer.

    HTH - Bob

    "UpRider" wrote:

    > Bob, that's pretty cryptic. Can you state the problem, and what you want as
    > the solution? What kind of dot matrix printer is it? What does "not really
    > Microsoft" mean? Can we assume the printer is a network printer? Help us
    > out here.
    >
    > UpRider
    >
    > "Bob Barnes" <BobBarnes@discussions.microsoft.com> wrote in message
    > news:6453E085-B086-46BD-9C32-1A4AC3685130@microsoft.com...
    > > Yes...Dot Matrix, & not really Microsoft.
    > >
    > > Access 2003 installed as Thin Clients...a Dot Matrix now
    > > Prints ONLY sideways...
    > >
    > > Solution?
    > >
    > > TIA - Bob
    > >
    > >

    >
    >
    >
     
  6. UpRider

    UpRider
    Expand Collapse
    Guest

    Bob, here's an entire vba module that I use to print to a legacy Epson LQ500
    printer. Probably you can determine the correct escape sequence to reset the
    LX300 and use this code to send it to the printer. This code requires the
    printer to be attached to the parallel port.
    What's a little strange in the sideways print problem is that when the
    printer is shut off and then turned back on, it will initialize to default
    settings. In order to print sideways, some existing software must be sending
    an escape sequence that puts the printer into graphics mode (there is no
    native sideways font).
    The LQ500 supports a self test. With paper loaded and the printer OK to
    print, turn it OFF. While holding down the line-feed button, turn the
    printer ON and release the line-feed button. To stop the self test, press
    the on-line button. I suspect that all this applies to the LX300 also.
    UpRider

    Option Compare Database
    Option Explicit
    'PRINT TO LPT PORT TO EPSON 500
    '---------------------------------------------------------------------------------------
    ' Procedure : subPrintDotMatrixLabels
    ' DateTime : 7/16/2002 10:19
    ' Author : David
    ' Purpose : Access reports always eject a page at eoj, which wastes
    tractor feed labels.
    ' : This sub prints directly to lpt1 a line at a time.
    ' : myquery is the data source for the labels, arg controls type
    of label to print;
    ' : 0 or null - print regular label
    ' : 1 - print sticker label to ask for new email address
    '---------------------------------------------------------------------------------------
    '
    Sub subPrintDotMatrixLabels(myquery As String, Optional arg As Integer)
    Dim intBlankline As Integer
    Dim x As Integer
    Dim db As DAO.Database
    Dim rst As DAO.Recordset
    Dim qdf As DAO.QueryDef
    On Error GoTo subPrintDotMatrixLabels_Error

    Set db = CurrentDb()
    Set qdf = db.QueryDefs(myquery)
    Set rst = qdf.OpenRecordset()
    Open "LPT1" For Output As #1
    'Initialize printer, Epson 500
    Print #1, Chr(27) + Chr(120) + "1" + Chr(27) + Chr(67) + "6" + Chr(27) +
    Chr(77)
    ' Print #1, Chr(27) + Chr(77)
    Select Case arg
    Case 0
    Do While Not rst.EOF
    intBlankline = 3
    Print #1, LTrim(rst![FIRST] & " " & rst![LAST])
    Print #1, rst![ADDR1]
    If Len(rst![ADDR2]) > 0 Then
    Print #1, rst![ADDR2]
    intBlankline = intBlankline - 1
    End If
    Print #1, rst![CITY] & " " & rst![ST] & " " & rst![ZIP]
    For x = 1 To intBlankline
    Print #1, " "
    Next
    rst.MoveNext
    Loop
    'advance 5 lines (1 label)
    intBlankline = 5
    For x = 1 To intBlankline
    Print #1, " "
    Next x
    Close #1
    Case 1
    Do While Not rst.EOF
    Print #1, LTrim(rst![FIRST] & " " & rst![LAST])
    Print #1, rst![ME_MAIL]
    Print #1, "Your Emailed Newsletter bounced. Please"
    Print #1, "update your email addr at www.dbtc.org"
    Print #1, " "
    Print #1, " "
    'print #1, " "
    rst.MoveNext
    Loop
    'advance 5 lines (1 label)
    intBlankline = 5
    For x = 1 To intBlankline
    Print #1, " "
    Next x
    Close #1
    End Select

    subPrintDotMatrixLabels_Exit:
    On Error Resume Next
    rst.Close
    Set rst = Nothing
    Set qdf = Nothing
    Set db = Nothing
    Exit Sub
    subPrintDotMatrixLabels_Error:
    Call fcnLogError(Err.Number, Err.Description, "Procedure
    subPrintDotMatrixLabels" & " of basLPTprint", , True)
    Resume subPrintDotMatrixLabels_Exit
    End Sub




    "Bob Barnes" <BobBarnes@discussions.microsoft.com> wrote in message
    news:71510B43-6C71-454A-BF46-6AB7FFD10F0E@microsoft.com...
    > The Printer is an Epson LX-300+ & is NOT a Network Printer.
    >
    > HTH - Bob
    >
    > "UpRider" wrote:
    >
    >> Bob, that's pretty cryptic. Can you state the problem, and what you want
    >> as
    >> the solution? What kind of dot matrix printer is it? What does "not
    >> really
    >> Microsoft" mean? Can we assume the printer is a network printer? Help
    >> us
    >> out here.
    >>
    >> UpRider
    >>
    >> "Bob Barnes" <BobBarnes@discussions.microsoft.com> wrote in message
    >> news:6453E085-B086-46BD-9C32-1A4AC3685130@microsoft.com...
    >> > Yes...Dot Matrix, & not really Microsoft.
    >> >
    >> > Access 2003 installed as Thin Clients...a Dot Matrix now
    >> > Prints ONLY sideways...
    >> >
    >> > Solution?
    >> >
    >> > TIA - Bob
    >> >
    >> >

    >>
    >>
    >>
     
  7. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    Bob Barnes <BobBarnes@discussions.microsoft.com> wrote:

    >Yes...Dot Matrix, & not really Microsoft.
    >
    >Access 2003 installed as Thin Clients...a Dot Matrix now
    >Prints ONLY sideways...


    I dunno about blaming that one on Microsoft Access. Does it print
    sideways from non MS Access apps?

    Access doesn't muck with printer drivers or settings. It just uses
    the settings.

    Tony
    --
    Tony Toews, Microsoft Access MVP
    Please respond only in the newsgroups so that others can
    read the entire thread of messages.
    Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.granite.ab.ca/accsmstr.htm
     

Share This Page