N
NetworkTrade
happy new year. rather then just ask a strange question I'll give the
"why?"...maybe will help: Here's the story: User has a 2003 db for
employees. Employees have many certificates as scanned images. Hyperlink
field in a table to all these images. You can pull up an employee - look at
various normal employee data and also click any of the employee's hyperlinks
to view their various certificates.
Certificates are by state, or by skill, or both. Many they scan in
themselves as jpg, some are delivered by regulatory offices as pdf. A highly
skilled, long time employee willing to travel might have 30 certificates -
while a newer employee might have just a couple.
Overall they've done the right thing using the tools offered by Access. The
images are not embedded to cause db bloat. It works.
For a project they may need 15 employees, each with 3+ relevant certificates
- all these have to be printed to be at the job site. They are tired of
having to open each hyperlink and print individually - would like a one
button print all. Setting up a form that guides the user thru a select query
that results in the subset of 15 employees into a query result with all the
correct hyperlink fields, records is no problem. It's the 'print all' that
I'm stymied a bit. 15 records; each record has a text field with employeeID
and then usually 2 or 3 but potentially up to 10 hyperlink fields with
hyperlinks (some blank).
Have browsed around in my spare time chipping away at various approaches -
but nothing really yet seems workable and would welcome input. thanks.
"why?"...maybe will help: Here's the story: User has a 2003 db for
employees. Employees have many certificates as scanned images. Hyperlink
field in a table to all these images. You can pull up an employee - look at
various normal employee data and also click any of the employee's hyperlinks
to view their various certificates.
Certificates are by state, or by skill, or both. Many they scan in
themselves as jpg, some are delivered by regulatory offices as pdf. A highly
skilled, long time employee willing to travel might have 30 certificates -
while a newer employee might have just a couple.
Overall they've done the right thing using the tools offered by Access. The
images are not embedded to cause db bloat. It works.
For a project they may need 15 employees, each with 3+ relevant certificates
- all these have to be printed to be at the job site. They are tired of
having to open each hyperlink and print individually - would like a one
button print all. Setting up a form that guides the user thru a select query
that results in the subset of 15 employees into a query result with all the
correct hyperlink fields, records is no problem. It's the 'print all' that
I'm stymied a bit. 15 records; each record has a text field with employeeID
and then usually 2 or 3 but potentially up to 10 hyperlink fields with
hyperlinks (some blank).
Have browsed around in my spare time chipping away at various approaches -
but nothing really yet seems workable and would welcome input. thanks.