Microsoft Access Advanced Tutorial: RecordSets in VBA

This is an advanced Microsoft Access tutorial that will show you how to use RecordSets in Visual Basic (VBA) to access data stored in a table in your code.

[@shadyengineer1988]

So glad to see this tutorial after 9 years. Thanks a lot.

[@599CD]

My pleasure

[@599CD]

Glad you were able to figure it out on your own. Isn't that the BEST feeling? :)

[@HellYeah223]

Thank you Sir! I'm now able to populate tables directly from unbound forms, thanks to your recordset tutorial :-)

[@599CD]

This is an ADVANCED Access tutorial, which is what it says in the title. You really can't make this any easier for beginners. You need to start with basic lessons - see my Access 101 tutorial here on KZbin.

[@cyphi1]

Good video. You clearly know what you're doing.

[@Ahmadkhanize]

Gentleman ..I do not know how to say thank you ...You have a great job..God Bless..Thanks a lot

[@vb6programming170]

Good guide to Visual Basic programming in Access

[@599CD]

thanks

[@ets2playerbr]

Good work. I also have recorded some videos about Access/VBA. I uploaded my last creation to youtube yesterday.

[@simoncross5832]

Nice tutorial, well explained with simple example - well done!

[@599CD]

Thanks

[@sonicclang]

This worked great. One question, how do I go the opposite way and delete items that I select from a list?

[@599CD]

Thanks!

[@HellYeah223]

Thanks this is a very good tutorial.

[@Jazztpt]

Great stuff, thanks for posting.

[@mustaphati]

How about edit recordset ? What change ? In your code if i want for exemple to change date absence for students selected in listbox?

[@599CD]

599cd.com/ACD16

[@599CD]

You don't need a Recordset for this. A simple DLOOKUP function will suffice. Look for my DLOOKUP video.

[@maiki60fps]

One thing I don't understand: Why even with 2010 version.. there is NO unicode support in VBA MS Access?!!! As a database program that handles with characters all day every day, I just don't get it. Unicode support should be there from "day one" on the same level as .NET has it. In order to handle file operations or string functions I have to call external code written in .NET Visual Basic...

[@speer141]

I have a database for the local gym They have te option to put in or remove items. When they do so, I'd like to put in th recordset, so it updates the current stock of the items But I don't know how;

[@math260879]

Interesting I have an urgent question: I want to use this code to compare the data fields of a given table as input to check there existence. with other words: the user should be able to enter data in inputbox. this data should be compared with MyField in MyTable. If the entry already exists in this field, should come a message: available. if not, then the message not available. can someone help me? I would be very grateful.

[@melvinreyes5945]

hi, it is possible change a recordset of a subform that is already opened?

[@599CD]

I'm very sorry for taking so long to reply to your comment. I wasn't very good at keeping up with the comments 4 years ago, but I've been trying to make an effort to get back to everyone. If you still need help with this problem, please feel free to submit your question on my web site at 599cd.com/TH.

[@math260879]

thanks very much for your answer. I´ve show your video. It´s interesting but how can I use this funtion to solve my problem? I just want to write a VBA code using this function. the user should Enter a value in a Inputbox, this value musst be cheked if it exists in MyField of my Table. If yes, the messagebox: exists. If not, messageBox: not exists. please help me.

[@sonicclang]

I figured it out.

[@ogirnoeld2011]

I need your help my friend. I have a form that I would like to code it for it to show me suggestions. I enter many records with the same customer name. Instead typing the customer name each time. Can I set up acces to autofill ? Excel does it but I have access database ,Help please :) blesses.

[@599CD]

599cd.com/Relationships

[@vago2013]

This is very very interesting, thank you broo,. Could you please let me know how can me put one private" for a form.... autoexec