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.
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.