Results 1 to 5 of 5
  1. #1
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Printing a file inside Access (Access 2000 SP6)

    I am stumped by this one, although I'm sure it's simple to someone else.
    How do I print a normal .txt file from within Access?
    Pat <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Printing a file inside Access (Access 2000 SP6)

    I don't know how to do it Pat, but I have just noticed that in <post#=20196>post 20196</post#> Hans talks about ShellExecute and says that:
    <pre>ShellExecute provides the equivalent of opening (or printing) a file in Windows Explorer.</pre>

    Regards
    John



  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Printing a file inside Access (Access 2000 SP6)

    I worked it out, it wasn't so hard after all.
    I linked to the text file using transfertext. Then I based a report on a single field from the table in new courier mode to keep the text formatting.
    Pat <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  4. #4
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Printing a file inside Access (Access 2000 SP6)

    Thanks John, but as you can see I have solved the problem another way.
    Pat <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  5. #5
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    160
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing a file inside Access (Access 2000 SP6)

    Is there any example to understand well pls .
    ashrafk

Posting Permissions

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