Hi
I’m not sure if I’m posting in the right place but:
a couple of years ago, Accestos kindly wrote a module for me.
In a nutshell it compares two tables and assigns a numbered key to a lock to a member who does not have one.
For the last two years it has worked fine but I think the coding does not take account of keys that were not returned and are no longer available but for audit purposes remain in the table as used but in previous years.
I need a piece of code which takes advantage of the ‘used’ field which Accestos did not use in his original coding in favour of ‘good housekeeping’ and he was probably right!
When run, the code issues every number in the table but takes no account of the used flag
Below is a link to his code in my original post
I’d be really grateful if someone could help. I understand queries but SQL is way out of my league!
I’m looking to insert something like “WHERE used Is True” in New_key_register
Much appreciated
Pete
https://www.accessforums.net/showthr...488#post473488