|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 10th, 2006, 02:18 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
Assign a value to a field from one table to a field in another
I have a Access database that I inherited, and I do not want to alter
the inital table or forms. I am adding a table and I want to insert a new record and assign fields of that record with some data from the first table with data from the first table in the second on a button click. I am looking for some guidence on how to do this. 
|
|
#2
March 10th, 2006, 12:04 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Assign a value to a field from one table to a field in another
You could try an append query
http://office.microsoft.com/en-us/as...0631033.aspx#1 " wrote: I have a Access database that I inherited, and I do not want to alter the inital table or forms. I am adding a table and I want to insert a new record and assign fields of that record with some data from the first table with data from the first table in the second on a button click. I am looking for some guidence on how to do this.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Query is not updatable - | Doug Johnson via AccessMonster.com | Running & Setting Up Queries | 3 | January 21st, 2006 12:36 AM |
| Add New Field to DB | Karen | Database Design | 7 | October 19th, 2005 08:03 PM |
| Help again from Ken Snell (Query) | Randy | Running & Setting Up Queries | 22 | August 29th, 2005 08:15 PM |
| Multiple Options Group | Patty Stoddard | Using Forms | 19 | August 4th, 2005 02:30 PM |
| COMPARE THE TWO TABLES | Stefanie | General Discussion | 0 | June 4th, 2004 04:36 PM |
Linear Mode
