date function printed #Name?

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

Guest

I make an mde that run a report on the pc that has access 2002 runtime to
print the date function but it printed #Name?
The code I had on the report is: =Format(Date(),"Long Date")
Please help.

Thanks,
Nghiem
 
Assuming that it works on your PC, the References collection is probably
messed up. Unfortunately, with an MDE, you're limited as to what you can do.
This is because you cannot get to the References dialogue in an MDE (nor can
you change the References if you could).

What you can try and do is ensure that the same referenced files exist on
all workstations. On the workstation where the application was developed,
open up the MDB that was used to create the MDE. Run the following code to
determine all of the required references:

Sub ListReferences()
Dim refCurr As Reference

For Each refCurr In Application.References
Debug.Print refCurr.Name & ": " & refCurr.FullPath
Next

End Sub
Find each of the files listed above and determine the version of each.

In fact, if you grab the code from
http://www.mvps.org/access/api/api0065.htm at "The Access Web", you can even
have the code above determine the file versions for you:

Sub ListReferences()
Dim refCurr As Reference

For Each refCurr In Application.References
Debug.Print refCurr.Name & ": " & refCurr.FullPath & _
" (" & fGetProductVersion(refCurr.FullPath) & ")"
Next

End Sub

Next, on the workstation(s) where the application isn't working, check to
see that the exact same version of each of those files is located in exactly
the same location.
 
Back
Top