Mastering Microsoft Access: How to Search for Existing Records and Add New Ones with Ease

[@RungeCarl]

Brilliant as usual.

[@dohcvtec1981]

I love your videos and it taught me a lot from a beginner. Here is my question, while in an opened form I’d like to check if a record existed when typing in the data field and if yes go to the record. Previously I built another database file, I was able to do the check and open a different form (like customer details) when data existed, but not able to figure out how to do the very same thing on the same form. 🙏 Thanks

[@rogerazevedo4094]

You’re a legend. Thanks very much for solving my problem.

[@599CD]

Happy to help

[@michael23864]

Very helpful Richard thanks

[@599CD]

Welcome

[@paulojorgecasanova]

I love your explanations, for me you are the best... you are a great teacher, thank you.

[@599CD]

Welcome

[@christofzwanziger4997]

Thank you for your top video explanation. They helped me a lot in developing my db.

[@agoughgrim]

Same here!!

[@599CD]

welcome

[@joseancheta3817]

Thank you! Although my scenario is slightly different, this code is definitely useful.

[@599CD]

You're very welcome

[@toddbigcat8400]

Might want to add that if you are looking up character vs numbers then the Dim function needs to be - Dim ID as String - . Using the Long option will give a Type mismatch error when entering any thing else but numbers. Also change - If ID ="0" - and the end of the DLookup statement needs to be "0" as well.

[@599CD]

Thanks for sharing

[@jsingh7584]

great channel! I have a question. I have a form set up with the search box and a search command button. when the user types in the search box and clicks on the search button, it should bring back the record in the list box with a message saying X number of records found else no record. Please help

[@599CD]

Sounds like a job for DCount: 599cd.com/DCount

[@nickbroekhuizen8858]

🤣 I prefer human instructors too .. 😊

[@599CD]

thanks

[@Jojosmith342]

thumbs up to the BEST teacher as all time. Thanks Richard. Is there anyway to search a specific for the Form that displays no record when first opened? My DB is > 100,000 records. So when form first opened it is set to blank DoCmd.GoToRecord , , acNewRec. (display no records when first opened)