#error message

  • Thread starter Thread starter Fons Ponsioen
  • Start date Start date
F

Fons Ponsioen

Is it possible that you have a text box with the name of a
variable? Can you tell me what is the string oin the text
box where it prints the "#error"?
Fons
 
Thank you for your response!
Basically I am trying to make a letter design where the
customer would receive a letter and the letter would
contain the customer address. So I made a text box with
the following start of my expression: =[fname]&[lname] and
then the address fields followed after that on separate
lines. I put this in the details section of my report.
This worked in one report where I used a simple query with
only 3 tables. It did not work when I added a couple of
more tables to my query. I would appreciate any help on
this!
 
As in the case where you used =[fname]&[lname] check the
name of the text box. If it is "fname" or "lname" change
it to for instance fname1 or lname1 that should fix the
problem.
If not, A second question is, did you base this report on
a query. If so, while in the design of the query can you
view all the data and does that look correct?
Hope this helps.
Fons
-----Original Message-----
Thank you for your response!
Basically I am trying to make a letter design where the
customer would receive a letter and the letter would
contain the customer address. So I made a text box with
the following start of my expression: =[fname]&[lname] and
then the address fields followed after that on separate
lines. I put this in the details section of my report.
This worked in one report where I used a simple query with
only 3 tables. It did not work when I added a couple of
more tables to my query. I would appreciate any help on
this!
-----Original Message-----
Is it possible that you have a text box with the name of a
variable? Can you tell me what is the string oin the text
box where it prints the "#error"?
Fons and
I and
I
.
Click to expand...
.
Click to expand...
 
Hello again,

I checked the text box and it was a different name from my
fields. You were right about my query though, it does not
display the information when I put all of the tables that
I wanted to use. Is there any way to fix that. I know that
in a form you can change the recordset type to dynaset
(inconsistent updates) so that it could display the
underlying fields from a query with several tables, is
there anything like that for a report?
Thank you again for your help!
-----Original Message-----
As in the case where you used =[fname]&[lname] check the
name of the text box. If it is "fname" or "lname" change
it to for instance fname1 or lname1 that should fix the
problem.
If not, A second question is, did you base this report on
a query. If so, while in the design of the query can you
view all the data and does that look correct?
Hope this helps.
Fons
-----Original Message-----
Thank you for your response!
Basically I am trying to make a letter design where the
customer would receive a letter and the letter would
contain the customer address. So I made a text box with
the following start of my expression: =[fname]&[lname] and
then the address fields followed after that on separate
lines. I put this in the details section of my report.
This worked in one report where I used a simple query with
only 3 tables. It did not work when I added a couple of
more tables to my query. I would appreciate any help on
this!
-----Original Message-----
Is it possible that you have a text box with the name
Click to expand...
of
a
variable? Can you tell me what is the string oin the text
box where it prints the "#error"?
Fons
-----Original Message-----
Hello,

I keep getting this error text in my report "#error" and
I
have checked all of my field names several times and I
know that I have entered them correctly. I thought the
problem might be with my query so I made several new
queries using each as a control source one at a time and
I
still got the same error. There was only one query that
worked, however I did not want to use that one because it
did not contain all of the tables that I wanted to use.
Any idea what could be wrong?

Thank you!
.

.
Click to expand...
.
Click to expand...
.
Click to expand...
 
So the problem appears to be in the query design.
I have found that sometimes I have to create one or two
queries to assemble data and than combine these queries in
the final report query.
You may want to give this a try. This often simplifies
the final query.
Fons
-----Original Message-----
Hello again,

I checked the text box and it was a different name from my
fields. You were right about my query though, it does not
display the information when I put all of the tables that
I wanted to use. Is there any way to fix that. I know that
in a form you can change the recordset type to dynaset
(inconsistent updates) so that it could display the
underlying fields from a query with several tables, is
there anything like that for a report?
Thank you again for your help!
-----Original Message-----
As in the case where you used =[fname]&[lname] check the
name of the text box. If it is "fname" or "lname" change
it to for instance fname1 or lname1 that should fix the
problem.
If not, A second question is, did you base this report on
a query. If so, while in the design of the query can you
view all the data and does that look correct?
Hope this helps.
Fons
-----Original Message-----
Thank you for your response!
Basically I am trying to make a letter design where the
customer would receive a letter and the letter would
contain the customer address. So I made a text box with
the following start of my expression: =[fname]&[lname] and
then the address fields followed after that on separate
lines. I put this in the details section of my report.
This worked in one report where I used a simple query with
only 3 tables. It did not work when I added a couple of
more tables to my query. I would appreciate any help on
this!
-----Original Message-----
Is it possible that you have a text box with the name of
a
variable? Can you tell me what is the string oin the
text
box where it prints the "#error"?
Fons
-----Original Message-----
Hello,

I keep getting this error text in my report "#error" and
I
have checked all of my field names several times and I
know that I have entered them correctly. I thought the
problem might be with my query so I made several new
queries using each as a control source one at a time and
I
still got the same error. There was only one query that
worked, however I did not want to use that one because
it
did not contain all of the tables that I wanted to use.
Any idea what could be wrong?

Thank you!
.

.

.
Click to expand...
.
Click to expand...
.
Click to expand...
 
also;

1) check the relationships (one-one;one-many) you set up between the tables
in the query and 2) how does the query handle null values (you may need to
set criteria to filter the nulls with 'iif()' and 'like' functions).

t said:
Hello again,

I checked the text box and it was a different name from my
fields. You were right about my query though, it does not
display the information when I put all of the tables that
I wanted to use. Is there any way to fix that. I know that
in a form you can change the recordset type to dynaset
(inconsistent updates) so that it could display the
underlying fields from a query with several tables, is
there anything like that for a report?
Thank you again for your help!
-----Original Message-----
As in the case where you used =[fname]&[lname] check the
name of the text box. If it is "fname" or "lname" change
it to for instance fname1 or lname1 that should fix the
problem.
If not, A second question is, did you base this report on
a query. If so, while in the design of the query can you
view all the data and does that look correct?
Hope this helps.
Fons
-----Original Message-----
Thank you for your response!
Basically I am trying to make a letter design where the
customer would receive a letter and the letter would
contain the customer address. So I made a text box with
the following start of my expression: =[fname]&[lname] and
then the address fields followed after that on separate
lines. I put this in the details section of my report.
This worked in one report where I used a simple query with
only 3 tables. It did not work when I added a couple of
more tables to my query. I would appreciate any help on
this!
-----Original Message-----
Is it possible that you have a text box with the name of
a
variable? Can you tell me what is the string oin the
text
box where it prints the "#error"?
Fons
-----Original Message-----
Hello,

I keep getting this error text in my report "#error" and
I
have checked all of my field names several times and I
know that I have entered them correctly. I thought the
problem might be with my query so I made several new
queries using each as a control source one at a time and
I
still got the same error. There was only one query that
worked, however I did not want to use that one because
it
did not contain all of the tables that I wanted to use.
Any idea what could be wrong?

Thank you!
.

.

.
Click to expand...
.
Click to expand...
Click to expand...
 
Back
Top