468,458 Members | 1,840 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,458 developers. It's quick & easy.

Copy data from one table to another.

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?
Dec 15 '07 #1
2 2441
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?
Dec 15 '07 #2
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?

Dec 15 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Peter CCH | last post: by
3 posts views Thread by david | last post: by
7 posts views Thread by lgbjr | last post: by
5 posts views Thread by Clodoaldo Pinto Neto | last post: by
6 posts views Thread by sql_server_user | last post: by
4 posts views Thread by JIM.H. | last post: by
reply views Thread by kmladenovski | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.