Table-Level Validation Error Message

K

Karen

Hi,

I have an Access 2003 app that has a .mde front-end and .mdb back-end. The
app is distributed with the runtime as several potential users do not have
Access. When I run the .mde on my development machine in runtime mode
everything is fine. Specifically I have some tables that default datetime
field values of either Date() or Time().

I also have a 'clean' machine on which I test the install. The 'clean'
machine is XP Pro with only Word installed. I use Norton Ghost to reload
the 'clean' environment for each test.

The install is fine but there are two forms that open with fields which
should have the Date() and/or Time() automatically filled in, on the 'clean'
machine, yet I get an error message 'Function is not available in
expressions in table-level validation expression'. The fields have the
'#Name' expression instead of the date.

I do not table-level validation anywhere in the app.

I've done an internet search on the error and can't find anything that may
explain the problem.

Any help would be very much appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top