Hello Yvette,

I would like to offer to create this database for you. My fee would be very
small. Contact me if you are interested.

Steve




"Ybettm93" wrote in message
...
Hi,
I'm not sure if this is the correct forum to be asking this question, but
I
hope still to be able to get some help.
I work for a photography place at a golf course where we take pictures of
each group of golfers and then sell the pictures at the end of their
round.

I want to have a database that contains the following info: 1. an employee
table (employee name, etc...) 2.then a table that can keep track of the
photos that are taken on a daily basis and which employee shot the photos.

We always save our photos like this: C:OneUser/MyPictures/4 digit
year/Month/and then the last folder is 2010_04_16_YM (today's date
followed
by the initials of the photographer)

Heres
a demo that shows kinda what I want....

Theres a link to a demo that shows kinda what I want....except instead of
the subdatasheet he is using, I want a table that shows each photo taken
that
day represented by its filename which is a hyperlink to the location of
the
photo on our computer. The main table will have the date as a field and
our
name as a field on the form to fill in, so this will translate into the
folder that we created or imported that day. (based on the method of
naming
or folders mentioned above)

My goal is to be able to search by date and see what pictures were taken
and
the sales, employee who took it, etc... through Access.

Please let me know if this is possible.

Thanks for your time!
Yvette