VB.NET Tutorial - Delete Records From a Microsoft Access Database

[@josemunozvargas]

Thank you very much for your videos. It is very difficult to find VB.Net videos.

[@nestorcosio7088]

Excellent tutorial ! appreciating their efforts in the tutorials greetings from Tijuana

[@starflight6836]

Bro, you are an absolute god Thank you

[@jerbyapa9229]

i just watch this from beginning tell end with thumbs up

[@shamanu67]

you are a very good trainer, thank you! I have only one little worry about (Focus) :) when you start, Delete User Menu is active, and will remove the first positions...

[@chuckswan5657]

Thank you so much for these very useful tutorials. How can I get copies of the code you create? While your instructions are quite clear, I could really use the code to refresh my knowledge when I'm trying this stuff myself.

[@bodylojohn]

Another great tutorial. Keep em comming. Do you also have a tutorial about saving data directly to a db from the datagridview? Thanks in advance!!

[@VBToolbox]

+Johnny Hermes (Bodylojohn) Thank you! I have done this, but haven't yet created a tutorial for it in MS Access due to the complexities of creating the UpdateCommand with OleDB. It was a bit frustrating getting it to work properly because it requires strong enforcement of data types. :-/

[@pw3111]

Excellent Series.Thanks. I've just finished the third in the series - deleting a record and while all the controls seem to work, the row I delete is still on the screen. The properties for the data base are still set to "copy if newer" as set in the first video. I've changed to "always copy" and its still the same problem. I've notice a few differences between your screen and mine that were on your screen in the 2nd in the series but not in the third series eg, Form1_load is in the 2nd series but not in the third. Any help would be appreciated.

[@Funtastic91]

YOU DA MAN !

[@ahmedsafiy3557]

thank u

[@ChristianHaugland74]

I made the NoError Function A little better and have it in a Module :) Also Made Two Error Function to ease the use of error msgboxes. Make a new module and copy this code into the new module, and now you can use it in your whole application. Parameters in NoErrors Function Text: The text to be checked Report: Show Error Message? True/False CheckFor: uses enum NoErrorStates and if Empty is selected then function use IsNullOrEmpty function, If Whitespace is selected then IsNullOrWhitespace function is used. Empty = 0 WhiteSpace = 1 if integers is used. Here is my code i use: '------------------------------------------------------- CODE BELOW ---------------------------------------------------- Public Enum NoErrorStates Empty = 0 WhiteSpace = 1 End Enum Public Function NoErrors(Text As String, Optional Report As Boolean = False, _ Optional CheckFor As NoErrorStates = NoErrorStates.Empty) As Boolean Select Case CheckFor Case NoErrorStates.Empty If Not String.IsNullOrEmpty(Text) Then If Report = True Then ShowDBError(Text) ' Report Errors Return False End If Case NoErrorStates.WhiteSpace If Not String.IsNullOrWhiteSpace(Text) Then If Report = True Then ShowDBError(Text) ' Report Errors Return False End If Case Else ShowError("Unknown NoErrorStates") Return False End Select Return True End Function Public Sub ShowDBError(text As String) MsgBox(text, MsgBoxStyle.Critical, "Database Error.") End Sub Public Sub ShowError(text As String) MsgBox(text, MsgBoxStyle.Critical, "Error.") End Sub

[@pw3111]

I've got a problem with the delete by dgvData_CellClick method. If I click off the actual values I get the following error message System.InvalidCastException: 'Conversion from type 'DBNull' to type 'String' is not valid.' I was under the impression that your " ' PREVENT OUT OF INDEX RANGE ERRORS If e.RowIndex < 0 Or e.ColumnIndex < 0 Then Exit Sub" would handle it but it doesn't seem to be. Any suggestions?

[@VBToolbox]

Hi, @pw3111! The index out of range prevention is only to handle errors when clicking to the far top or left where a negative index value was produced. The casting error you're seeing seems more related to the actual data in your dgv or database where it's trying to translate or do something with a NULL record from your table. Are you using this for another project or just copying the tutorial? It's a little tricky to troubleshoot without seeing the code and data and I'm a little rusty, but if it's a small project you could share, I can see if I can figure out the issue.

