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

Popular posts from this blog

python - pip install -U PySide error -

arrays - C++ error: a brace-enclosed initializer is not allowed here before ‘{’ token -

cytoscape.js - How to add nodes to Dagre layout with Cytoscape -