[MSAccessProfessionals] Karenware.com soon to be closing

Hi all

 

I just got a notification that karenware.com will soon be closing. For those of you who don’t recognize that site, it has several free utilities that you might find useful. The file backup app is especially useful when you are developing Access applications. You can keep a history of versions in case you blow up the one you are working on.

 

Anyway, take a look at the offerings just in case you see something you might like before they go away.

 

Regards,
Bill Mosca,
Founder, MS_Access_Professionals

MS Access MVP 2006-2016
My Nothing-to-do-with-Access blog

https://wrmosca.wordpress.com

 

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

hi Sara,

perhaps try the quoted text?

~~~

you don't need 3 DLookups, or even one since it appears that dFirst will work too. Try this:

=DFirst("[city] & ' ' & [state] & ' ' & Left( nz( [postalcode],''),5)","Provider")

Runtime can be picky. Sometimes you just have to give in and do things differently.

good luck

kind regards,
crystal

On 7/3/2022 9:44 PM, novice012000 wrote:

When I respond show the thread. How? I see 'show quoted text' ,but it does not include the prior posts.

Yes as I mentioned, it works for me in 2003, it is only an issue for the user running 2016 run time.

Sarah

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

When I respond show the thread. How? I see 'show quoted text' ,but it does not include the prior posts.

Yes as I mentioned, it works for me in 2003, it is only an issue for the user running 2016 run time.

Sarah

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116233) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_

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

hii Sarah,

I am also using 2016. I created an example table and that expression works for me even though it could be better written like this:

=DFirst("[city] & ' ' & [state] & ' ' & Left( nz( [postalcode],''),5)","Provider")

Inside the double quotes " are single quotes '

~~~

There could be something else on the form that is really causing the issue.

Since the expressions with multiple DLookups are resulting in the error, perhaps rewrite them to be like the above? NZ shouldn't be necessary if there is data, but I find that when using a function that needs a string like Left, it behaves better.

~~~

> "The BE and FE are both in Access 2003. The user is using Access 2016 run time."

does it work ok for YOU? Is it just this user who is having an issue? Runtime can do quirky things, and I can't test it

~~~

please, when you respond, choose to keep previous message
so we don't lose what has already been written, thanks

kind regards,
crystal

On 7/3/2022 6:22 PM, novice012000 wrote:

I added Option Explicit and compiled. There are no errors and no missing References

Example of text box that works:
=DLookUp("[name]","Provider","")

Example of text box that does not work:
=DLookUp("[city]","Provider","") & " " & DLookUp("[state]","Provider","") & " " & Left$(DLookUp("[postalcode]","Provider",""),5)

All text boxes that are comprised of more than one input field are resulting in #Name? error in Access 2016.

The BE and FE are both in Access 2003. The user is using Access 2016 run time.

Sarah

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

I added Option Explicit and compiled. There are no errors and no missing References

Example of text box that works:
=DLookUp("[name]","Provider","")

Example of text box that does not work:
=DLookUp("[city]","Provider","") & " " & DLookUp("[state]","Provider","") & " " & Left$(DLookUp("[postalcode]","Provider",""),5)

All text boxes that are comprised of more than one input field are resulting in #Name? error in Access 2016.

The BE and FE are both in Access 2003. The user is using Access 2016 run time.

Sarah

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116231) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_

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

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

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