Copy data from one table to another.

[Kevin]

I need a little guidance here. I have set up a table for job estimates with
a large number of data fields. On the estimate form is a command button to
convert the estimate to a scheduled job. When the user clicks the button I
would like to copy certain fields and paste them to corresponding fields in
a projects table. Could someone point me in the right direction on where to
start this process?

[Tom van Stiphout]

On Sat, 15 Dec 2007 17:33:33 GMT, "Kevin" <no**@email.comwrote:

That's done with an Append query.

But before you do that, consider carefully if your 2-table setup is a
good idea. The alternative is one table, with an additional Status
field that can be set to either Estimate or Job (or any number of
statuses). This is often much more convenient.

-Tom.

>I need a little guidance here. I have set up a table for job estimates with
a large number of data fields. On the estimate form is a command button to
convert the estimate to a scheduled job. When the user clicks the button I
would like to copy certain fields and paste them to corresponding fields in
a projects table. Could someone point me in the right direction on where to
start this process?

[Phil Stanton]

Tom is probably right, but the moment I see "a large number of data fields"
I suspect you are trying to create an Excel type sheet in Access. I would
guess that you should be looking at a main form for the estimate (Names,
Address etc) and a continuous subform showing details and price. So 2
tables, one for the names and address and Tom's Status flag and the other
table with a foreign key pointing to the customer and detail & price.

Phil

"Tom van Stiphout" <no*************@cox.netwrote in message
news:1q********************************@4ax.com...

On Sat, 15 Dec 2007 17:33:33 GMT, "Kevin" <no**@email.comwrote:

That's done with an Append query.

But before you do that, consider carefully if your 2-table setup is a
good idea. The alternative is one table, with an additional Status
field that can be set to either Estimate or Job (or any number of
statuses). This is often much more convenient.

-Tom.

>>I need a little guidance here. I have set up a table for job estimates
with
a large number of data fields. On the estimate form is a command button to
convert the estimate to a scheduled job. When the user clicks the button I
would like to copy certain fields and paste them to corresponding fields
in
a projects table. Could someone point me in the right direction on where
to
start this process?