473,325 Members | 2,608 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

#Name? Error

What does this mean: "#Name?"

I have one user (out of about 80) that is complaining that he gets that in
report text boxes from data that should be coming from an Oracle pass thru.

I couldn't figure out how to google for that string and I get no response
searching the A2K help.

--
Randy Harris
(tech at promail dot com)
Nov 13 '05 #1
8 1819
Randy -

In my experience, it seems to mean the report can't find the data
(source) for that specific text box.

Somewhere along the line, a field name is misspelled, a query has had a
field removed, or perhaps a connection is broken.

Do other users running the same report get data instead of #Name, or is
the "complainant" the only user running that particular report? If
other users run the same report and get data, the problem is likely
outside the report or its query. If no other users run that report,
I'd start with the report...

HtH

Patrick

Nov 13 '05 #2
"Patrick A" <me*****@butter.toast.net> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.com...
Randy -

In my experience, it seems to mean the report can't find the data
(source) for that specific text box.

Somewhere along the line, a field name is misspelled, a query has had a
field removed, or perhaps a connection is broken.

Do other users running the same report get data instead of #Name, or is
the "complainant" the only user running that particular report? If
other users run the same report and get data, the problem is likely
outside the report or its query. If no other users run that report,
I'd start with the report...

HtH

Patrick


I'm afraid that's the strange part. The same report works fine for other
users. I don't know what to do!
Nov 13 '05 #3
Randy Harris wrote:
"Patrick A" <me*****@butter.toast.net> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.com...
Randy -

In my experience, it seems to mean the report can't find the data
(source) for that specific text box.

Somewhere along the line, a field name is misspelled, a query has had a
field removed, or perhaps a connection is broken.

Do other users running the same report get data instead of #Name, or is
the "complainant" the only user running that particular report? If
other users run the same report and get data, the problem is likely
outside the report or its query. If no other users run that report,
I'd start with the report...

HtH

Patrick

I'm afraid that's the strange part. The same report works fine for other
users. I don't know what to do!

Then I would debug the problem from his machine.
Nov 13 '05 #4
"Salad" <oi*@vinegar.com> wrote in message
news:rB******************@newsread1.news.pas.earth link.net...
Randy Harris wrote:
"Patrick A" <me*****@butter.toast.net> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.com...
Randy -

In my experience, it seems to mean the report can't find the data
(source) for that specific text box.

Somewhere along the line, a field name is misspelled, a query has had a
field removed, or perhaps a connection is broken.

Do other users running the same report get data instead of #Name, or is
the "complainant" the only user running that particular report? If
other users run the same report and get data, the problem is likely
outside the report or its query. If no other users run that report,
I'd start with the report...

HtH

Patrick

I'm afraid that's the strange part. The same report works fine for other users. I don't know what to do!

Then I would debug the problem from his machine.


How do I go about debugging something like that? There is no error message,
it simply doesn't display the data.


Nov 13 '05 #5
Randy Harris wrote:
"Salad" <oi*@vinegar.com> wrote in message
news:rB******************@newsread1.news.pas.earth link.net...
Randy Harris wrote:

"Patrick A" <me*****@butter.toast.net> wrote in message
news:11*********************@f14g2000cwb.google groups.com...
Randy -

In my experience, it seems to mean the report can't find the data
(source) for that specific text box.

Somewhere along the line, a field name is misspelled, a query has had a
field removed, or perhaps a connection is broken.

Do other users running the same report get data instead of #Name, or is
the "complainant" the only user running that particular report? If
other users run the same report and get data, the problem is likely
outside the report or its query. If no other users run that report,
I'd start with the report...

HtH

Patrick
I'm afraid that's the strange part. The same report works fine for
other
users. I don't know what to do!


Then I would debug the problem from his machine.

How do I go about debugging something like that? There is no error message,
it simply doesn't display the data.


I would open the form in design mode and get the recordsource. I would
then attempt to open it. I would Debug.Print the SQL when he gets that
problem and see if I can run the query. That's where I'd start. I'd
verify some of the problem text boxes are associated with the correct
field. I'd verify he has the same form the others do. If you have
split database check your links.

I really don't know what I'd do...but I'd certainly be testing it out on
his machine that fails and not another machine that works.

Nov 13 '05 #6
On Wed, 20 Apr 2005 15:33:02 GMT, "Randy Harris" <ra***@SpamFree.com>
wrote:
What does this mean: "#Name?"

