Employee Barcode scan IN and OUT using Access 2007
in [Form]
|
Prev: How to display progress on slow opening form.
Next: Help with an expression to calculate a profit from one of three fi
From: jfire via AccessMonster.com on 29 May 2010 17:44 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/Forums.aspx/access-forms/201005/1
From: Arvin Meyer [MVP] on 29 May 2010 17:52 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(a)uwe> wrote in message news:a8bf255a2abfa(a)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/Forums.aspx/access-forms/201005/1 >
From: jfire via AccessMonster.com on 29 May 2010 20:11 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
From: PieterLinden via AccessMonster.com on 30 May 2010 03:48 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
From: Arvin Meyer [MVP] on 31 May 2010 15:17
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(a)uwe> wrote in message news:a8c06dc20e134(a)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 > |