471,073 Members | 1,304 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,073 software developers and data experts.

A97 - Date error in Runtime

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
Nov 13 '05 #1
2 3339
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

Nov 13 '05 #2
Paul wrote:
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.


I can't help you, but I know of a couple of machines in my organization
that are using an Access runtime application which completely fouls up
the references in A97 so that sone functions and date expressions using
the format funtion fail completely.

I always figured it was something the developer had done which badly
affected the A97 set ups we have.
--
Tim
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Raskolnikow | last post: by
1 post views Thread by Shane | last post: by
5 posts views Thread by Donkey | last post: by
5 posts views Thread by mabond | last post: by
5 posts views Thread by iwasinnihon | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.