A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Employee Barcode scan IN and OUT using Access 2007



 
 
Thread Tools Display Modes
  #1  
Old May 29th, 2010, 10:44 PM posted to microsoft.public.access.forms
jfire via AccessMonster.com
external usenet poster
 
Posts: 5
Default 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  
Old May 29th, 2010, 10:52 PM posted to microsoft.public.access.forms
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default 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  
Old May 30th, 2010, 01:11 AM posted to microsoft.public.access.forms
jfire via AccessMonster.com
external usenet poster
 
Posts: 5
Default 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  
Old May 30th, 2010, 08:48 AM posted to microsoft.public.access.forms
PieterLinden via AccessMonster.com
external usenet poster
 
Posts: 307
Default 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  
Old May 31st, 2010, 08:17 PM posted to microsoft.public.access.forms
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:19 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.