Results 1 to 5 of 5

Thread: Printing Questions

  1. May 11th, 2005, 10:22 AM #1
    SherryDonaldson
    SherryDonaldson is offline

    Thread Starter
    New Member
    Join Date
    May 2005
    Posts
    8

    Question Printing Questions

    Will adding just:

    Printer.Print "Test"
    Printer.EndDoc

    be enough to send Test to automatically print out? If not, what do I need to add in front of that to make it print out? I keep reading about a print object or print method but I have never used VBA before. Please help. Thanks!
    Reply With Quote Reply With Quote
  2. May 11th, 2005, 10:26 AM #2
    szlamany
    szlamany is offline
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    Re: Printing Questions

    You might be better served posting this in the VB or VBA forums here - this might be too specific for the DATABASE DEVELOPMENT forum...

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:     [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008
    Reply With Quote Reply With Quote
  3. May 12th, 2005, 07:28 AM #3
    si_the_geek
    si_the_geek is offline
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: Printing Questions

    (moved thread to VBA forum)
    (Microsoft MVP from July 2007 to June 2017) . . . . . . . . . . Hitchhiker's Guide to Getting Help at VBForums

    Database Development FAQs/Tutorials (updated May 2011) (includes fixing common DB related errors, and [VB.Net] ADO.Net Tutorial, and [Classic VB] ADO tutorial /further steps)
    other useful DB bits: . Connection strings (alternative copy).•. MDAC/Jet/ACE downloads .•. SQL Server downloads .

    Classic VB FAQs (updated Oct 2010) (includes fixing common VB errors)
    some of my Classic VB bits: . Tutorial: How to automate Excel from VB6 (or VB5/VBA) .•. SQL 'Select' statement formatter/checker .•. Convert colour number to colour name .•. FlexGrid: fill from recordset .•. FlexGrid: AutoSize columns .•. DB Reserved Words checker .
    Reply With Quote Reply With Quote
  4. May 13th, 2005, 08:31 AM #4
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Printing Questions

    Quote Originally Posted by SherryDonaldson
    Will adding just:

    Printer.Print "Test"
    Printer.EndDoc

    be enough to send Test to automatically print out? If not, what do I need to add in front of that to make it print out? I keep reading about a print object or print method but I have never used VBA before. Please help. Thanks!
    The answer to your question is Yes. Your code example will send the word "Test" to print.
    Reply With Quote Reply With Quote
  6. May 22nd, 2005, 05:48 AM #5
    baviskarmitesh
    baviskarmitesh is offline
    Junior Member
    Join Date
    May 2005
    Location
    Jalgaon, Maharashtra, India
    Posts
    22

    Talking Re: Printing Questions

    Yes
    Even You can only send
    printer.print
    printer.endDoc
    and testing of printer will be done
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width