ACCESS FEED: Re: [MS_AccessPros] Command or action pasteappend error

Bill,

Someone in IT suggested that the user's clipboard is not saving the copy. How would I check for any settings that might have turned off his clipboard?

Jim Wagner
________________________________

________________________________
From: Jim Wagner <luvmymelody@yahoo.com>
To: "MS_Access_Professionals@yahoogroups.com" <MS_Access_Professionals@yahoogroups.com>
Sent: Friday, August 26, 2011 7:00 AM
Subject: Re: [MS_AccessPros] Command or action pasteappend error

Bill,

Thanks for the help.

Jim Wagner
________________________________

________________________________
From: Bill Mosca <wrmosca@comcast.net>
To: MS_Access_Professionals@yahoogroups.com
Sent: Thursday, August 25, 2011 3:35 PM
Subject: RE: [MS_AccessPros] Command or action pasteappend error

Jim

I don't know what to tell you. Check the user's permissions on all folders involved. See if the DB is open read-only. Watch what the user does to get that error.

Regards,

Bill

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Jim Wagner
Sent: Thursday, August 25, 2011 2:39 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Command or action pasteappend error

Bill we all have the same version of Access and the problem still exists

Jim Wagner
________________________________

________________________________
From: Bill Mosca <wrmosca@comcast.net <mailto:wrmosca%40comcast.net> >
To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
Sent: Thursday, August 25, 2011 9:57 AM
Subject: RE: [MS_AccessPros] Command or action pasteappend error

Jim

Using a remote will let you run his computer like you were sitting at his desk. I find it invaluable.

Regards,

Bill

From: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> [mailto:MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Jim Wagner
Sent: Thursday, August 25, 2011 8:46 AM
To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: Re: [MS_AccessPros] Command or action pasteappend error

Bill,

We are on the same network, in fact we are several cubes away from each other in both directions. He is just always so busy.

Jim Wagner
________________________________

________________________________
From: Bill Mosca <wrmosca@comcast.net <mailto:wrmosca%40comcast.net> <mailto:wrmosca%40comcast.net> >
To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com>
Sent: Thursday, August 25, 2011 8:29 AM
Subject: RE: [MS_AccessPros] Command or action pasteappend error

Jim

Good luck with that. Users seldom are able to get you that kind of information. Are you on the same network as your users? If so, I strongly recommend you use something like Remote desktop (Windows\System32\mstsc.exe) or DameWare Mini Remote to remote to the desktop and get it yourself.

MS Remote desktop requires you to log in on the user's machine so you can't really see what they see.

I love DameWare Mini Remote because the user can see what you are doing and can be more specific as to what they do to get the error. But it ain't free. Maybe your network or desktop support already has some kind of remote tool they use and would let you install it. It's saved me days of frustration by being able to get on someone's computer without having to trek all the way over to their desk only to find out they got called away.

Regards,

Bill

From: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com> [mailto:MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Jim Wagner
Sent: Wednesday, August 24, 2011 3:01 PM
To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: Re: [MS_AccessPros] Command or action pasteappend error

Bill,

I am trying to get the user to come back to his desk to check out the version number.

Jim Wagner
________________________________

________________________________
From: Bill Mosca <wrmosca@comcast.net <mailto:wrmosca%40comcast.net> <mailto:wrmosca%40comcast.net> <mailto:wrmosca%40comcast.net> >
To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com>
Sent: Wednesday, August 24, 2011 2:54 PM
Subject: Re: [MS_AccessPros] Command or action pasteappend error

Jim

Fair enough, but did you read my response?

Bill

--- In MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com> , Jim Wagner <luvmymelody@...> wrote:
>
> I personally did not want the button on the form in the first place. Others that have putÂ the copy record code on forms in other databases have totally corrupted the data. But my voice fell on deaf ears because the users wanted convenience. But the underlying issue is why does it work for others and not one user?
>
> Â
> Jim Wagner
> ________________________________
>
>
>
> ________________________________
> From: John Viescas <john@...>
> To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com>
> Sent: Wednesday, August 24, 2011 11:45 AM
> Subject: RE: [MS_AccessPros] Command or action pasteappend error
>
>
> Â
> Another reason to NEVER use Wizards - not even the "improved" versions in 2007
> and 2010.
>
> 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%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com>
> [mailto:MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Bill Mosca
> Sent: Wednesday, August 24, 2011 8:36 PM
> To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com>
> Subject: Re: [MS_AccessPros] Command or action pasteappend error
>
> John
>
> Don't blame Jim...That looks like wizard-generated code to me.
>
> Bill
>
> --- In MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com> , "John Viescas" <john@> wrote:
> >
> > 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%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > [mailto:MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of luvmymelody
> > Sent: Wednesday, August 24, 2011 7:44 PM
> > To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.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
> >
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>
> [Non-text portions of this message have been removed]
>

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]