I have one user (out of about 80) that is complaining that he gets that in
report text boxes from data that should be coming from an Oracle pass thru.

I couldn't figure out how to google for that string and I get no response
searching the A2K help.


Randy,

This might be a wild goose chase, but see if that machine has a
references problem.

mike
Nov 13 '05 #7
Mike Preston wrote:
This might be a wild goose chase, but see if that machine has a
references problem.


Not a wild goose chase at all. From the sounds of the thread with
Patrick and Salad, this would have to be the explanation. PTQs
shouldn't give any #name errors, in my experience; however, you can base
report and form record sources (as well as form combo and list box row
sources) on PTQs but still use Access functions in the control sources
of controls on the report.

What version of Access are you using and does this user have other
versions of Access? If not, are you using A97 and is the problem
machine using win XP?

If so, I'd bet dollars to doughnuts it's a reference problem.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Nov 13 '05 #8
"Tim Marshall" <TI****@PurplePandaChasers.Moertherium> wrote in message
news:d4**********@coranto.ucs.mun.ca...
Mike Preston wrote:
This might be a wild goose chase, but see if that machine has a
references problem.


Not a wild goose chase at all. From the sounds of the thread with
Patrick and Salad, this would have to be the explanation. PTQs
shouldn't give any #name errors, in my experience; however, you can base
report and form record sources (as well as form combo and list box row
sources) on PTQs but still use Access functions in the control sources
of controls on the report.

What version of Access are you using and does this user have other
versions of Access? If not, are you using A97 and is the problem
machine using win XP?

If so, I'd bet dollars to doughnuts it's a reference problem.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me


I should have given the Access version to begin with. It's an Access 2000
mde, running on XP. It's a good sized app, with about 80 forms, 40 reports
and 20,000 lines of code. The PTQ is the record source for the problem
report. It's strange because some of the data outputs correctly on the
report, others just get that #Name? thing. I believe that the problem has
to be the PTQ. There are a lot of users running the identical same front
end, this is the only with the problem, so I don't think the problem can be
the report itself. I started delving into ODBC driver versions when I found
out this users system is going to be replaced in the next few days. I
figured I'd wait until IT gives him a new system, and see if he still has
the problem. Meanwhile, I've got another user outputting the report to PDF
and emailing to the user with the problem.

Thanks to everyone for the input. I'll let you know if I figure it out.
Nov 13 '05 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Bas | last post by:
Hi, Using SQL 2k SP3 I want to know if there's a way to retrieve the name of the database a stored proc is run in. For example: CREATE PROCEDURE HelloWorld AS
4
by: Frederik Sørensen | last post by:
I include a xslt stylesheet with variables for all the error messages in my system. <xsl:variable name="Banner_error_1"> errormessage 1 for banner </xsl:variable> <xsl:variable...
8
by: Glenn A. Harlan | last post by:
Why am I receiving the below error when calling - Path.GetTempFileName() The directory name is invalid. Description: An unhandled exception occurred during the execution of the current web...
8
by: CES | last post by:
All, I'm sorry but I still don't get this!! I'm trying to use a variable that is passed into a function to to dynamically name an instance of an Object(). I've created a Timer() Object that seems...
2
by: Charles Wilt | last post by:
I have a IBM iSeries (aka AS-400) running v5r3 of OS/400 that I access via a linked server from SQL Server 2000. The following select works fine: select * from...
3
by: Arpan | last post by:
The following code exists in a class file named "Users.vb": Namespace Users Public Class UserDetails Public FirstName As String Public LastName As String Public UserName As String Public...
4
by: =?Utf-8?B?Sm9obiBTaW1wc29u?= | last post by:
Like every developer, I've got tons of error trapping code that hard code the name of the function or sub name so I can error log it. It seems from other discussions that the only way to get the...
0
by: BrianT | last post by:
I'm trying to build code that allows the computer name to be changed, then asks the user to reboot to make the change affective. I got the code working when logged in as the local computer...
13
by: Neil | last post by:
Can I get the name of a procedure from within the procedure? In my error handler, I write the error to an error table. I'd like to write the name of the procedure that's writing the error. But,...
1
by: vineetbindal | last post by:
Hi All, I am new to silverlight and i am following a tutorial. In order to connect to database in silverlight application i need to add a referance to a service. which gives me an error that the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.