One form to enter multiple records.

[Csiophi]

I am trying to create an appointment database. I will use the database to
schedule my employees at different centers everyday. If a center request a
long term sub say from june 1st to aug. 1st. at the stage that I am at now
I would have to enter approx. 50 records for the one center with the only
change being the date. I have tried using multiple selections however, it is
very important that I know who is where on anygiving date. Just for a glipse
at my database I have a request table and form that includes the following
feilds: Date Requested, Center, Date Needed, Start Time, End Time,
Qualification, Notes, Scheduled Sub. I have a query that puts them in the
order I need. My biggest issue is entering in the same data over and over
again with the only change being the date. My employees only work M-F and off
on all major holidays. So my question is- how can I create a form that will
input multiple records in one form.
this is how I would like to enter the data on the form and in return have a
record for each date in the date range
Date requested- 5/10/08
Center: TOP
Start Date 5/10/08
End Date 8/1/08
Start Time: 7:15
End Time: 16:00
Qualification: Lead
Notes:
I have a pretty good understanding of how access works but I am still new to
it any help would be appreicated.
Siophi

 

[Dennis]

Why would you need multiple records? Just have a single record with a START
DATE and an END DATE. Why would that not get you what you need?

 

[bhicks11 via AccessMonster.com]

Conceptually:

Make a table with the years work dates so you don't post for non-work dates.

Make an append query to copy the static info.

Repeat the append query - Looping for each date in the range (check against
the work dates table).

Bonnie
http://www.dataplus-svc.com

 

[KARL DEWEY]

Create a table named CountNumber with field named CountNUM containing numbers
from 0 (zero) through your maximum spread. Use this query --
SELECT DateAdd("d",[CountNUM],[Start_Date]) AS Your_Fill_Date INTO
YourRequestTable
FROM CountNumber
WHERE (((CountNumber.CountNUM)<=DateDiff("d",[Start_Date],[End_Date])));

You need to add criteria to avoid weekends and use a holiday table to skip
those.

 

[Csiophi via AccessMonster.com]

Why would you need multiple records? Just have a single record with a START
DATE and an END DATE. Why would that not get you what you need?

I am trying to create an appointment database. I will use the database to
schedule my employees at different centers everyday. If a center request a

[quoted text clipped - 22 lines]

it any help would be appreicated.
Siophi

I have tried that and it does not work. I could have 20 subs at one center on
different dates. If I do it this way with multiple selections for subs it
does not allow me to select which dates each individual sub works. If I edit
in query it changes every date in the date range and not for the individual
dates make it impossible on what I want to track. Who is where on what day.

 

[bhicks11 via AccessMonster.com]

Csiophi,

I don't know if you are responding to me or Karl. My date table is only for
non-work dates so you can filter out those dates when you cycle through.

Bonnie
http://www.dataplus-svc.com


Csiophi,

I don't know if you are responding to me our

Why would you need multiple records? Just have a single record with a START
DATE and an END DATE. Why would that not get you what you need?

[quoted text clipped - 4 lines]
I have tried that and it does not work. I could have 20 subs at one center on
different dates. If I do it this way with multiple selections for subs it
does not allow me to select which dates each individual sub works. If I edit
in query it changes every date in the date range and not for the individual
dates make it impossible on what I want to track. Who is where on what day.