CmdCopy

Question

Why would it tell me that this recordset is not updateable (error message) when I run the code below that is called from a form?  All I'm doing is navigating to a the "Account Number" control and coping the content.  Yet if I ask it to navigate to another control on the same form and copy, no problem.  Is it because I'm asking it to navigate to the same control that I click on to run the copy code?  Meaning, that I want to click the Account Number control and copy the number.  I do this SO much throughout the day that I'm get tired of right-clicking and selecting copy.  Just easier to click and move on.

Option Compare Database

Option Explicit

Public Function CopyAccountNumberDocumentCenter()

DoCmd.GoToControl "Account Number"

DoCmd.RunCommand acCmdCopy

End Function

Thank you for the help in advance.

Ken

Answer 1

OK, so the ultimate goal is to use the Account Number field to generate an e-mail address, correct?

So, is the code to do the e-mail on the same form? If so, you can just reference the control name in the code. If its not, then use Forms!formname![Account Number] to reference it. Like I sad use value assignments instead of copy and paste.

Answer 2

Thank you, Scott.  Sorry for the delay.

Answer 3

that only partially answers my question. clearly you want to copy the value in a Control, but what do you want to do with that value?

OH, sorry --- paste in email and our site to access an account.  It's nothing more than a step to reduce typing the account number in email or elsewhere.  And prevents from typing the number incorretly as well.

Answer 4

that only partially answers my question. clearly you want to copy the value in a Control, but what do you want to do with that value?