MS-Access VBA Date() works on one PC but not others -
i designing first database ground , have learned lot in last few weeks. 1 thing has been eating @ me though on login page have simple unbound text box control source =date() . this works on computer use days, other computer in facility working out of displays #name? instead of date. i have tried changing =now() , works fine on computers. apparently =date() has issues. if fields control source changed =date() informed the function entered can't used in expression . i have checked ms-access versions , tried on machines , without access. i need date() work because used elsewhere in more vital areas of code , may not able use now() in place. ideas why may not work on pc besides own? date() controlled visual basic applications x.xx reference. make sure reference installed , competing references removed. to this, open vba window , go tools --> references , ensure proper 1 checked.