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.
Comments
Post a Comment