Formatfunction displays #naam?

  • Thread starter Thread starter dpa.beverwijk
  • Start date Start date
D

dpa.beverwijk

Hi

My database is based on Front(clients) and backend (server)
Installed on 4 clients same Frontend Windows XP prof and Office 2000
3 of the 4 clients running smoothly
Nr 4of the clients has a problem in the reportfunction
i.e.
Format([dat arr];"yyyy-mm-dd") & " - " & Format([tijd arr];"hh\.nn")
displayed #naam?
I copied a new frontend to this particular client still same
problem.

What is wrong ??

Thanks for your help
Best regards
Ron
 
I suspect Access either doesn't recognize the Format() function (in which
case, check your References for any MISSING), or doesn't recognize one of
your field names.

You didn't say where you've placed the "Format(...)" expression.
 
Hi Jeff

The computers do have the same operating system Windows XP Prof
and same Office 2000 installed
they have all the same front-end(copied)

the format expression is placed in a report

check yr references? sorry my access is in Dutch where can I find this


waiting yr news
Ron



Jeff Boyce schreef:
I suspect Access either doesn't recognize the Format() function (in which
case, check your References for any MISSING), or doesn't recognize one of
your field names.

You didn't say where you've placed the "Format(...)" expression.

--
Good luck

Jeff Boyce
<Access MVP>

Hi

My database is based on Front(clients) and backend (server)
Installed on 4 clients same Frontend Windows XP prof and Office 2000
3 of the 4 clients running smoothly
Nr 4of the clients has a problem in the reportfunction
i.e.
Format([dat arr];"yyyy-mm-dd") & " - " & Format([tijd arr];"hh\.nn")
displayed #naam?
I copied a new frontend to this particular client still same
problem.

What is wrong ??

Thanks for your help
Best regards
Ron
Click to expand...
Click to expand...
 
The installation of new software on a PC may "break" links Access uses to
refer to its code modules.

Open a code module on the affected PC. Click Tools | References.

If any are marked MISSING, note which ones, uncheck them, save/close.

Then go back into References and re-check, save/close. Re-compile (Debug |
Compile).

Good luck!

Jeff Boyce
<Access MVP>

Hi Jeff

The computers do have the same operating system Windows XP Prof
and same Office 2000 installed
they have all the same front-end(copied)

the format expression is placed in a report

check yr references? sorry my access is in Dutch where can I find this


waiting yr news
Ron



Jeff Boyce schreef:
I suspect Access either doesn't recognize the Format() function (in which
case, check your References for any MISSING), or doesn't recognize one of
your field names.

You didn't say where you've placed the "Format(...)" expression.

--
Good luck

Jeff Boyce
<Access MVP>

Hi

My database is based on Front(clients) and backend (server)
Installed on 4 clients same Frontend Windows XP prof and Office 2000
3 of the 4 clients running smoothly
Nr 4of the clients has a problem in the reportfunction
i.e.
Format([dat arr];"yyyy-mm-dd") & " - " & Format([tijd arr];"hh\.nn")
displayed #naam?
I copied a new frontend to this particular client still same
problem.

What is wrong ??

Thanks for your help
Best regards
Ron
Click to expand...
Click to expand...
Click to expand...
 
Hi Jeff

Sorry found the problem

Mr Stefan Labans program Rotate Label was not installed on this
computer

To Mr Stefan Labans
Is there a possibility to include this Rotate into the front-end
without installing a seperate program ??

Thanks for your help
 
Back
Top