Duplicating Records

B

Bruce

I am trying to use Office 2007 on an Office 2000 DB. We have a Duplicate
Record button on our data entry form which now doesn't function. Any ideas
as to how to fix this button?
 
A

Allen Browne

Do any buttons work? If not, you may need to add the database folder to
trusted locations in order for any code to run. Go to:
Office Button | Access Options | Trust Center | Trust Center Settings

If other things work, it comes down to what's behind this button. There may
be something Access can't duplicate (such as calculated fields) in which
case you could solve it by explicitly specifying which fields to duplicate.
This code should do it:
Duplicate the record in form and subform
at:
http://allenbrowne.com/ser-57.html
Just skip the part about duplicating the related records in the subform.
 
B

Bruce

Thank you, adding that data base to the Trust Center worked. I did activate
all macros (not recommended), closed and reopened the DB and both Duplicate
and Search buttons worked. Should I go back and deactivate all Macros?
 
A

Allen Browne

No need to deactivate macros if you only open database you created, or from
people you trust.

If you accept databases from unknown sources that could be malicious, you
might want to deactivate macros again.
 
Top