Calendar Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to read date information from a table, and display it in the
appropriate day on a calendar?
 
Yes but how depends on how your data is stored and how your calendar displays
dates, neither of which you told us.

-Dorian
 
Thanks for the response. The dates are stored as standard format: xx/xx/xxxx.
As far as my calendar, I don't have one at this point. I am not sure if the
built-in activeX calendar is the one to use, or if it would even work. I am
really looking for a point in the right direction.

Here's what my goal is:
-Orders are entered for a particular due date, on a seperate form.
-Then the form that I want to create is opened. For each day of the week, I
want to show 3 categories, which are defined during step 1, with cumaltive
production times for each. So, the result is, I can look at any particular
day, and be able to get a summary of production times.

I feel that I need the structure of a calendar in order for this to work,
but I am just not sure how to make it happen.

Thanks in advance.
 
I don't really understand your requirement.
A Calendar is normally used to choose a date. It avoids the whole problem of
a user typing in a date and then it having to be validated. When just
displaying a date from a table, its usually just shown as XX/XX/XXXX.
It sounds like you need to enter a week-ending date and then see the 7-days
data. To enter the date you could use a calendar. Once the date was chosen
you would run a query to pull the data for each day of that week. Then of
course it depends on if you just need to view the data or also update it.

-Dorian
 
I understand that a calendar is used to pick a date. What I am trying to do
here is display records from a query, in calendar form, based on the "Due
Date." For instance, all records with March 29th as del date will be
displayed on the calendar under Wendesday. All orders with 30th as date will
show up under Thursday, and so on...

Maybe "calendar" was the wrong choice of words. But that is the overall
look that I was trying to acheive.

I hope I am explaining this correctly.

Thanks again.
 
Would a report instead of a form do? Report sorted on Days of the week and
laid out as a calendar.
 
My hope is to be able to click on any job and bring up a seperate, more
detailed screen. So, no, I don't think a report would work.
 
Back
Top