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!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

PasteAppend error

Status
Not open for further replies.

sfenx

Programmer
Feb 23, 2001
81
BE
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" :
Code:
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 ? :cool:
 
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
 
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 ?
Sfenx :cool:
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top