Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

#NAME? Error in MS Access


  • Please log in to reply

#1
sunny441

sunny441

    Member

  • Member
  • PipPipPip
  • 258 posts
Hello guys!

Been a long time since I posted on here! I am working on a project using MS Access. As the topic says - I am having problems with retrieving data from a table and displaying.

The one table has the component information like manufacture name, size and other things. The other table has some information pertaining to Temperature (mostly numbers here). On this 2nd table there are some fields that have no value and have been set to "---" by the previous db guy. All the fields are set to TEXT value.

Now on the final front end - which displays information, the information from the first table shows up just fine. All the temperatures and info from the 2nd table show up as #NAME? Error.

Any ideas as to what might be wrong? I have the table sources set to the right values (like =[temp rear]). I also tried changing the field from TEXT to NUmber. But that did not help. The relationship is correct and the keys are correct.

I am at my wits end! Please help!! :)

Edited by sunny441, 24 June 2010 - 07:51 PM.

  • 0

Advertisements


#2
dm27

dm27

    Member

  • Member
  • PipPipPip
  • 272 posts
Hello sunny441,

Welcome to Geeks to Go...

Just a couple of thoughts:

Are you referring to a Form when you mention the 'final front end'? If so, did the data display correctly until now or did something change that caused these issues?

The #NAME error is letting us know (not always clearly), that something is either misspelled, has incorrect syntax or the reference is missing.

I imagine you have already checked all the control sources, names, etc, since that is usually the first place to check.

Best regards,

dm
  • 0

#3
Brother Bill

Brother Bill

    Member

  • Member
  • PipPip
  • 31 posts
Hello Sunny,

This is my first post here, so I hope I'm not out of line. DM is correct. I believe that the formatting in your table is causing the issue.

You can use a Null value in your tables, but I don't believe that you should have a "---" entry in the field without using some form of custom formatting. Check the format value of your field properties in design mode.

For instance, let's say your Field is named Temperature, and your Data Type is a number. If you leave the Format value blank, a 98.6 entry in the Temperature field will reflect as 98.6 and a negative 98.6 entry will reflect as -98.6. If no entry is made in the field, nothing will display.

Now, on the flip side of the coin, say you want to follow the previous administrator's lead and leave the tick marks in the field. You can customize the formatting for the field to suit your taste. Depending on the level of temperatures that you're using, you might try some of the following examples as a Format value.

0000.000;(0000.000);0000.000;"---"

An entry in the Temperature field of 875.65 will appear as 0875.650,
a negative entry of -875.65 will appear in parenthesis as (0875.650),
a 0 entry will appear as 0000.000,
and no entry (null) will appear as ---.

And to change things up a bit, try this.

####.###;(####.###);###0.0##;"No temp recorded."

The same entries will now appear as;

875.65
(875.65)
0.0
No temp recorded.

Hope this helps a bit,
Bill
  • 0

#4
dm27

dm27

    Member

  • Member
  • PipPipPip
  • 272 posts
Hello Brother Bill,

Welcome to the Geeks to Go! It's great to see you joined in the topic and you were not out of line in posting your info.

It's the only way to share your ideas and help another Geeks To Go member with their problem. :)

Sincerely,

dm
  • 0

#5
Brother Bill

Brother Bill

    Member

  • Member
  • PipPip
  • 31 posts
Thanks DM. You just never know how you'll be accepted when you visit a new group and offer assistance. I enjoy it. Keeps me out of trouble.
  • 0

#6
sunny441

sunny441

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 258 posts
Sorry for the delay in getting back!

DM and Brother Bill!
Thank you both for your input! I tried and looked for things that might be wrong and could not find a thing. Control sources and names look good. The same fields work fine when I pull data from table 1. Even though am pulling numbers that are in as TEXT. However, when data is pulled from Table 2, nothing seems to work.

Any help would be much appreciated!

Cheers
  • 0

#7
dm27

dm27

    Member

  • Member
  • PipPipPip
  • 272 posts
hello sunny441,

I've not been posting much lately...have you been able to figure it this out yet? If not, would you be willing to list the control and table names that you are having problems with?

Sincerely,

dm
  • 0

#8
sunny441

sunny441

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 258 posts
Hey DM27!

Thanks for your help. Been busy with other projects at work. No luck at all to get this one going. Can send you a copy of the database if that can help!

Cheers
Sunny
  • 0

#9
h3h5z4

h3h5z4

    New Member

  • Member
  • Pip
  • 2 posts

I am having this issue with a database at work.  In the date field, the form prints as #Name?  The form should show today's date.  There are several other users on this database and their forms work fine. The

 

I've tried-

 

-Unregister and register the activex controls (which has worked with other users in the past) The error message I receive when I do this is

  DllRegisterServer in z:\NtSvc.OCX failed

  Return code was 0x80040200

- I logged in as an administrator on the computer and did the same with no luck. 

 

Any help would be appreciated


  • 0

#10
Dashing star

Dashing star

    Member

  • Member
  • PipPipPip
  • 722 posts

Hello h3h5z4,

 

As this is old one also may be different from your issue please create a new topic here.

 

Regards


  • 0

#11
philips11

philips11

    New Member

  • Member
  • Pip
  • 1 posts

At the time of starting the program you generally this error occurs:
Error: 48
Which means Error in loading DLL

 

in order to solve this issue permanently simply opt for some third party repair tool

I would suggest you to go for  MS Access Repair Tool…follow the link get this product ....hopefully it will help to solve your queries.


  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP