Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2016
    Posts
    2

    Unanswered: Button: PRINT MULTIPLE FILE IN HYPERLINK (LOCATED IN SPECIFIC FOLDER)

    Microsoft Access 2010

    Hi,

    I'm trying to create a button that will print all attach file in hyperlink which located in a specific folder.

    Printing the file with specific page.

    Scenario:

    I had 10 rows of data with attach file and need to open one by one and print the file.

    Improvement:

    Create a button to print all the file attach on each rows.


    Thanks,
    memento

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    so normalise your design
    stoire the URL's in a 'child' table, then iterate throught he relevant data in that table and print each doucment as required
    stuffing multiple chunks of data in a memo field is poor, lazy and compalcent desing.

    memo works fine for unclassified data, eg details of a phone conversation or meetign or free form text
    using it to store URL's violartes normalisation, and in part thats why you are now strugglign to find a way fo doiung what you want.

    I guess if yiou must persist with your design you coudl pass the memo to a VBA procedure that iterates through the memo column and doies the same job... but its messy
    I'd rather be riding on the Tiger 800 or the Norton

Tags for this 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
  •