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