Reply to dawber39's Post: I am using Access 2003

Reply to dawber39's Post: I will try stand by

'O.K. I have made some progress.... This works well when someone scans a barcode that is "In the List" Now, how about when it a "Not in the List Event" I want it to do the same procedure. Clear out the bad data and allow another card to be scanned.

'Here is the good.

Private Sub SSN_Exit(Cancel AS Integer)

DoCmd.GoToRecord , , acNewRec
Me.SSN.SetFocus
DoCmd.OpenForm "FrmRecallSuccess"

End Sub

'Here is the code for the "Not in List Event"

Private Sub_NotInList(NewData As String, response As Integer)

response = acDataErrContinue
DoCmd.OpenForm "frmRecallAttentionNeededMessage"
DoCmd.GotoRecord , , acNewRec
Me.SSN.setfocus

End Sub

Reply to dawber39's Post: Scaning of the actual barcode. It's a single field on a form. All it does it accept barcodes. This field is a combobox that is linked to the primary key the SSN. I have attached the event to get a Green form when the data in in the list and get a Red form when the data in not in the list. After the scan I wish the field to evaluate if the data is in the list. This forms a table of barcode entries that I latter do a find unmatched query on the know data with the data retireded. Wa La! I get a list of people that did not sign in. All the personnel who attend a metting have a barcoded Id card. I can find out who did attend my creating this relaitonship. The database works well when you just enter SSN numbers. I am trying to have the user not have to touch the screen or keys at all. I just want them to get a visual indicator that they signed in successfully or not. A person at the door will monitor the screen without interferance unless some scans a card that is not in the list. The screen with turn red and then the person will need to print their name on a list and sign it to get credit for being present for the meeting. It will also help identify bad ID cards or barcodes. Does that help a little. It's almost 1000 PM where I am. Getting a little tired.

Wow that was awful, Let me try again.

Scanning of the actual barcode activates the event. It's a single field on a form. All the form does is accepting barcode scans. This field is a combo box that is linked to the primary key the SSN. I have attached the event to get a green form when the data is in the list and get a Red form when the data in not in the list. After the scan I wish the field to evaluate if the data is in the list and open the appropriate form. This forms a table of barcode entries that I later do a find unmatched query on. The know data associated with the barcode data. Wa La! I get a list of people that did not sign in. All the personnel who attend the meeting have a bar-coded ID card. I can find out who did attend by creating this relationship to the know data. The database works well when you just enter SSN numbers. I am trying to have the user not have to touch the screen or keys at all. I just want them to get a visual indicator that they signed in successfully or not. A person at the door will monitor the screen without interference unless someone scans a card that is not in the list. If the screen turns red then the person will need to print their name on a list and physically sign-in to get credit for being present at the meeting. It will also help identify bad ID cards or barcodes. Does that help a little? It's almost 1000 PM where I am and I am getting a little tired.

Well, that didn't work that well. I like the If statement part. I think the code is missing something or is wrong is some way. I attached it event to the lost focus instead of the ON eXIT EVENT. With the same result. Now the Attentionneeded message appears and the Green one gets skipped.

You deserve more than 15 bucks, how do I do that?

AAAAAH, It got stuck on

If Exists SSN then (Syntax error)

I have a table

(tblrecallsignin) that has these fields;

SSN (Control Source) showing only the barcode field in the combobox event though what is actually entered is the Barcode
(look up column that selects the SSN with the underlined SQL statements row source being SSN.

Arrival Time

POST

Onduty


The Form is based on the tblpersonalinfo

The Main table= tblpersonalinfo

Fields=
SSN
First Name
Last Name
Middle Initial
Barcode

The Second Table=
tblRecallsignin
SSN=Shows SSN


Form for First Table is Normal
SSN
First Name
Last Name
Middle Initial
BarCode

Form for Second Table is based on first table and build from it
SSN (Look UP to First Table)
ArrivalTime= Now()

Reply to dawber39's Post: tblrecallsignin

The field on the form reachs out to the tblpersonnelinformation in the form of a look up.

SELECT tblpersonnelinformation.SSN, tblpersonnalinformation .[CAC Card BarCode] FROM tblPersonnelInformation;