Results 1 to 8 of 8
  1. #1
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Convert to PDF (2000)

    In the access db we have we print letters to the individual record on display, offer letters, etc. What we want to do is that once these have been printed to the printer is that a copy is kept on the db ina pdf format? |Is this possible? Then we would then be able to look on a tab control called 'Document Store' and see the files listed and recall them by double clicking on them?
    Best Regards,

    Luke

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Convert to PDF (2000)

    You shouldn't store PDF files in the database itself. Instead, store them in a folder. You'll find many threads in this forum about exporting reports to PDF. You can store the path and filenames in a table in the database, either as a hyperlink field or as a text field. With a hyperlink field, the user can click the field directly to open the PDF file; with a text field, you can put code in the On Click event of a command button that executes Application.FollowHyperlink to open the PDF file.

  3. #3
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Convert to PDF (2000)

    HaNS,

    My plan would be to create the pdf in a folder and then link to the file. It would give it a unique filename, e.g. the autonumber in a table that hold the information about that:

    DocID, PropID, PurchID, Location, CreatedDate

    Then in the Property form you could see all the documents relating to it, e.g generic letters, offer form, sales forms etc and view them if you wish. Is this possible, any pointers?
    Best Regards,

    Luke

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Convert to PDF (2000)

    You'd create a separate table with a separate record for each PDF file, and display this table in a subform of the main form, linked together by PropertyID.

  5. #5
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Convert to PDF (2000)

    What i am seeking guidance on is the following:

    We will print a letter from a command button to go to a printer, which is fine, it sends it to word, the print dialogue box comes up, etc. Then after that we also want a pdf copy, so when this happens it create a new record in the tblpdfstore of propertyid, purchid, etc etc with a link to the filename e.g. ServerDatabasePDFStore8765.pdf

    I gues that the filename should repliccate the autonumber for ease, but how do you get the pdf printer to print save it to that directory with the filename?
    Best Regards,

    Luke

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Convert to PDF (2000)

    Which PDF program are you using? Adobe's, or ...?

  7. #7
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Convert to PDF (2000)

    Any, I do have acrobat v6 installed, but flexible as long as it does the job and the easiest one to use!
    Best Regards,

    Luke

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

    Re: Convert to PDF (2000)

    Have a look at pdf995 available from http://www.software995.com/ . If you also install PDFEdit, you can configure it to automatically name and save the pdf file as it is created. You can then use code to copy or rename the file using the ID number as the file name.

    You can use PDF995 for free, but if you pay a small registraion fee you avoid the advertsiing.
    Regards
    John



Posting Permissions

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