Problems copying records.

Z

Zelm

I made a copy button on my form that copies the current
record. I was trying to use the code that the wizard
implemented, but I always get an error. I get error 2046
with description of "The command or action 'PasteAppend'
isn't available now." I been trying to change my Allow*
properities, but still same thing.

The code that the wizard uses for copying and pasting is
the following:
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 2, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 5, ,
acMenuVer70 'Paste Append

I really cannot figure it out why my PasteAppend is not
available. I know that I can copy every single field and
then add it to a new one but I would have to be copying
it field by field. Does anyone know how to fix this
PasteAppend problem. Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicate Record when Required Fields are Present 8
delete record 3
DoCmd.DoMenuItem in Access 2007 1
Need a button to print 5 copies 2
DoMenuItem Enquires 3
Filtered records 3
Copy record/Refigure date + 7 days 4
Variable not defined 1

Top