Jim-
That's TERRIBLE code! You should be running an INSERT SQL command, doing a
Requery, then going to the new record. Trying to "emulate" keyboard-like
actions in the User Interface will just get you in trouble. Do it all behind
the scenes. I have no clue what your table or Record Source looks like, so I
can't give you specific help about the INSERT command.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of luvmymelody
Sent: Wednesday, August 24, 2011 7:44 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Command or action pasteappend error
Hello all,
I have a database that is acting strange. It is located on the network where
several users have access to it.
The issue is that when one user tries to use a button that duplicates a record
and appends it gets the error The Command Or Action "Pasteappend" Isn'T
Available Now. Yet when other users try it on their own machines it does not
give the error but works as coded. Each user has the same references in vba.
We are in a mixed environment right now with OS and Office versions. Below is
the matrix of the users. The top one is the machine where the issue is
happening.
Is there something that is getting by me that I do not see?
Thank you for your help
Jim Wagner
User 1 Windows 7, office 2007 gets error
User 2 Windows XP, Office 2007 No error
User 3 Windows 7, office 2007 no error
User 4 Windows 7, office 2010 no error
the code is below
Private Sub duprcd_Click()
On Error GoTo Err_duprcd_Click
RunCommand acCmdSelectRecord
RunCommand acCmdCopy
RunCommand acCmdPasteAppend
Exit_duprcd_Click:
Exit Sub
Err_duprcd_Click:
MsgBox Err.Description
Resume Exit_duprcd_Click
End Sub
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar