Been delayed by some health issues but hope to get back to it today. I will keep you all posted on the status.![]()
Ok, just trying to re-wrap my head around this thing. June7, so they come in to Check Out at the computer, the form is up with the option buttons Check In Check Out. They choose Check Out. Is the Combo Box called( made visible) to choose their name or is this something that would just be a normal part of the form?
What process do you want? The form can open with only the combobox to select ID available or a textbox for ID card scan. Then once the ID is input (by combobox or scan) other controls such as the Check In/Out buttons can be made available. Click CheckIn and more controls are available for the additional info input. Click CheckOut and the existing record is located and updated. Associated with each button is code to close form or reset back to original state for next user input.
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.
I would think the Scan of the ID would be the better process as the initiator as to Check In or Check Out. This would be providing/updating info that is available, if any, or start a new record correct?What process do you want? The form can open with only the combobox to select ID available or a textbox for ID card scan. Then once the ID is input (by combobox or scan) other controls such as the Check In/Out buttons can be made available. Click CheckIn and more controls are available for the additional info input. Click CheckOut and the existing record is located and updated. Associated with each button is code to close form or reset back to original state for next user input.
I think that is essentially what I suggested.
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.
Been there. Not fun.
I meant you seem to understand what I have offered as a suggested process. If that's the approach you want and you encounter specific issue with implementation, don't hesitate to post question.
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.