How do I setup calender reference for each of my clients in access

I have a database setup to reference each of my clients, and would like to be
able to setup a field in my MDB that can contain a excel document to hold
dated information specific for each client. I would want it to hold a varity
of numbers under each date. that if possible could then be pulled for
reference and used within the database for reports for individual clients or
group queries.

Access and Excel are two different animals, it does not make sense (and is
extremely difficult) to mix the two.
Tell us what business problem you are tring to solve.
If you are using Access, do the whole thing in Access. It is possible to
import or export Excel spreadsheets but there are some complications involved.

Dorian

"greg_g_johnson" wrote:

I have a database setup to reference each of my clients, and would like to be
able to setup a field in my MDB that can contain a excel document to hold
dated information specific for each client. I would want it to hold a varity
of numbers under each date. that if possible could then be pulled for
reference and used within the database for reports for individual clients or
group queries.

I have a month scheduling calendar form/report and a week scheduling
calendar form/report. Either could be adapted to do what you want to do. I
can implement either of these for you for a reasonable fee. If you would
like help, send me an email.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!


"greg_g_johnson" wrote in message
...
I have a database setup to reference each of my clients, and would like to
be
able to setup a field in my MDB that can contain a excel document to hold
dated information specific for each client. I would want it to hold a
varity
of numbers under each date. that if possible could then be pulled for
reference and used within the database for reports for individual clients
or
group queries.

The ambulance chaser is at it again.

John... Visio MVP


"PC Datasheet" wrote in message
nk.net...
I have a month scheduling calendar form/report and a week scheduling
calendar form/report. Either could be adapted to do what you want to do. I
can implement either of these for you for a reasonable fee. If you would
like help, send me an email.

PC Datasheet

I would avoid privately contacting anyone with ethics so low that they would
use these News Groups to advertise rather than providing free
advice/solutions/answers.

--
Duane Hookom
MS Access MVP
--

"PC Datasheet" wrote in message
nk.net...
I have a month scheduling calendar form/report and a week scheduling
calendar form/report. Either could be adapted to do what you want to do. I
can implement either of these for you for a reasonable fee. If you would
like help, send me an email.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!


"greg_g_johnson" wrote in
message ...
I have a database setup to reference each of my clients, and would like to
be
able to setup a field in my MDB that can contain a excel document to hold
dated information specific for each client. I would want it to hold a
varity
of numbers under each date. that if possible could then be pulled for
reference and used within the database for reports for individual clients
or
group queries.

"PC Datasheet" schreef in bericht nk.net...

I have a month scheduling calendar form/report and a week scheduling
calendar form/report. Either could be adapted to do what you want to do. I
can implement either of these for you for a reasonable fee. If you would
like help, send me an email.

I guess the OP would like some free help indeed ...

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!

To the OP: Beware of this guy!!

Steve just does *not* care about the newsgroups. He has *no ethics at all*.
Steve *only* cares about making *money*, and he acts as if the groups are his private hunting ground.

-- He abuses this group and others for job-hunting and advertising over and over again
-- He is insulting lots of people here when they ask him to stop this
-- He posted as Steve, Ron, Tom, Rachel, Kathy, Kristine, Heather and ??? while asking questions
(the latest 'star's': 'Access Resource' and Tom and Andy)
-- He tries to sell a CD ($125,--) with FREE code he gathered from these groups here
-- There even has been a 'Scam-alert' about him which has been explained recently in the thread 'To all':
http://groups.google.com/group/comp....954261f9?hl=en
-- Also recently it became clear that he has been spamming innocent people asking questions:
http://groups.google.com/group/comp....3e5f58ad?hl=en

So why would ANYBODY ever trust a person like him and hire him?
************************************************** ******

Explanation and more links on this answer:
http://home.tiscali.nl/arracom/stopsteve.html

Arno R

"=?Utf-8?B?bXNjZXJ0aWZpZWQ=?=" wrote in
:

Access and Excel are two different animals, it does not make sense
(and is extremely difficult) to mix the two.

Sorry: I don't buy into that. Yes, they are different animals and do
different johs; but is not hard and often appropriate to use them
together:

Excel has better maths, arithmetic, and stats functionality than Access
ever will -- it's normal in many spheres to dump an Access recordset into
Excel for further exploitation/ analysis/ summarising.

Excel does not have a sophisticated security model of its own, so it is
reasonable to use a secured Jet database to store data and use DAO or ADO
etc to read it back into spreadsheets. Same applies for complexity of the
data model; Excel only really deals with flat files.

The Access GUI is horrid for anything that involves row-and-colum
manipulation; think of time sheets, scheduling apps, even exam marking.
Excel is also much better when it comes to counting sorted recordsets
like calculating percentiles and so on.

Don't forget that the same language works in Word and Corel Draw, so that
you can produce nice graphs and then mailmerge them round using all four
packages together!

Just a thought....



Tim F