Access- Copying Records across

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

batman1056

Thread Starter
Joined
Oct 23, 2002
Messages
6
OK.. I have a database in Access 97. and it does everyting thing I want. the one thing I am having problems with is copying one record onto another. is this possible. the format of the database is as follows

you choose a customer. which will allow access the the subform on the same page call ordermain. with the key being order number. in this subform there will be details regarding an order , ie. date, contact etc. this will also have a subform linked via the ordernumber 1 to many ratio. called orderdetails on this subform you will have various items which are the main quote. what I would like to do if possible is copy the orderdetails subform onto a new record. how can I do this?

Also when I am using the orderdetails subform I have 4 boxes, item no. price description and qty. in the item no. I currently pu inthe number 1, 2,3 etc manually is there a automagic way of the database auto numbering the items in relation to the number of itmes I have on the subform.

Fuew thanks
 
Joined
Oct 13, 2000
Messages
941
I don't know what you mean by "copying the record"--i.e. where you want it to go. Should be as simple as running an append query with the appropriate criteria set, then maybe requerying the subform if you're trying to do it with the subform open.

As for setting the number automatically, you can use the BeforeInsert event of the form--this will not show on the form until the record is saved, but it will work correctly, together with the DMax() function, the appropriate criteria (ordernumber=x), and a + 1.

I'd suggest doing a little reading in Access help on append queries and DMax as a place to start. And you will have to be able to write (simple) macros to do it, so if you aren't familiar with them you should spend a little time learning about them in help.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top