Add records from form

[Guest]

I am working to develop an access application to manage tee times for a
private golf club. The challenge is that each day's tee sheet differs as to
accomodate a variety of different regular and tournament formats.

Presently my table contains fields for Date, TeeTime, StartHole, PlayGroup,
Format, as well as for Player1 ... Player4. The table is presently empty of
records.

I would like to build a form that would allow the administrator to build a
custom tee sheet for the day by selecting the date (from a calendar control),
deciding on format and other necessary time parameters and then append the
necessary records to the table to create the day's tee sheet.

I will use a second form to allow the Tee Booking Clerk to complete the
daily tee sheet by filling in the golfer's names at a latter date.

My question is how to best go about the coding of the form to add the
appropriate records to the table. Would an append query work? Is there a
better way using VB code to create a series of records.

Thanks in advance for your assistance.

Happy New Year to all!

Bob Mullen

 

[PC Datasheet]

Bob,

I am in business to provide customers with a resource for help with Access.
I have developed a custom appointment module that could easily be adapted to
a tee sheet. The module contains time slots that could be fixed intervals or
variable intervals and you could enter the names in the foursome for each
time slot. I could also help you design the tables and forms for whatever
format you might want. If you would like my help, contact me at my email
address below.

 

[Rob Oldfield]

The easiest way is just to have the form bound to the table and then open it
in data entry mode by using....

DoCmd.OpenForm "YourForm", , , , acFormAdd

(An append query using an unbound form would also work, but is probably
overcomplicated.)