upsized access to SQL now there is a report field error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I wrote a report in Access that was working fine. I upsized Access to SQL
server and now I link to an SQL table that I open in Access. Now I get a
#NAME? error on my report. I checked the field names and all is fine. Does
SQL server require different expression syntax? My control source is
=[fieldname]+" text".
 
I have tried that, as well as other combinations and I still get the same
result: #NAME? I had another column in my report that was doing the same
thing, but I only needed the field displayed and not any text added to it. I
removed the = sign and the brackets and now it works just fine. I just can't
figure out how to add the word "Total:" to my field data.
Thank you for responding.
Lisa

Duane Hookom said:
Is there a reason you didn't use:
=[fieldname] & " text"

--
Duane Hookom
MS Access MVP


Me! said:
I wrote a report in Access that was working fine. I upsized Access to SQL
server and now I link to an SQL table that I open in Access. Now I get a
#NAME? error on my report. I checked the field names and all is fine.
Does
SQL server require different expression syntax? My control source is
=[fieldname]+" text".
Click to expand...
Click to expand...
 
I expect your control name is the same as your field name. Change it to
"txtFieldName".

--
Duane Hookom
MS Access MVP
--

Me! said:
I have tried that, as well as other combinations and I still get the same
result: #NAME? I had another column in my report that was doing the same
thing, but I only needed the field displayed and not any text added to it.
I
removed the = sign and the brackets and now it works just fine. I just
can't
figure out how to add the word "Total:" to my field data.
Thank you for responding.
Lisa

Duane Hookom said:
Is there a reason you didn't use:
=[fieldname] & " text"

--
Duane Hookom
MS Access MVP


Me! said:
I wrote a report in Access that was working fine. I upsized Access to
SQL
server and now I link to an SQL table that I open in Access. Now I get
a
#NAME? error on my report. I checked the field names and all is fine.
Does
SQL server require different expression syntax? My control source is
=[fieldname]+" text".
Click to expand...
Click to expand...
Click to expand...
 
Sorry, I'm not sure what you are talking about. I'm self taught at this
time. Just in case there is a deeper problem, the report results were as
expected when we were using a test server. When we moved our data to our
production server we began to have errors. We have ="Page " & [Page] & " of
" & [Pages] for our reports which has worked well up until we upsized to SQL
server as well, now we get the #NAME? error there as well.

Duane Hookom said:
I expect your control name is the same as your field name. Change it to
"txtFieldName".

--
Duane Hookom
MS Access MVP
--

Me! said:
I have tried that, as well as other combinations and I still get the same
result: #NAME? I had another column in my report that was doing the same
thing, but I only needed the field displayed and not any text added to it.
I
removed the = sign and the brackets and now it works just fine. I just
can't
figure out how to add the word "Total:" to my field data.
Thank you for responding.
Lisa

Duane Hookom said:
Is there a reason you didn't use:
=[fieldname] & " text"

--
Duane Hookom
MS Access MVP


I wrote a report in Access that was working fine. I upsized Access to
SQL
server and now I link to an SQL table that I open in Access. Now I get
a
#NAME? error on my report. I checked the field names and all is fine.
Does
SQL server require different expression syntax? My control source is
=[fieldname]+" text".
Click to expand...
Click to expand...
Click to expand...
 
Well, maybe this is bigger than I thought. I thought we would just have to
modify our reports, but we found that another workstation runs the report
just fine. Could this be similar to the post below from 1-9-2005? What is
SP 3?

Me! said:
Sorry, I'm not sure what you are talking about. I'm self taught at this
time. Just in case there is a deeper problem, the report results were as
expected when we were using a test server. When we moved our data to our
production server we began to have errors. We have ="Page " & [Page] & " of
" & [Pages] for our reports which has worked well up until we upsized to SQL
server as well, now we get the #NAME? error there as well.

Duane Hookom said:
I expect your control name is the same as your field name. Change it to
"txtFieldName".

--
Duane Hookom
MS Access MVP
--

Me! said:
I have tried that, as well as other combinations and I still get the same
result: #NAME? I had another column in my report that was doing the same
thing, but I only needed the field displayed and not any text added to it.
I
removed the = sign and the brackets and now it works just fine. I just
can't
figure out how to add the word "Total:" to my field data.
Thank you for responding.
Lisa

