Prev: redo my design
Next: lookup
From: Ybettm93 on 18 Apr 2010 00:13 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) [url="http://office.microsoft.com/client/helppreview.aspx?AssetID=HA102668001033&ns=MSACCESS&lcid=1033&CTT=3&Origin=HA102774071033"]Heres a demo that shows kinda what I want....[/url] 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
From: Steve on 18 Apr 2010 16:05 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 santus(a)penn.com "Ybettm93" <Ybettm93(a)discussions.microsoft.com> wrote in message news:5A25D883-B606-4C8D-B7FF-7EA1E6C3F83B(a)microsoft.com... > 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) > > [url="http://office.microsoft.com/client/helppreview.aspx?AssetID=HA102668001033&ns=MSACCESS&lcid=1033&CTT=3&Origin=HA102774071033"]Heres > a demo that shows kinda what I want....[/url] > > 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
From: Gina Whipp on 18 Apr 2010 16:07 Ybettm93, Yes this is possible in Access. However Access has a learning curve and if you are not familiar with Access this can be kind of stiff. Here's some resources that should get you started... Jeff Conrad's resources page... http://www.accessmvp.com/JConrad/accessjunkie/resources.html The Access Web resources page... http://www.mvps.org/access/resources/index.html A free tutorial written by Crystal (MS Access MVP)... http://allenbrowne.com/casu-22.html MVP Allen Browne's tutorials... http://allenbrowne.com/links.html#Tutorials Sample data models... http://www.databasedev.co.uk/table-of-contents.html -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Ybettm93" <Ybettm93(a)discussions.microsoft.com> wrote in message news:5A25D883-B606-4C8D-B7FF-7EA1E6C3F83B(a)microsoft.com... 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) [url="http://office.microsoft.com/client/helppreview.aspx?AssetID=HA102668001033&ns=MSACCESS&lcid=1033&CTT=3&Origin=HA102774071033"]Heres a demo that shows kinda what I want....[/url] 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
From: John... Visio MVP on 18 Apr 2010 17:50 "Steve" <notmyemail(a)address.com> wrote in message news:OfOjSKz3KHA.4016(a)TK2MSFTNGP05.phx.gbl... > 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 > santus(a)penn.com Stevie, you have no shame. Your MIL must be proud of the example you are setting for your kids. Stevie is our own personal pet troll who is the only one who does not understand the concept of FREE peer to peer support! He offers questionable results at unreasonable prices. These newsgroups are provided by Microsoft for FREE peer to peer support. There are many highly qualified individuals who gladly help for free. Stevie is not one of them, but he is the only one who just does not get the idea of "FREE" support. He offers questionable results at unreasonable prices. If he was any good, the "thousands" of people he claims to have helped would be flooding him with work, but there appears to be a continuous drought and he needs to constantly grovel for work. Please do not feed the trolls. John... Visio MVP
From: Steve on 18 Apr 2010 18:52
Yvette, Ignore the person who posted to my response to you. He is a fake MVP who only posts derogatory messages to the newsgroups and never posts any help to posters here. Steve "Ybettm93" <Ybettm93(a)discussions.microsoft.com> wrote in message news:5A25D883-B606-4C8D-B7FF-7EA1E6C3F83B(a)microsoft.com... > 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) > > [url="http://office.microsoft.com/client/helppreview.aspx?AssetID=HA102668001033&ns=MSACCESS&lcid=1033&CTT=3&Origin=HA102774071033"]Heres > a demo that shows kinda what I want....[/url] > > 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 |