Form for multiple client use and transfer of responses to table

[Philbie]

I wish to create a form for staff to use that contains questions about their
existing skills and then have Access transfer their reponses automatically to
a table. I want Access to open at the same blank form each time ready for
staff to use, without the need to create a new form for every use. I assume
staff would fill in the form, answer the questions on it and then click on
Submit or something like this - their responses would then be transferred to
a table and the form cleared of data, ready for the next user.
Can this be done in Access?
your help with this is much appreciated
Philbie

 

[Jeff Boyce]

Philbie

Out of the box, Access provides ways to do this... (by the way, you posted
to a "TablesDBDesign" newsgroup, which focuses on tables, not forms)

First create your table(s) -- have you normalized your data?

Then create a query based on your table(s).

Now create a form based on the query. Set the Data Add property of the form
to Yes.
Add a command button that the user would press to <Save> the data (although
this is redundant - Access saves when the form is closed or the record is
left).

Each time the (only one) form is opened, it opens ready to accept (new)
data.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jeff Boyce]

Jamie

The original poster may not realize that this is a continuing discussion
topic in the 'groups...

And you and I have, I believe, agreed to disagree on this point. While
adding CONSTRAINTS into data definition may be more elegant, I suspect it is
considerably less accessible to normal, every day use of Access. It is in
those circumstances that I'm proposing to embed business rules.

Regards

Jeff Boyce
Microsoft Office/Access MVP