A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

New User- Is this possible in excel or access?



 
 
Thread Tools Display Modes
  #1  
Old April 18th, 2010, 05:13 AM posted to microsoft.public.access.gettingstarted
Ybettm93
external usenet poster
 
Posts: 1
Default 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
  #2  
Old April 18th, 2010, 09:05 PM posted to microsoft.public.access.gettingstarted
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default New User- Is this possible in excel or access?

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



  #3  
Old April 18th, 2010, 09:07 PM posted to microsoft.public.access.gettingstarted
Gina Whipp
external usenet poster
 
Posts: 3,500
Default 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

  #5  
Old April 18th, 2010, 11:52 PM posted to microsoft.public.access.gettingstarted
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default 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  
Old April 19th, 2010, 12:37 AM posted to microsoft.public.access.gettingstarted
Stop$teve
external usenet poster
 
Posts: 76
Default 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  
Old April 19th, 2010, 02:23 AM posted to microsoft.public.access.gettingstarted
John... Visio MVP
external usenet poster
 
Posts: 900
Default 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  
Old April 19th, 2010, 03:08 AM posted to microsoft.public.access.gettingstarted
Larry Linson
external usenet poster
 
Posts: 3,112
Default 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  
Old April 19th, 2010, 11:16 AM posted to microsoft.public.access.gettingstarted
Keith Wilby[_2_]
external usenet poster
 
Posts: 5
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:23 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.