By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,492 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

Copy data from one table to another.

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.