Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2004
    Posts
    5

    Angry Unanswered: Printing in MS Access

    Hi all,
    I am using MS Access, i have a query like "Select * from emp" this query returns some results, and i have populated a recordset for this.

    Now i want to print each record in a seperate paper using my default printer.

    Any one has any idea how to do that. or any API available for printing in VBA.

    I need this ASAP, plz inform me if you have any idea about it.

    Regards.

    Osa.

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Make a report, which RecordSource is your query. Then your can print it

  3. #3
    Join Date
    Sep 2004
    Posts
    5

    Angry Still have problem

    Thanks for your reply,

    but i also want to do some composing related stuff, for example i want Name should be displayed at top left corner and age should be displayed at bottom right corner.........

    How it is possible?

    Regards,

  4. #4
    Join Date
    Jul 2004
    Location
    Inverurie
    Posts
    628
    could you make your VB code save the query and then generate a report through normal channels?

  5. #5
    Join Date
    Jun 2004
    Location
    Florida, US
    Posts
    521
    you can still do that with a report. I don't see what is the problem.
    ghozy.

  6. #6
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    You can do that in the report formation by moving your text box tho the desired place you want

  7. #7
    Join Date
    Sep 2004
    Posts
    5
    Thank u all
    its done, by making a report and printing is carried out by using docmd.openreport().

    Thank u once again.

    Regards.

Posting Permissions

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