Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can this be done?

Status
Not open for further replies.
Timbo57

Timbo57

IS-IT--Management
Jun 10, 2005
8
US
I have a database with related tables.
tblcustomer
tblrent
I have another database with identical tables.
what i would like to do is in a form, use a button to run an append query.I would like only to append the current record and then delete the current record. My databases are named rentactive and renthistory. Can anyone tell me how to accomplish this?

Thanks in Advance!
Tim
 
Sort by date Sort by votes
You can link to tables in another MS Access database and then Insert/Delete/Update as you require.

Steve Medvid
"IT Consultant & Web Master"

Chester County, PA Residents
Please Show Your Support...
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
This is the source query for what 1
Replies
12
Views
347
dhookom
dhookom
TheresAlwaysAWay
  • Locked
  • Question
"There isn't enough memory to perform this operation..." error after upgrading from Access
Replies
2
Views
263
Axworthy
Axworthy
PrimoSteve
  • Locked
  • Question
Cannot add Image to Command Button?
Replies
9
Views
603
PrimoSteve
PrimoSteve
VicM
  • Locked
  • Question
BeforeUpdate firing repeatedly 1
Replies
2
Views
162
VicM
VicM
DeRochier
  • Locked
  • Question
Subform triggers error: "This expression is typed incorrectly..."
Replies
3
Views
277
DeRochier
DeRochier

Part and Inventory Search

Sponsor

Back
Top