Reference https://www.accessforums.net/access/...-ss-24130.html
I am a novice so please excuse my ignorance, where and how do I implement this code into my database.
Reference https://www.accessforums.net/access/...-ss-24130.html
I am a novice so please excuse my ignorance, where and how do I implement this code into my database.
The referenced thread shows a VBA custom function, probably placed in a general code module. Then the function can be called from mostly anywhere in the database - a query or textbox or in other VBA code.
To start learning about programming in Access, review https://support.office.com/en-US/Art...rs=en-US&ad=US
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thanks for your quick reply and for pointing me in the right direction will have a read and hopefully make some sense of it.