Re: [MSAccessProfessionals] Textbox is populated with the "#NAME?" error code. after upgrading computers

correction, to add a space after the comma ...

=[Last Name] & ",  " & [First Name]

Not sure if it is apparent, but & must have at least one space before and after. If field names have a space or special character in them other than underscore, they generally need to be enclosed in [square brackets]

~crystal

On 7/1/2022 9:55 PM, crystal (strive4peace) via groups.io wrote:

hi Sarah,

please give an actual example. for instance, this:
Last Name&","&First Name

should be:
=[Last Name] & "," & [First Name]

~~~~~~~~~ Compile ~~~~~~~~~
 
Whenever you change code, references, or switch versions or operating environment, or modify objects with code behind them, you should always compile and save before executing any code.
 
from the menu in a VBE (module) window: [b]Debug, Compile[/b] [the name of your project]
(Alt-F11 to switch to the code window)
 
Fix any errors on the highlighted lines.
Add needed references, remove unnecessary references, resolve missing references
(from the menu: Tools, References...)

keep compiling until nothing happens (this is good!) -- then Save

also be sure, before compiling, to use Option Explicit at the very TOP of each module so variables that are not declared or are misspelled will be picked up by the compiler as well as many other errors than can be fixed before running.

~~~~~~~~~ Add Option Explicit ~~~~~~~~~

if the top of your module does not have a statement that says Option Explicit, then add this:

Option Explicit  ' require variable declaration

If this was not done when the code was written, you will may need to DIM some variables -- it is best to do that anyway

kind regards,
crystal

On 6/30/2022 9:58 PM, novice012000 wrote:

The path to the BE has not changed. the '#name?' error happens in text boxes where the data is a combination of multiple fields: EG Last Name&","&First Name. Or City&state&zip. Maybe the length of the combined text is a problem?

How do I compile the database in the environment with the issue, if that envrionment only has access run time?

Sarah