I have a database that I'm using to use to check employees in and out of work. I am working on adding a scanner to scan their their ID cards.
Is it possible to write a command on my form that 'on open' will tell my form to change a field to 'yes' if it's 'no' and 'no' if it's 'yes'?
The idea is that when it's set to no, the employee is not at work but if it's yes then they are at work. By scanning their ID barcode, it will set it to yes or no depending on whether their coming or going.
Is it possible to write a command on my form that 'on open' will tell my form to change a field to 'yes' if it's 'no' and 'no' if it's 'yes'?
The idea is that when it's set to no, the employee is not at work but if it's yes then they are at work. By scanning their ID barcode, it will set it to yes or no depending on whether their coming or going.
