View Single Post
  #1  
Old December 3rd, 2005, 09:48 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default Access 2000 - copy the currently displayed record

I moved from Access 97 to 2000 and am having problems with some code set up
in access97 to copy the currently displayed data in a sub form when a
command button is pressed the commented out code is:

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

Access 2000 gives me an error on this, I checked it out in Access help and
have the code changed to:

DoCmd.DoMenuItem acFormBar, acEditMenu, acCopy, acPaste

Have tried this with and without acPaste on the end, but get the following
error:

"The comand or action "Cut" isn't available now"

Am afraid this means I can't do this with my version of Access 2000/vsn
9.0, 3821 SR-1, Visual Basic vsn 6.0

I checked the News group messages on this subject with no success, lots of
copying but not of the current record as far as I can see.

As usual an help would be greatly appreciated.

Abay