:

Is there a reason you didn't use:
=[fieldname] & " text"

--
Duane Hookom
MS Access MVP


I wrote a report in Access that was working fine. I upsized Access to
SQL
server and now I link to an SQL table that I open in Access. Now I get
a
#NAME? error on my report. I checked the field names and all is fine.
Does
SQL server require different expression syntax? My control source is
=[fieldname]+" text".
Click to expand...
Click to expand...
Click to expand...
 
Service Packs are available from the Microsoft web site. You can try this
link http://office.microsoft.com/en-us/officeupdate/default.aspx

Also, references might be an issue.
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

--
Duane Hookom
MS Access MVP


Me! said:
Well, maybe this is bigger than I thought. I thought we would just have
to
modify our reports, but we found that another workstation runs the report
just fine. Could this be similar to the post below from 1-9-2005? What
is
SP 3?

Me! said:
Sorry, I'm not sure what you are talking about. I'm self taught at this
time. Just in case there is a deeper problem, the report results were as
expected when we were using a test server. When we moved our data to our
production server we began to have errors. We have ="Page " & [Page] & "
of
" & [Pages] for our reports which has worked well up until we upsized to
SQL
server as well, now we get the #NAME? error there as well.

Duane Hookom said:
I expect your control name is the same as your field name. Change it to
"txtFieldName".

--
Duane Hookom
MS Access MVP
--

I have tried that, as well as other combinations and I still get the
same
result: #NAME? I had another column in my report that was doing the
same
thing, but I only needed the field displayed and not any text added
to it.
I
removed the = sign and the brackets and now it works just fine. I
just
can't
figure out how to add the word "Total:" to my field data.
Thank you for responding.
Lisa

:

Is there a reason you didn't use:
=[fieldname] & " text"

--
Duane Hookom
MS Access MVP


I wrote a report in Access that was working fine. I upsized Access
to
SQL
server and now I link to an SQL table that I open in Access. Now
I get
a
#NAME? error on my report. I checked the field names and all is
fine.
Does
SQL server require different expression syntax? My control source
is
=[fieldname]+" text".
Click to expand...
Click to expand...
Click to expand...
 
Thank you so much for your help! I believe this has gone beyond my level of
understanding and I have referred this "higher". But it was a good learning
experience.
Thank you again,
Lisa

Duane Hookom said:
Service Packs are available from the Microsoft web site. You can try this
link http://office.microsoft.com/en-us/officeupdate/default.aspx

Also, references might be an issue.
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

--
Duane Hookom
MS Access MVP


Me! said:
Well, maybe this is bigger than I thought. I thought we would just have
to
modify our reports, but we found that another workstation runs the report
just fine. Could this be similar to the post below from 1-9-2005? What
is
SP 3?

Me! said:
Sorry, I'm not sure what you are talking about. I'm self taught at this
time. Just in case there is a deeper problem, the report results were as
expected when we were using a test server. When we moved our data to our
production server we began to have errors. We have ="Page " & [Page] & "
of
" & [Pages] for our reports which has worked well up until we upsized to
SQL
server as well, now we get the #NAME? error there as well.

:

I expect your control name is the same as your field name. Change it to
"txtFieldName".

--
Duane Hookom
MS Access MVP
--

I have tried that, as well as other combinations and I still get the
same
result: #NAME? I had another column in my report that was doing the
same
thing, but I only needed the field displayed and not any text added
to it.
I
removed the = sign and the brackets and now it works just fine. I
just
can't
figure out how to add the word "Total:" to my field data.
Thank you for responding.
Lisa

:

Is there a reason you didn't use:
=[fieldname] & " text"

--
Duane Hookom
MS Access MVP


I wrote a report in Access that was working fine. I upsized Access
to
SQL
server and now I link to an SQL table that I open in Access. Now
I get
a
#NAME? error on my report. I checked the field names and all is
fine.
Does
SQL server require different expression syntax? My control source
is
=[fieldname]+" text".
Click to expand...
Click to expand...
Click to expand...
 
Back
Top