The fact that this shows as #Error suggests a problem with the References on
the machine where the runtime is installed.
What libraries have you referenced under Tools | References (from a code
window)? If you have more than the standard 3 (VBA, Access, and DAO), does
the runtime package install the others? Do you have the licencing
permissions for this to work?
It is quite awkward to work around broken references programmatically, but
this article by michka may help:
http://www.trigeminal.com/usenet/usenet026.asp?1033
Basic info on references:
http://members.iinet.net.au/~allenbrowne/ser-38.html
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Paul" <pz****@rogers.com> wrote in message
news:6a********************@rogers.com...
I'm hoping someone can help me with the problem.
I have a database where the default value for a date field in a table is
=date()
This works perfectly in my table and on my form. But when I complile the
DB into a 97 Runtime, the date field displays and #error? in the runtime.
But if I open the runtime db on a system with Access 97, there is no
error. I have tried the runtime on mulitple systems (that dont have Access
installed) and I get the same error, and when I try it on multiple systems
that do have Access installed, it works perfectly.
Does anyone have any insight into this matter. Because after 3 days of
trying to get around this, I am stumped!!!
PS. I know how to use code to set the value, but I don't want to. I need
it the way it is for a few reasons.
Thanks
Paul