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.
Пікірлер: 29
@shadyengineer19885 жыл бұрын
So glad to see this tutorial after 9 years. Thanks a lot.
@599CD3 жыл бұрын
My pleasure
@599CD12 жыл бұрын
Glad you were able to figure it out on your own. Isn't that the BEST feeling? :)
@HellYeah22311 жыл бұрын
Thank you Sir! I'm now able to populate tables directly from unbound forms, thanks to your recordset tutorial :-)
@599CD15 жыл бұрын
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.
@cyphi112 жыл бұрын
Good video. You clearly know what you're doing.
@Ahmadkhanize14 жыл бұрын
Gentleman ..I do not know how to say thank you ...You have a great job..God Bless..Thanks a lot
@vb6programming17010 жыл бұрын
Good guide to Visual Basic programming in Access
@599CD Жыл бұрын
thanks
@ets2playerbr13 жыл бұрын
Good work. I also have recorded some videos about Access/VBA. I uploaded my last creation to youtube yesterday.
@simoncross58328 жыл бұрын
Nice tutorial, well explained with simple example - well done!
@599CD2 жыл бұрын
Thanks
@sonicclang12 жыл бұрын
This worked great. One question, how do I go the opposite way and delete items that I select from a list?
@599CD12 жыл бұрын
Thanks!
@HellYeah22311 жыл бұрын
Thanks this is a very good tutorial.
@Jazztpt15 жыл бұрын
Great stuff, thanks for posting.
@mustaphati2 жыл бұрын
How about edit recordset ? What change ? In your code if i want for exemple to change date absence for students selected in listbox?
@599CD2 жыл бұрын
599cd.com/ACD16
@599CD12 жыл бұрын
You don't need a Recordset for this. A simple DLOOKUP function will suffice. Look for my DLOOKUP video.
@maiki60fps12 жыл бұрын
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...
@speer14111 жыл бұрын
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;
@math26087912 жыл бұрын
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.
@melvinreyes59457 жыл бұрын
hi, it is possible change a recordset of a subform that is already opened?
@599CD3 жыл бұрын
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.
@math26087912 жыл бұрын
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.
@sonicclang12 жыл бұрын
I figured it out.
@ogirnoeld20118 жыл бұрын
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.
@599CD2 жыл бұрын
599cd.com/Relationships
@vago201313 жыл бұрын
This is very very interesting, thank you broo,. Could you please let me know how can me put one private" for a form.... autoexec