Page 4 of 4 FirstFirst 1234
Results 46 to 56 of 56
  1. #46
    Dan Lee is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2017
    Posts
    57
    Steve,



    I got my Bar Code Scanner & some sample Bar Codes. I have a couple of questions:

    How can I clear the registration form to start a new one?

    When I scan a bar code, the data goes into the first field. When I scan again the data goes into the next field. I want it to jump to the first field of the next record.
    How can I fix that?

    Thanks,
    Dan

  2. #47
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    How can I clear the registration form to start a new one?
    Are you wanting to scan say 10 bar codes, then fill in the people names infor later?

  3. #48
    Dan Lee is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2017
    Posts
    57
    Quote Originally Posted by ssanfu View Post
    Are you wanting to scan say 10 bar codes, then fill in the people names infor later?
    Not quite. I want to scan one bar code, then fill in the names, addresses etc. Then scan another bar code and do the same, but I could skip the names etc. if rushed. I need to have a cleared form, when I start.

    I ordered a book on Microsoft Access to help me.

  4. #49
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Is this close to what you want?
    Attached Files Attached Files

  5. #50
    Dan Lee is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2017
    Posts
    57
    I get an error when loading tRegistration7. It says an error occurred while loading Form_fmRegistration.

    I think that I need a Clear Registration button also.

  6. #51
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    I set the new form "frmAddRegistration" to Data Entry Mode. When you click the SAVE button, the form is cleared.

    I don't have access to my A2K version right now.
    Can you open the form in design view? If yes, close the form and do a "Compact & Repair", then try opening it.

  7. #52
    Dan Lee is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2017
    Posts
    57
    Quote Originally Posted by ssanfu View Post
    I set the new form "frmAddRegistration" to Data Entry Mode. When you click the SAVE button, the form is cleared.

    I don't have access to my A2K version right now.
    Can you open the form in design view? If yes, close the form and do a "Compact & Repair", then try opening it.
    I did the 'Compact & Repair', it still gives an error.

    I should be getting my 'Access' book soon.

  8. #53
    Dan Lee is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2017
    Posts
    57
    In Form_Main, there is some kind of error in this statement.

    Private Sub Form_Load()
    Me.ubRptDate = Date
    End Sub

    I think that this is a duplicate declaration of Sub Form_Load. which is declared in Form_frmVotesBlue.


    Private Sub Form_Load()
    Me.ubBarCode.SetFocus
    End Sub

  9. #54
    Dan Lee is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2017
    Posts
    57
    The program can't open "frmRegistration". It doesn't appear to be loaded.

    Private Sub btnRegistration_Click()
    DoCmd.OpenForm "frmRegistration"
    Me.Visible = False
    End Sub

  10. #55
    Dan Lee is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2017
    Posts
    57

    Latest Version

    Steve,

    Attached is the latest version. I have made some progress. I am now working with the scanner to input the data.

    Dan
    Attached Files Attached Files

  11. #56
    Dan Lee is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2017
    Posts
    57
    I want the 'AddRegistration Form' to act like the 'Vote Form'. When I click the button, it should open a new record. When I scan a Bar Code, it should be recorded, and the cursor Tab to the Car Number window. The remainder of the record can be filled in at that time or later. When I have finished with the AddRegistration, I need a Save & Continue button. At that time a new record will open, and I can scan the next bar Code. I still need the Save & Close button.

    I have ordered a VBA book as well. I hope to see that by the end of the week.

Page 4 of 4 FirstFirst 1234
Please reply to this thread with any new information or opinions.

Similar Threads

  1. 30 day registration for access
    By CHEECO in forum Access
    Replies: 7
    Last Post: 06-05-2016, 12:31 PM
  2. Using access registration details
    By BSJoJaMAx4 in forum Access
    Replies: 7
    Last Post: 10-05-2015, 06:05 PM
  3. registration database
    By hodagh in forum Queries
    Replies: 7
    Last Post: 11-05-2012, 12:52 PM
  4. Registration of Attendees
    By camende in forum Programming
    Replies: 1
    Last Post: 06-30-2010, 03:47 PM
  5. Registration Form
    By nengster in forum Forms
    Replies: 0
    Last Post: 02-16-2009, 04:22 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums