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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Duplicate a record

Status
Not open for further replies.
camtel

camtel

Technical User
Joined
Aug 13, 2005
Messages
2
Location
US
Any tips on how to duplicate a record while in an Access form or can you or must you duplicate a record while in a table only? Thanks,,
 
Sort by date Sort by votes
depends on if your record set has a prmary key or not but could be as simple as


DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 2, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 5, , acMenuVer70 'Paste Append


 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

caykamanj1966
  • Locked
  • Question Question
Duplicate Records in DataSheet View
Replies
5
Views
1K
Andrzejek
Andrzejek
priac
  • Locked
  • Question Question
Create a Duplicate of an Existing Record in Microsoft Access but leave some fields blank.
Replies
7
Views
2K
Andrzejek
Andrzejek
TrekBiker
  • Locked
  • Question Question
Duplicate Customers
Replies
6
Views
757
Andrzejek
Andrzejek
TomSalvato
  • Locked
  • Question Question
Getting the Monday date from a week number
Replies
2
Views
1K
TomSalvato
TomSalvato
Bubba002
  • Locked
  • Question Question
Pass a subform fieldname-ID as a string variable in CF expression
2 3
Replies
50
Views
4K
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top