Results 1 to 8 of 8

Thread: print access form to specific printer

Hybrid View

  1. #1
    Frenzied Member KGComputers's Avatar
    Join Date
    Dec 2005
    Location
    Cebu, PH
    Posts
    2,024

    Re: print access form to specific printer

    I think there is a command in vb 6.0 to let the user choose the correct printer
    when a command button for print is clicked. The command can also be applied to access vba..

    Have you tried doing research on the parameters of OpenReport?

    greg
    CodeBank: VB.NET & C#.NET | ASP.NET
    Programming: C# | VB.NET
    Blogs: Personal | Programming
    Projects: GitHub | jsFiddle
    ___________________________________________________________________________________

    Rating someone's post is a way of saying Thanks...

  2. #2

    Thread Starter
    New Member
    Join Date
    May 2007
    Posts
    8

    Re: print access form to specific printer

    Hi, thanks for that suggestion, as i said i know a little vbscript but this is way beyond me but it makes sense to check out the parameters of OpenReport, i'll try that and see what i can find on that.

    I just don't understand how this line opens and prints the doc..
    Code:
    DoCmd.OpenReport stDocName, acNormal

  3. #3
    Frenzied Member KGComputers's Avatar
    Join Date
    Dec 2005
    Location
    Cebu, PH
    Posts
    2,024

    Re: print access form to specific printer

    hi,

    so, you are using vbscript for your asp applications..well, that's similar to vba except for some syntax for the web...

    stdocname stands for the report document name while acnormal denotes printing directly to printer...acpreview for previewing first before printing...

    greg
    CodeBank: VB.NET & C#.NET | ASP.NET
    Programming: C# | VB.NET
    Blogs: Personal | Programming
    Projects: GitHub | jsFiddle
    ___________________________________________________________________________________

    Rating someone's post is a way of saying Thanks...

  4. #4

    Thread Starter
    New Member
    Join Date
    May 2007
    Posts
    8

    Re: print access form to specific printer

    Hi, thanks for the explanation, but i couldn't find any examples of parameters that would select a printer to print to. i am unable to test the application because it is linked with sage on the network, i would have to go to the company and test it there - so trial and error isn't an option...
    would something like this work?

    Code:
    Application.Printer = Application.Printers("my specific printer")

Posting Permissions

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



Click Here to Expand Forum to Full Width