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

[greg_g_johnson]

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.

 

[mscertified]

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

 

[PC Datasheet]

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

 

[John Marshall, MVP]

The ambulance chaser is at it again.

John... Visio MVP

 

[Duane Hookom]

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.

 

[Tim Ferguson]

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