Lebans Calendar & Subforms

[Jim]

I have created an Access 2003 database that stores associate data entered
regarding daily events. The entry form writes to the "entry database".
However, I have created a form that contains a subform that ideally would
display the data for the date selected on the Lebans Calendar.
Unfortunately, I am now stuck as I do not know what I can do to use the date
selected in the calendar to query the DB in order to display the results in
my datasheet subform.

Any assistance is welcomed as this has consumed my life lately.

 

[Steve]

Contact me and I will send you a screenshot of a calendar I have that is
fully selectable for year and month and can display different events on each
day on the calendar.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[John Marshall, MVP]

Since you would not dream of using these newgroups for soliciting, I guess
you must be giving it away for Free.

John... Visio MVP

 

[Peter Hibbs]

Jim

A Flex Grid Control will probably do what you want. Have a look at -

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Flex Grid Demo.mdb'

for some examples.

Peter Hibbs.

 

[Jim]

Peter..

I have reviewed the flex grid but I do not think it will fix my situation.
My database contains information about associate activities that we wish to
query by date to review in the form. The idea is to select a date and have
the query run as soon as the date is selected. That way the subform displays
the information I am wanting to review for that given day. The use of Lebans
Calendar or even the ActiveX calendar would allow quick and easy navigation
to specific dates. The application as it resides now in FoxPro does not have
this type of thought in it.

Thanks,
Jim