S
SJH
Hi, I want to design a database in Access 2003 that serves partly as a
scheduler application. We have auditors in Europe that send us their
itinerary each week, I have designed a very simple form in Access with the
following fields:
Date, Auditor, CountryCode, ActivityID, AuditNo, DealerCode and DealerName
The CountryCode and ActivityID are stored in other tables and selected via
combo box, the dealer table info is also selected from an attached table and
are based on which country code is entered (dealername is for display
purposes only and uses dlookup).
Is there a way to make this even easier for the user to enter the data
though? eg in a calendar format maybe? If not, from a front-end form could I
select the auditor and w/c date and have five blank records with each date
displayed or data shown if any exist for that date already?
I have implemented Stephen Lebans calendar for the date input and this works
great, thanks! One question on that - if I change it to select a date range
with start and end dates how would I find out what a person was doing on a
certain date? Plus it complicates working out how many days were spent on an
activity but I guess I could add an extra field and work this out with
datediff function.
I am going to look at the calendar reports I've seen mentioned on the
newsgroups too, I need to be able to report on how many days were spent on
certain activities, etc and I need to print out one report showing all
auditors on a weekly basis and where they were.
Thanks for any input on this - just want to make sure I am going about it
the best way.
Sue
scheduler application. We have auditors in Europe that send us their
itinerary each week, I have designed a very simple form in Access with the
following fields:
Date, Auditor, CountryCode, ActivityID, AuditNo, DealerCode and DealerName
The CountryCode and ActivityID are stored in other tables and selected via
combo box, the dealer table info is also selected from an attached table and
are based on which country code is entered (dealername is for display
purposes only and uses dlookup).
Is there a way to make this even easier for the user to enter the data
though? eg in a calendar format maybe? If not, from a front-end form could I
select the auditor and w/c date and have five blank records with each date
displayed or data shown if any exist for that date already?
I have implemented Stephen Lebans calendar for the date input and this works
great, thanks! One question on that - if I change it to select a date range
with start and end dates how would I find out what a person was doing on a
certain date? Plus it complicates working out how many days were spent on an
activity but I guess I could add an extra field and work this out with
datediff function.
I am going to look at the calendar reports I've seen mentioned on the
newsgroups too, I need to be able to report on how many days were spent on
certain activities, etc and I need to print out one report showing all
auditors on a weekly basis and where they were.
Thanks for any input on this - just want to make sure I am going about it
the best way.
Sue