Paste append error message

[steve goodrich]

I have a duplicate Record button on my form that's been working for 5 years
with no problems
Now when I click it I receive the following error message
THE COMMAND OR ACTION "PASTE APPEND" ISN'T AVAILABLE NOW

I was playing around with some code for another command button which is
assigned to its on click event - listed below ( which works ok)


Private Sub Command176_Click()
If IsNull(Forms![Visitors]![AUTHORISED SIGNATORIES]) Then
MsgBox "PLEASE COMPLETE THE AUTH BY FIELD"
Me.AUTHORISED_SIGNATORIES.SetFocus
Exit Sub
Else
DoCmd.GoToRecord , , acNewRec
Me.DATE_FROM.SetFocus
MsgBox "BOOKING CONFIRMED"

End If
End Sub

Also none of my duplicate record command buttons work on my other databases
either.

I removed the code rebooted but still get the error

I created a database from scratch and added a duplicate record button to the
form to test it and I get the same error message

I seem to take one step forward and two back!
can any one help please

Steve

 

[Jerry Whittle]

What changed recently?
Update to a newer version of Access? (What version of the OS and Access are
you on?)
Any patches installed on your computer?
Any new software?
Has someone messed with your network?
Are the .mdb files on the network?

 

[steve goodrich]

Jerry
I have both access 97 and 2003 on my home pc which is where I have the
problem. The problem is with access 97, In fact I converted an access 97 db
to access 2003 and the duplicate button works fine. I have not installed
anything lately or downloaded any patches. I'm running windows xp home
edition on a dell 9100, 3.4mhz with 2 gig ram. The databases are all on my
hard drive.
I plan to use the database at work on the network (we're still running
access 97 which is why I have both versions on my own pc)
If it's something that I have messed up by playing around with code - which
I am the first to admit I am not at all comfortable with, I'm very much at
the bottom of the learning curve. But I would have thought that it would
only mess up the practice database that I was working on and not every other
one on my hard drive that has a duplicate button.
HOLD ON A MINUTE
I thought I'd try it once more before sending this post AND IT IS NOW
WORKING
I'm now baffled, I have to set this up on the network at work on Saturday
hoping that the duplicate button works and if it doesn't I have no clue as
to how to resolve it
Do you have any idea what could have caused this to happen and more
importantly how to prevent it happening in the future
Steve

What changed recently?
Update to a newer version of Access? (What version of the OS and Access
are
you on?)
Any patches installed on your computer?
Any new software?
Has someone messed with your network?
Are the .mdb files on the network?
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

I have a duplicate Record button on my form that's been working for 5
years
with no problems
Now when I click it I receive the following error message
THE COMMAND OR ACTION "PASTE APPEND" ISN'T AVAILABLE NOW

I was playing around with some code for another command button which is
assigned to its on click event - listed below ( which works ok)


Private Sub Command176_Click()
If IsNull(Forms![Visitors]![AUTHORISED SIGNATORIES]) Then
MsgBox "PLEASE COMPLETE THE AUTH BY FIELD"
Me.AUTHORISED_SIGNATORIES.SetFocus
Exit Sub
Else
DoCmd.GoToRecord , , acNewRec
Me.DATE_FROM.SetFocus
MsgBox "BOOKING CONFIRMED"

End If
End Sub

Also none of my duplicate record command buttons work on my other
databases
either.

I removed the code rebooted but still get the error

I created a database from scratch and added a duplicate record button to
the
form to test it and I get the same error message

I seem to take one step forward and two back!
can any one help please

Steve

 

[Jerry Whittle]

dell 9100, 3.4mhz with 2 gig ram

It doesn't happen on my Dell 2400, 2.2mhz with 1 gig ram. Therefore we
obviously need to trade computers. ;-) As a bonus I have A97, A03, and A07 on
my computer!

When things get strange, I start wondering about my virus checker. Have you
excluded scanning of .mb* files?

Also go to Tools, Options, General Tab and turn off Name Autocorrect on all
of your databases. IMHO it's a piece of do-do and the cause of many problems.
While there turn off Compact on Close if enabled. You'll be glad that you did.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Jerry
I have both access 97 and 2003 on my home pc which is where I have the
problem. The problem is with access 97, In fact I converted an access 97 db
to access 2003 and the duplicate button works fine. I have not installed
anything lately or downloaded any patches. I'm running windows xp home
edition on a dell 9100, 3.4mhz with 2 gig ram. The databases are all on my
hard drive.
I plan to use the database at work on the network (we're still running
access 97 which is why I have both versions on my own pc)
If it's something that I have messed up by playing around with code - which
I am the first to admit I am not at all comfortable with, I'm very much at
the bottom of the learning curve. But I would have thought that it would
only mess up the practice database that I was working on and not every other
one on my hard drive that has a duplicate button.
HOLD ON A MINUTE
I thought I'd try it once more before sending this post AND IT IS NOW
WORKING
I'm now baffled, I have to set this up on the network at work on Saturday
hoping that the duplicate button works and if it doesn't I have no clue as
to how to resolve it
Do you have any idea what could have caused this to happen and more
importantly how to prevent it happening in the future
Steve

