If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Employee Barcode scan IN and OUT using Access 2007
I have been working on a project where an employee's scans IN with a barcode
ID and scans OUT with barcode. My problem is when they scan in I want to see who is scaning in and out without opening and closeing the form to refresh each time. My question is can you have two forms "Scan IN form" and "List form" active at the same time so someone can just sit and monitor who is coming in and out without doing anything to the PC. If anyone has any ideas or have sean any templates like this please let me know. Thanks for any help. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201005/1 |
#2
|
|||
|
|||
Employee Barcode scan IN and OUT using Access 2007
Within Access, you can have as many forms as is practical open, subject of
course to your available memory. In order to see what is happening on another computer on the network, you will need to refresh the data frequently. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.accessmvp.com http://www.mvps.org/access Co-author: "Access 2010 Solutions", published by Wiley "jfire via AccessMonster.com" u60367@uwe wrote in message news:a8bf255a2abfa@uwe... I have been working on a project where an employee's scans IN with a barcode ID and scans OUT with barcode. My problem is when they scan in I want to see who is scaning in and out without opening and closeing the form to refresh each time. My question is can you have two forms "Scan IN form" and "List form" active at the same time so someone can just sit and monitor who is coming in and out without doing anything to the PC. If anyone has any ideas or have sean any templates like this please let me know. Thanks for any help. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201005/1 |
#3
|
|||
|
|||
Employee Barcode scan IN and OUT using Access 2007
Arvin Meyer [MVP] wrote:
Within Access, you can have as many forms as is practical open, subject of course to your available memory. In order to see what is happening on another computer on the network, you will need to refresh the data frequently. I have been working on a project where an employee's scans IN with a barcode [quoted text clipped - 7 lines] or have sean any templates like this please let me know. Thanks for any help. Maybe I wasn't clear, this is all on one PC. A employee scans in using barcode this shows up on the screen. Right now when this happens a query pops up showing the employee has scaned in including all previous employee's that have scaned in not a problem. I would like the pop-up query only show for a few seconds and then disapear being ready for the next employee to scan in. I don't want the person watching the monitor have to press any keys just watch to make sure everyone scans in. My question is can I make the pop-up query disapear after a few seconds without doing anything from the keyboard or mouse. -- Message posted via http://www.accessmonster.com |
#4
|
|||
|
|||
Employee Barcode scan IN and OUT using Access 2007
jfire wrote:
Within Access, you can have as many forms as is practical open, subject of course to your available memory. In order to see what is happening on [quoted text clipped - 5 lines] or have sean any templates like this please let me know. Thanks for any help. Maybe I wasn't clear, this is all on one PC. A employee scans in using barcode this shows up on the screen. Right now when this happens a query pops up showing the employee has scaned in including all previous employee's that have scaned in not a problem. I would like the pop-up query only show for a few seconds and then disapear being ready for the next employee to scan in. I don't want the person watching the monitor have to press any keys just watch to make sure everyone scans in. My question is can I make the pop-up query disapear after a few seconds without doing anything from the keyboard or mouse. So create a form based on your query, then use the OnTimer event to close the form after some number of milliseconds. Check the VBA help for OnTimer -- Message posted via http://www.accessmonster.com |
#5
|
|||
|
|||
Employee Barcode scan IN and OUT using Access 2007
What happens if the employee isn't quick enough, or worse, is distracted
halfway through? You can use a Timer in the popup form to close it after n milliseconds, but are you sure that you want to? A better solution would be just to close the form immediately after the data is filled in. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.accessmvp.com http://www.mvps.org/access Co-author: "Access 2010 Solutions", published by Wiley "jfire via AccessMonster.com" u60367@uwe wrote in message news:a8c06dc20e134@uwe... Arvin Meyer [MVP] wrote: Within Access, you can have as many forms as is practical open, subject of course to your available memory. In order to see what is happening on another computer on the network, you will need to refresh the data frequently. I have been working on a project where an employee's scans IN with a barcode [quoted text clipped - 7 lines] or have sean any templates like this please let me know. Thanks for any help. Maybe I wasn't clear, this is all on one PC. A employee scans in using barcode this shows up on the screen. Right now when this happens a query pops up showing the employee has scaned in including all previous employee's that have scaned in not a problem. I would like the pop-up query only show for a few seconds and then disapear being ready for the next employee to scan in. I don't want the person watching the monitor have to press any keys just watch to make sure everyone scans in. My question is can I make the pop-up query disapear after a few seconds without doing anything from the keyboard or mouse. -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|