Recent content by Steve27597

  1. S

    Barcode Scanner to launch another form

    Thanks guys. I used both your responses. I decided just to create a text box on the main form and used the "After Update" event on the field. Then I passed the field using the DoCmd calling the form. I used the information I used from a previous reply from Paul. This will work! Liking...
  2. S

    Barcode Scanner to launch another form

    boerbende, I understand your docmd, but what even would I tie that to? If I was sitting on a form with no fields, just buttons, what even would be triggered with a barcode scan (and carriage return programmed in scanner)? Thanks for your response, Steve
  3. S

    Barcode Scanner to launch another form

    PBaldy, Can I do it without a msgbox? My Main Form is a simple form with a couple of push buttons. Or should I put a textbox on the main form and wait for input there? Thanks for the response, -Steve
  4. S

    Barcode Scanner to launch another form

    Hello All. Still working on an meeting registration app in Access. I have a Main menu which contains buttons that allow search by Name, Phone Number, or Account Number. We are using barcode scanners if they have a registration card. Currently I have an account button which pops up a query prompt...
  5. S

    Form to select name and launch new form

    Thanks one more time pbaldy. I figured out by looking at some other posts that I was missing the quotes in the criteria section. Final code looks like this: Dim SelAcct As String SelAcct = Me.Account DoCmd.Close DoCmd.OpenForm "AccountFormBlank", , , "Account = '" + SelAcct + "'"...
  6. S

    Form to select name and launch new form

    THANK YOU! Definitely getting closer. I am seeing my debug.print statements execute and I see that I have the account number selected. Now I am getting a Run-time error '3464', Data type mismatch in criteria expression. It is getting hung up on the DeCmd.OpenForm line. Here is the current...
  7. S

    Form to select name and launch new form

    Thanks pbaldy for the reply. That sounds exactly like what I want but I keey getting a Compile Error: Syntax error. Here is my code: Private Sub Account_DblClick(Cancel As Integer) Dim SelAcct As String SelAcct = Me.Account Debug.Print "TEST" Debug.Print SelAcct...
  8. S

    Form to select name and launch new form

    Hello everyone! I am working on an access database that is a meeting registration database. It is relatively simple in concept: You can search by Name, Phone, or Account Number and then mark the person as registered. What I am trying to create is an enhanced search by name. I have created a...
See more
Back
Top Bottom