Lots of smart people here... Anyone know Access?

Discussion in 'Bad Dog Cafe' started by Ziggy, Jun 26, 2019.

  1. Ziggy

    Ziggy Tele-Holic

    Posts:
    721
    Joined:
    Dec 10, 2009
    Location:
    Tennessee
    Greetings


    I have searched for an answer on line but haven’t found anything that looks right. Maybe I am not using the right search terms.


    Here is what I am trying to do:


    We use Access 2003 (yes, 2003) to track our equipment. Each piece is represented by a record in a table. When the piece of equipment comes in we have an Access form that we use to manage the inventory.


    The form has a button that lets us search for the record by typing in the equipment name. In other words it searches a field in the table and then pulls up the record corresponding to the specific piece of equipment. Then we have another button that changes a different field in the record to the current date.


    I have set up a barcode system and have the system working to where when we search for a piece of equipment we can scan the barcode and it will enter the equipment name. (I am using Code 39)


    What I would like to do is to create a barcode to print to a piece of paper that would perform the action of updating the record. In other words, I would like to be able to scan a barcode and have it perform the “date” record change. This way I could post the paper barcode to the bench and we could use the scanner to both pull up the record and then update it by scanning each barcode separately. (Maybe even create a macro to perform both actions and just scan one barcode... I don't know.)


    I know that the barcode scanner is merely sending inputs like a keyboard or mouse. I am just not sure what text inputs to send or how to find out. Can custom hot keys be set up for specific buttons in forms?


    I have worked with macros. Forms, reports, queries, etc… but I am not sure how to proceed here. I don’t mind spending the woodshed time learning but I would really appreciate if someone here can point me to the proper resources. Or better yet, if someone has done something similar I would love to hear how.


    Thank you.
     
  2. Ziggy

    Ziggy Tele-Holic

    Posts:
    721
    Joined:
    Dec 10, 2009
    Location:
    Tennessee
    bump
     
IMPORTANT: Treat everyone here with respect, no matter how difficult!
No sex, drug, political, religion or hate discussion permitted here.


  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.