G
Guest
I have been working on a database which will be accessed via a LAN. The end
users are clerks for a speeding ticket representation firm, and need to fill
in client info..then ticket info, etc...then, need to scan docs - ticket #1
and #2 for client1, tickets 1-5 for client2, etc. I have a table set up for
the client info.
I have <pretty much> the forms done for accessing the database. I have an
activex plug-in I grabbed from the web, on recommendation from several
people. PajantImage control. I am looking at my original table, and affirming
my decision to place the image scans in their own table. What I'd like to be
able to do is to have potentially multiple images scanned into a specific
image folder. Then, I'd like to have the links to those images available in
the client records, when an end user calls up data for any given client.
I have no idea how to make the form, setup the database properly, store the
images and have them autonumber for a given record, nor to place a hyperlink
for each image attached to a given record, that is accessible on a 'general
info' page for each record entered.
It is very complicated for me, as I am learning Access, and everything
else, as I go. After a month of playing around with this aspect of the
project I am trying to toss together for a friend, I am about to throw in the
towel. Help!
users are clerks for a speeding ticket representation firm, and need to fill
in client info..then ticket info, etc...then, need to scan docs - ticket #1
and #2 for client1, tickets 1-5 for client2, etc. I have a table set up for
the client info.
I have <pretty much> the forms done for accessing the database. I have an
activex plug-in I grabbed from the web, on recommendation from several
people. PajantImage control. I am looking at my original table, and affirming
my decision to place the image scans in their own table. What I'd like to be
able to do is to have potentially multiple images scanned into a specific
image folder. Then, I'd like to have the links to those images available in
the client records, when an end user calls up data for any given client.
I have no idea how to make the form, setup the database properly, store the
images and have them autonumber for a given record, nor to place a hyperlink
for each image attached to a given record, that is accessible on a 'general
info' page for each record entered.
It is very complicated for me, as I am learning Access, and everything
else, as I go. After a month of playing around with this aspect of the
project I am trying to toss together for a friend, I am about to throw in the
towel. Help!