Search results for query: *

It's fixed, but I do not know why!! The database is split, with the tables on a shared drive and customised apps on each user's personal drive. I found that the Date() function was only playing up in the user's apps, it worked fine in the tables. I created new mdb files and imported all...

AccessAdict, I feel your frustration, I too have tried regional settings, no settings are different on the offending PCs. Unfortunately I am only able to 'verify' the Access application (gov. client with NT and server based apps), not able to change installation options. Client will not...

CMooreJR, thanks for the hint. I have since tried again but to no avail. I get the same error on these new PCs wherever I have used Date(), forms where current date is default, reports where system date is used to calculate a client's age or unbound fields to nominate the date of the report...

What formatting do you lose?, if it is date/time it could be your PCs regional settings. Have you tried linking the spreadsheet and including it as a table in the database. Use file>get external data>link tables.

I have just created a database for a client. I have used the Date() function throughout the application to retrieve the system date, it has worked fine on my PC as well as theirs. I have just loaded the database to new PCs that the client has had installed. Now wherever I have used Date() the...