Employee Barcode scan IN and OUT using Access 2007

[jfire via AccessMonster.com]

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.

 

[Arvin Meyer [MVP]]

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]

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.

 

[PieterLinden via AccessMonster.com]

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]
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

 

[Arvin Meyer [MVP]]

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

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.