Temp table for Submit Button

[guitarfunk24]

I need to make a form with subforms in it have a submit button that is
connected to a temp table then transfers its data to the real table
when someone clicks submit then clears the temp table to make it blank
for the next submit. Then if someone clicks the cancel button it just
clears the temp table so no harm no fowl. The problem with this is I
have no clue how I would do this at all. I know what I want just not
how to start. So if someone could break it down for me into a step by
step process I would be so happy.

Keep in mind that the form that would have this done to it would have
one table for the main form for the name of the project and
description of the project then the subform contains another table
that has the parts numbers and prices.

Even an example site would be great thank you.

 

[Guest]

1. Create a temp table containing all the fields you will need (you could
copy your permanent table - then your naming conventions will be the same)
2. Create the form using your temp table fields.
3. Create an append query that will write the data in the temp table to the
permanent table (or tables depending on the design).
4. Create a delete query that deletes the data in the temp table.
5. Create a macro to run the append and delete queries. (I also put a line
to requery, to get rid of the "deleted???" statements in the form fields. It
works, but there may be a better way.
6. On the click event of your submit/accept button run the macro.

Good luck!

 

[guitarfunk24]

1. Create a temp table containing all the fields you will need (you could
copy your permanent table - then your naming conventions will be the same)
2. Create the form using your temp table fields.
3. Create an append query that will write the data in the temp table to the
permanent table (or tables depending on the design).
4. Create a delete query that deletes the data in the temp table.
5. Create a macro to run the append and delete queries. (I also put a line
to requery, to get rid of the "deleted???" statements in the form fields. It
works, but there may be a better way.
6. On the click event of your submit/accept button run the macro.

Good luck!

Thank you for the info on how to start this crazy form, but because I
am so new at this thing is there any site that may be able to tell me
how to do steps 3 through 6 sadly I never used the queries to do
something like this and I am alittle new to this trying to make this
database dummy proof. If you could that would be great.

 

[guitarfunk24]

Thank you for the info on how to start this crazy form, but because I
am so new at this thing is there any site that may be able to tell me
how to do steps 3 through 6 sadly I never used the queries to do
something like this and I am alittle new to this trying to make this
database dummy proof. If you could that would be great.

Or an example to base mine off of thank you.

 

[Guest]

Here is a good link in the ms site :
http://office.microsoft.com/en-us/access/HP051880831033.aspx (I just
googled append quer to find this)

Once you create an append query, the delete query is easy to learn. Just
query the temp table, all its fields, and select delete from the query type.
Just make sure you run the query before making it a delete to make sure it is
pulling up the right info.