Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

PasteAppend error

PasteAppend error

PasteAppend error

A while ago I converted an access2 application into access97. When I want to execute the following code on a form, I get the error "the action PasteAppend is temporarely not available" :
DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdCopy
DoCmd.RunCommand acCmdPasteAppend

This is the only problem that occurs in the whole app. The database is not read-only and is correctly converted.
I just want to select the whole record, copy it and make some modifications.
Can somebody help me ?   

RE: PasteAppend error

It may be that your recordset is not updatable. Check to see whether you can perform the operation manually, using Edit>Cut and Edit>PasteAppend.

Rick Sprague

RE: PasteAppend error

There's seems to be nothing wrong with the recordset. (AllowEdit and AllowAdditions are both set to True).
Something very odd came up although. When I set the Popup of the (second) form to false, the original procedure works ! The only problem is that the Popup of the first form is also set to true, so that I can't view the second form (where the procedure runs on) when I turn his popup to false. The first form doesn't seem to cause the problem.
It's very important that the popup of the forms remain True, so the users can't mess with the databases.
Any suggestions ?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close