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) 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
"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!
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.
"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.
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.
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
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
"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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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,...
|
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...
|
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...
|
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...
|
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...
|
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)...
|
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...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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....
|
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
|
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...
| |