If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
New User- Is this possible in excel or access?
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 |
#3
|
|||
|
|||
New User- Is this possible in excel or access?
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/acc...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" 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 |
#4
|
|||
|
|||
New User- Is this possible in excel or access?
"Steve" wrote in message
... 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 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 |
#5
|
|||
|
|||
New User- Is this possible in excel or access?
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" 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 |
#6
|
|||
|
|||
New User- Is this possible in excel or access?
"Steve" schreef in bericht ... 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 I sure expect that Yvette is NOT so stupid to contact you... -- Get lost $teve. Go away... far away.... Again... Get lost $teve. Go away... far away.... No-one wants you here... no-one needs you here... This newsgroup is meant for FREE help.. No-one wants you here... no-one needs you here... OP look at http://home.tiscali.nl/arracom/whoissteve.html (Website has been updated and has a new 'look'... we have passed 12.000 pageloads... it's a shame !!) Arno R |
#7
|
|||
|
|||
New User- Is this possible in excel or access?
"Steve" wrote in message
... 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 So my ANSWER to Bre-x in Apr 14 to his "Help with Function: date range" does not count? Stevie you are a mediocre developer with questionable skills who can not compete in a fair market, so you prey on unsuspecting posters in a free help newsgroup where any qualified developer has the ethics not to pester posters with offers of paid assistance. John,,, Visio MVP |
#8
|
|||
|
|||
New User- Is this possible in excel or access?
"Steve" wrote
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. It is trivially simple for the poster to establish whether John Marshall is an MVP. Go to http://mvp.support.microsoft.com, the official Microsoft MVP support site, and on the home page, click on the MVP awardees tab, and enter John Marshall in the search box. (And, the poster can find me in that list, too, but they won't find Steve there.) John would be helping the posters here if he did nothing but caution them about your soliciting work in a free-help newsgroup -- your continually violating the principles and spirit of the newsgroup. That is not, however, all he does. If I were a poster, I'd certainly be cautious about hiring someone soliciting work who's not even smart enough to avoid being EASILY AND PROVABLY demonstrated to be lying. Larry Linson |
#9
|
|||
|
|||
New User- Is this possible in excel or access?
On 18 Apr, 21:05, "Steve" wrote:
Hello Yvette, - Show quoted text - Do you get your "stupid pills" online these days? |
Thread Tools | |
Display Modes | |
|
|