fields showing up on some computers, not others

  • Thread starter Thread starter dave b
  • Start date Start date
D

dave b

I've create a report based on a query. One text box uses two fields: works
fine. Another box uses a single field: works fine. The last box uses the
following formula: ADATE & " " & format(ATIME, "Short Time").

I put the database on a server. I can see the last box fine. Two others can
see it fine. However, a couple of other computers only see #name, instead of
the data. Is this an Access problem, or computer problem?
 
What happens if you add brackets?

=[ADATE] & " " & Format([ATIME], "Short Time")

Are the actual names of ADATE and ATIME both a control name and field name
in the report? If so, try changing the control names to txtADATE and
txtATIME to disambiguate them. If you are using fields in the report's
Record Source, but these fields aren't bound to controls on the report, you
may need to place hidden textboxes on the report and bind them to these
fields.

If any of these solve the problem, then I would guess that you have more
than one version of Access on the multiple computers and/or they are at
different patch levels and some of these different versions/patch levels are
pickier than others.


Another possibility is that there is a References problem on the computers
that display #Name and they don't like the Format() function. For help with
References problems, see this article.

http://www.allenbrowne.com/ser-38.html
 
I thought you were making up a word (disambiguate), but it turns out to be
real. Curiously, "ambiguate" is not, at least not in Encarta, which
validated "disambiguate". This is not relevant to anything; it's just a
passing comment.

Wayne Morgan said:
What happens if you add brackets?

=[ADATE] & " " & Format([ATIME], "Short Time")

Are the actual names of ADATE and ATIME both a control name and field name
in the report? If so, try changing the control names to txtADATE and
txtATIME to disambiguate them. If you are using fields in the report's
Record Source, but these fields aren't bound to controls on the report,
you may need to place hidden textboxes on the report and bind them to
these fields.

If any of these solve the problem, then I would guess that you have more
than one version of Access on the multiple computers and/or they are at
different patch levels and some of these different versions/patch levels
are pickier than others.


Another possibility is that there is a References problem on the computers
that display #Name and they don't like the Format() function. For help
with References problems, see this article.

http://www.allenbrowne.com/ser-38.html

--
Wayne Morgan
MS Access MVP


dave b said:
I've create a report based on a query. One text box uses two fields:
works
fine. Another box uses a single field: works fine. The last box uses
the
following formula: ADATE & " " & format(ATIME, "Short Time").

I put the database on a server. I can see the last box fine. Two others
can
see it fine. However, a couple of other computers only see #name,
instead of
the data. Is this an Access problem, or computer problem?
Click to expand...
Click to expand...
 
Back
Top