[@pw3111]

@@VBToolbox on my access data base, there is a blank row at the bottom with a * on the far left. This is where a new entry will go and is present on all Access databases I build. It’s when I Click into this row that the error occurs. On your “delete “ example program, there is no blank line at the bottom of your database so there is nothing to click into to cause the error. How did you accomplish this as all my databases have this empty bottom row? I can hide this bottom row by choosing “Addaddition=false” in the database properties but then I can’t enter a new record. Thanks for any help.

[@pw3111]

Problem solved!, On datagridview for my delete forms, I clicked on the top right hand corner of the datagridview and unchecked the “enable adding” option. I left it checked on the any forms where I wanted to add data. Once again your videos have been very educational and your replies have been very helpful as well as they point me in the right direction and make me think. Thanks.

[@VBToolbox]

@@pw3111 Hello! Sorry I wasn't able to get back earlier. That is great news that you were able to resolve the issue! Thank you for sharing the resolution. It may be helpful in the event that someone else encounters something similar. :-)

[@marcush5475]

Hello, Thanks for sharing this. Helps me out so much. I would like some more help, if I want to show the user the ID in a messagebox when they save a new user, how would I do that?

[@bolingchen6240]

great video.thank you for share this .

[@ZintomV1]

Hey nice video, I was wondering when your going to start up your other channel again, thanks, Tom.

[@robertbhandari7829]

Thank you sir.

[@camerensmith9729]

I am having an issue @ 31:04 where it is giving me the error Option Strict On disallows implicit conversions from 'Object" to 'String'. I believe this issue is the reason I am only able to delete through the combo box. Visual Studio recommends trying an explicit cast where I would SelectUser(CStr(dvgData.Item(1, e. RowIndex)).Value which does get rid of the error, but I still have a logical error where I can only select a record with the combo box.

[@yba3798]

thank you again!

[@amberm2035]

Thank you thank you ! :D

[@pw3111]

Problem fixed !!

[@ksmemon1]

Hi, How Can I Deal When I Have Created Function to Get Level And I am Using this Function During Save Data Sub for Example In Save Sub I Have Created Access. AddParam("@Level",GetLevel (Id)) And GetLevel Has Access. ExecQuery ("Select from Level From Accounts Where ID =1)

[@rysun87]

why does "ByVal" appears in every sub i created? For Example: Private Sub cmdFind_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdFind.Click SearchMembers(txtFind.Text) End Sub Please Help...

[@rowanbalana8578]

I have a question please answer.. Everything is working especially when i start the program and click anywhere then it will show on the label but once i click the find button and then return to normal and click anything it won't show on the label anymore

[@VBToolbox]

Hello, Kris. :-) I'm a little confused. Which part of the video are you referring to?

[@laptopDoctorKZN]

hi where is the video for adding users??

[@wim2561]

Those lesson were great they helped me a lot. But i find out that our teacher has some other goals now. (cry cry cry) I got only one question i cannot find a good way to work with stored procedure with in en output. Is it possible to explain that. Thanks in advance, and thank for your lesson. And my your new dreams come true.

[@VBToolbox]

Is the SP output a message or query results?

[@wim2561]

Thank for your answer. I am using SP for both but most are output. As it can be reports and also changes into the database. I have made one for testing but did do the scrip in VB. But, after lot of investing and reading, i have decide to take m project to C#. I wish you could help in that too. It is much harder than VB for me. But got results too. So the challenge is now to build my project in complet in C#. The reason for this decision is the chances of the roads which Microsoft will take in the near further. Thanks for all your effort. And hope to see you once more maybe as c#

[@rashidfaheem9838]

You deleted record whose id was 7 but all the other ids were same after deleting. Is it possible to delete any record and update all ids after that? like we delete record number 7 aur record number 8 should be at place of 7 aur record number 9 should b 8, something like that? is it possible?

[@terryh558]

I haven't watched that, but sounds like the ID is probably a primary key and you can't change those values. You delete one and that key is lost forever.

[@MrPokerGaming]

I'm 5 years late XD but u should use Auto number in your MS access data type