08-30-16, 06:54 #1Registered User
- Join Date
- Aug 2016
Unanswered: Button: PRINT MULTIPLE FILE IN HYPERLINK (LOCATED IN SPECIFIC FOLDER)
Microsoft Access 2010
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.
I had 10 rows of data with attach file and need to open one by one and print the file.
Create a button to print all the file attach on each rows.
08-30-16, 07:07 #2Jaded Developer
Provided Answers: 59
- Join Date
- Nov 2004
- out on a limb
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 messyI'd rather be riding on the Tiger 800 or the Norton