What changed recently?
Update to a newer version of Access? (What version of the OS and Access
are
you on?)
Any patches installed on your computer?
Any new software?
Has someone messed with your network?
Are the .mdb files on the network?
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

I have a duplicate Record button on my form that's been working for 5
years
with no problems
Now when I click it I receive the following error message
THE COMMAND OR ACTION "PASTE APPEND" ISN'T AVAILABLE NOW

I was playing around with some code for another command button which is
assigned to its on click event - listed below ( which works ok)


Private Sub Command176_Click()
If IsNull(Forms![Visitors]![AUTHORISED SIGNATORIES]) Then
MsgBox "PLEASE COMPLETE THE AUTH BY FIELD"
Me.AUTHORISED_SIGNATORIES.SetFocus
Exit Sub
Else
DoCmd.GoToRecord , , acNewRec
Me.DATE_FROM.SetFocus
MsgBox "BOOKING CONFIRMED"

End If
End Sub

Also none of my duplicate record command buttons work on my other
databases
either.

I removed the code rebooted but still get the error

I created a database from scratch and added a duplicate record button to
the
form to test it and I get the same error message

I seem to take one step forward and two back!
can any one help please

Steve

 

[steve goodrich]

Trade computers - you could have had it free gratis last night!
Checked all your suggestion and none were enabled
It's working fine at the moment - watch this space, I may be back!
Thanks for your time.
Steve

It doesn't happen on my Dell 2400, 2.2mhz with 1 gig ram. Therefore we
obviously need to trade computers. ;-) As a bonus I have A97, A03, and A07
on
my computer!

When things get strange, I start wondering about my virus checker. Have
you
excluded scanning of .mb* files?

Also go to Tools, Options, General Tab and turn off Name Autocorrect on
all
of your databases. IMHO it's a piece of do-do and the cause of many
problems.
While there turn off Compact on Close if enabled. You'll be glad that you
did.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Jerry
I have both access 97 and 2003 on my home pc which is where I have the
problem. The problem is with access 97, In fact I converted an access 97
db
to access 2003 and the duplicate button works fine. I have not installed
anything lately or downloaded any patches. I'm running windows xp home
edition on a dell 9100, 3.4mhz with 2 gig ram. The databases are all on
my
hard drive.
I plan to use the database at work on the network (we're still running
access 97 which is why I have both versions on my own pc)
If it's something that I have messed up by playing around with code -
which
I am the first to admit I am not at all comfortable with, I'm very much
at
the bottom of the learning curve. But I would have thought that it would
only mess up the practice database that I was working on and not every
other
one on my hard drive that has a duplicate button.
HOLD ON A MINUTE
I thought I'd try it once more before sending this post AND IT IS NOW
WORKING
I'm now baffled, I have to set this up on the network at work on Saturday
hoping that the duplicate button works and if it doesn't I have no clue
as
to how to resolve it
Do you have any idea what could have caused this to happen and more
importantly how to prevent it happening in the future
Steve

What changed recently?
Update to a newer version of Access? (What version of the OS and Access
are
you on?)
Any patches installed on your computer?
Any new software?
Has someone messed with your network?
Are the .mdb files on the network?
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


:

I have a duplicate Record button on my form that's been working for 5
years
with no problems
Now when I click it I receive the following error message
THE COMMAND OR ACTION "PASTE APPEND" ISN'T AVAILABLE NOW

I was playing around with some code for another command button which
is
assigned to its on click event - listed below ( which works ok)


Private Sub Command176_Click()
If IsNull(Forms![Visitors]![AUTHORISED SIGNATORIES]) Then
MsgBox "PLEASE COMPLETE THE AUTH BY FIELD"
Me.AUTHORISED_SIGNATORIES.SetFocus
Exit Sub
Else
DoCmd.GoToRecord , , acNewRec
Me.DATE_FROM.SetFocus
MsgBox "BOOKING CONFIRMED"

End If
End Sub

Also none of my duplicate record command buttons work on my other
databases
either.

I removed the code rebooted but still get the error

I created a database from scratch and added a duplicate record button
to
the
form to test it and I get the same error message

I seem to take one step forward and two back!
can any one help please

Steve