Jim
Does it happen every time or could it be a locking issue? Does #1 have the same version number of Access as #3? I forget where MS buried the version number in 2007. In 2010, it's under File>Help.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile/Bill.Mosca
--- In MS_Access_Professionals@yahoogroups.com, "luvmymelody" <luvmymelody@...> wrote:
>
> 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
>
Tidak ada komentar:
Posting Komentar