VB.net to MsAccess Listview (Insert, Update, Delete, Refresh and Search) No Autonumber datatype

Submitted by: 
Visitors have accessed this post 25589 times.

In this program you will learn on how to:

*Insert and Update with catch duplicate entry (EmployeeID) without using autonumber datatype...

*Delete multiple record by pressing Ctrl + Click...

*Pop-Up Refreshing with setting...

*Pop-Up Searching with setting...

Please don't forget to leave a comment >(^_^)<
hope this code will help you...

Godbless you all mga kababayan...

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.


1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.


.sir pwede po bng patulong f panu magjoin ang dalawang tble at idisplay sa listview gamit ang ms access?

I downloaded it but I didn't see anything.Can you suggest what i should do to see the file and learn from the tutorial

extract it using unzip or winrar

S0rry for that sir,,, try to rename in short filename and extract it using winrar or unzip..

pa turo naman po kung paano magdagdag ng mga info at mag work pa din ang system?
pls bro need lang po tlga salamat ng madami!


sir may error p0h b? "Unrecognized database f0rmat p0h b? kung gan0n p0h ung lumalabas na err0r palitan na lang p0h ng f0rmat ng access 2003 or 2007, 2010 p0h kc ung ginamit k0h jan w0rking dn p0h sir kahit 2003 or 2007

Hi Sir

that i am using visual basic 2010.
back end access 2003/2007/2010

i want vb.net 2010 code to solve the problem.

Can Any One help me please.

i have a table 1 with
Rollno Name class Demand Consesion Amtpaid Due
1 sreedhar ba 1000 0 0 0
2 ramesh ba 1000 0 0 0

table 3
Rollno Name class Amtpaid date
1 sreedhar ba 200 01-01-13
2 ramesh ba 300 01-01-13
1 sreedhar ba 200 05-01-13
2 ramesh ba 300 05-01-13
1 sreedhar ba 200 01-01-13
2 ramesh ba 300 01-01-13

Here is the problem:

I want to update table 1 field Amtpaid with sum of Amtpaid in table 2.

what is the update code

please any body can help

thanks in advance.

Dhaipule Sreedhara Rao Bunny

i dont know sir i make like your program but i didnt see file on the date in my listview how come may i ask u YM sir? helme :D

For Column Date = DataType is TEXT

How do I generate Auto numbers from my database to the text box field of the ID for the next record?

Sir on MsAccess look for the first field of the database, you need to change datatype like text into autonumber to Auto generate it like this 1 2 3 4 5 6 7 8 9 10

harvey harvz

Add new comment

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • You may insert videos with [video:URL]
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <th> <img> <h1> <h2> <h3> <iframe> [video]
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <html4strict>, <java>, <javascript>, <mysql>, <php>, <python>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.