New User- Is this possible in excel or access?

[Ybettm93]

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

 

[Steve]

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
(e-mail address removed)

 

[Gina Whipp]

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

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

 

[John... Visio MVP]

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
(e-mail address removed)

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

 

[Steve]

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

 

[John... Visio MVP]

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

 

[Larry Linson]

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

 

[Keith Wilby]

Hello Yvette,

- Show quoted text -

Do you get your "stupid pills" online these days?