I have a data-entry form in my database that uses the function =Date() in the default value of a text box to return the current date. This function works fine on my PC, but I just split the database, since this is going to be a multi-user database, and I installed the front-end on some of my co-workers PCs, and it's giving me a #Name error using that function. I tried =Now() and that works, but I just want the date, not the time.
Does anyone know what the problem is? I'm assuming it's something simple, but, I'm not sure.
Also, my PC a Win98 machine, and the other ones I've tried it are 2000 machines, but both are running Access 2K. Don't know if that makes a difference, but I don't know why it would.
Originally posted by VBAPROGRAMMER
Date() and Short Date both will do .I am attaching an example take a look at it.
Date() doesn't work. It will work on my PC, but not on the PC running Win2K. I even tried copying the front-end from my PC to the other one, and it still doesn't work. Now() works, but even with the format set to short date in both the table and form it still returns the time also. I guess it doesn't really matter if the time is stored also, as long as my queries that use a date range will still work with the time being stored in the date field. I just don't understand why it works on one PC and not the other. Maybe I'll copy it to a couple of other PCs and see if I get the same problem.