Loading

A Simple Add, Edit, Delete, and Search using VB and MSAccess

Submitted by: 
thisiswelch
Friday, July 3, 2009 - 14:48
Visitors have accessed this post 187502 times.


This is a sample program on how to Add, Edit, Delete, and Search entries in database using VB and MS Access. Hope my code help you.
NOTE: THIS PROGRAM USES OCX, YOU MUST INSTALL THE PROJECT COMPONENTS BEFORE RUNNING THE PROGRAM.



Download Code
Tags: 
visual basic
ms access
database
visualbasic
vb
thisiswelch
dbase
msaccess
add edit delete search
thisiswelch's picture

Article by thisiswelch

thisiswelch has submitted 7 source code / articles.

If you like this post, you can follow SourceCodester on Twitter.

Subscribe to SourceCodester feed via RSS or EMAIL to receive instant updates.

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.

FOR YOUR OWN SAFETY, PLEASE:

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.

Comments

Submitted by Anonymous on Fri, 07/03/2009 - 14:54

pano po yan sa datagrid... ma fix mo agad yung row height... sinubukan ko sa properties isa isa ala ko nakuha.....

Submitted by Anonymous on Wed, 07/08/2009 - 23:33

galing muh namang programme txong.. pd b pa tutor?? free lang huh.. hehehe

thisiswelch's picture

Submitted by thisiswelch on Thu, 07/09/2009 - 09:16

thanks. uu ba.

Submitted by maikarum on Mon, 07/05/2010 - 10:14

Project po kc nmin sa subject na Software Engineering na gumawa ng System Software...if there's anyone here kind enough to teach me and help me to do my project please with all my gratitude im begging you to teach me...pls pls pls...any idea is accepted as long as maintindihan ko po...im just a beginner po kc...thanks so much.

please email me at...mhike_strong@yahoo.com
waiting for positive response...

Submitted by Anonymous on Thu, 10/07/2010 - 00:59

what kind of system?

Submitted by maki on Wed, 09/05/2012 - 18:11

library system. pls help how to generate the call #?

Submitted by Anonymous on Thu, 07/16/2009 - 14:04

thanks for having it here.. it will really help us to make our system analysis and design project.. we decided to make a library system as our project.. any suggestion for an effective one?

..thanks poh..

Submitted by Anonymous on Wed, 07/29/2009 - 15:25

sir,

Whats this Installer all about? i did install it but i dont know what just happen?.. whats this installer that u asked me first to install before running the program of yours..

i'm planning or we are planning to copy and paste this program in our POS system. you think its posible??

im just wondering that i might get error coz it requires me to install something first..

pls help.. thanks..

admin's picture

Submitted by admin on Wed, 07/29/2009 - 17:38

I require to some newbie to setup the installer first before using the source code to avoid error on dependencies.

You can copy/paste the source code here to your program by any means.

Submitted by Anonymous on Thu, 07/30/2009 - 15:39

elow how can i used the billing system? i install the vb 6.0 but it still not working....
do i need the oldest version of vb before i can install the vb 6.0?

thank you.

Submitted by Anonymous on Fri, 08/07/2009 - 14:16

if u hv coding idea for antivieus
send me on gosai09@gmail.com
i write a antivirus project in vb6

Submitted by Anonymous on Sat, 08/15/2009 - 13:51

how the find in excel field iten (specific item)

Submitted by leigh.tinio on Thu, 09/03/2009 - 17:03

Paano kung ung id_info Text ang DataType..ngka error kc sa edit and delete program...help me nmn poh...

Submitted by Anonymous on Sat, 09/12/2009 - 02:24

how can i transfer database from vb.net to sql server dynamically without creating structure in sql server before hand.the structure would be created programatical in sql server when database is migrated from vb.net

admin's picture

Submitted by admin on Sun, 09/13/2009 - 12:05

You can use a Create Table syntax.

Submitted by Anonymous on Thu, 10/08/2009 - 10:42

hi, I 'am kind of newbe in Visual Basic , can you gave some example of working code that can keep the deleted data in database.

thanks lot.

Submitted by Anonymous on Thu, 09/24/2009 - 09:34

can we ask for that codes pls. we want know how to use it for our program. thank you.

Submitted by Anonymous on Thu, 10/01/2009 - 10:26

hi, do you know the codes for edit, delete in vb.net connecting sql server? amazing_alex08@yahoo.com

admin's picture

Submitted by admin on Thu, 10/01/2009 - 20:33

I have a lot of example on this on the Database Programming Made Easy tutorial. Kindly explore and study it.

Submitted by maikarum on Mon, 07/05/2010 - 10:13

Project po kc nmin sa subject na Software Engineering na gumawa ng System Software...if there's anyone here kind enough to teach me and help me to do my project please with all my gratitude im begging you to teach me...pls pls pls...any idea is accepted as long as maintindihan ko po...im just a beginner po kc...thanks so much.

please email me at...mhike_strong@yahoo.com
waiting for positive response...

Submitted by Anonymous on Sat, 10/03/2009 - 15:07

i need to send the score of my iq test into database?? how can i do that???
MsgBox("Your iq is " & iq) - after he run tat messagebox

pls.. send me code..tnx.. angel_8teen_coh@yahoo.com

Submitted by Anonymous on Tue, 10/20/2009 - 19:31

> ok na ok ung gnawa u na sample program on how to add, edit, delete, and search.

> ask q lng poh!!! pano q poh madadagdagan ung content sa loob ng program??? Kailangan madagdagan ng age, gender, birthday, birthplace, religion and civil status.

> matulungan u poh sna aq.

> need q reply u poh kng pwede sa thursday or friday.

> i know u r a good programmer.

> tnx. if u want post ur cell # so that I can contact u.

Submitted by Anonymous on Fri, 10/30/2009 - 10:10

pls wen you got a code about add, edit, delete,search and save pls cnd it in my email add:
hir is my email: rhonald_10@yahoo.com
thank.,.
hir is my number.,. 09087041724
pls cnd me asap wen you got your code

thank you.,.

Submitted by Anonymous on Fri, 11/06/2009 - 00:31

Dear Sir, Madam

First I would like to thank you and your team members to provide us a great way of learning about Computer Education system. And Secondly I am very impressed to visit to such a beautiful and useful site Perhaps I have ever not seen such knowledgeable site than other.

Thank You,
Your sincerely,
Muhammad Khalid

Submitted by Anonymous on Tue, 11/10/2009 - 11:44

good morning sir,

im trying to develop your code but i found
run time error '94'; invalid use of null during load.
i always encountered them when some records
in the database is incomplete or null.

can you pls help me with this?
thank you.
christian.

Submitted by Anonymous on Wed, 11/11/2009 - 18:47

all i can say is "ASTIG"

Submitted by Anonymous on Thu, 12/03/2009 - 13:44

Sir help me to create database using ms access with vb 6.0...Thanks...rply asap....Thanks

Submitted by Anonymous on Sat, 12/05/2009 - 15:02

really nice
thanks a lot
from usa

Submitted by Anonymous on Tue, 02/02/2010 - 11:09

I'm going to work out this codings for my final semester project...

Submitted by Anonymous on Wed, 02/17/2010 - 18:14

Can u give me the code through which i add some data from MS Access form to Database
i hav a table name category can u kindly tell me this

devote911's picture

Submitted by devote911 on Thu, 03/18/2010 - 08:55

thank you sir!

Submitted by Anonymous on Tue, 07/20/2010 - 16:08

ang guwapo mo

Submitted by Anonymous on Sun, 04/04/2010 - 18:53

BEST SITE FOR GETTING CODES & THE EXPERTS CONTACTS
PLEASE THE AUTHOUR MAY SEND MAIL AS REPLY THAT I CAN CONTACT NEXT TIME;
DEAR THANKS!
I AM 58 YEARS OLD RETIERED MSEB ENGINEER HAVING SOME KNOWLEDGE OF SOFTWARE NOW I AM INTERESTED IN VB CAN BE FOXPOROW CONNECT & CALL QUERY?
HOPE U MAY HELP
MY mail id
arihantkal@yahoo.co.in
name KALGONDA PATIL, KOLHAPUR
MAHARASHTRA CELL 9096995757
OKAY

Submitted by Anonymous on Mon, 04/26/2010 - 19:46

Q2 Write a program using ADO to add, edit and delete the records from employee table. Also apply required validations.

Submitted by Anonymous on Fri, 03/04/2011 - 14:42

sir ,what is the codes for edit,search and save??can you help me?thanks.send your answer to my email :sweetyflower143@yahoo.com
Hoping your answer soon..God bless!!

Submitted by Anonymous on Wed, 04/27/2011 - 00:17

dear sir/madam
m having difficulties in connecting my ms access 2007 and vb 6, have tried to use adodb connection and adodb recordset but it giving me an error message " user defined type not defined" highlighting the adodb connection. what can i do?

Submitted by Anonymous on Thu, 04/12/2012 - 03:24

i want to learn anything that is related to computer would you like to help me if yes..!then send me lectures or codes..!

Submitted by Anonymous on Sat, 05/15/2010 - 22:12

good evening sir,
how to create connection between vb6.0 and ms access through coding without using adodc control and data control.

Submitted by Anonymous on Thu, 06/02/2011 - 14:46

good evening sir,
how to create connection between vb6.0 and ms access through coding without using adodc control and data control

Submitted by Anonymous on Tue, 06/01/2010 - 17:03

i want 2 update records in a database using textbox,combobox and list box

Submitted by Trixx on Fri, 06/04/2010 - 08:18

Paano po tanggalin ung ID column sa listview1 or palitan po ng DATE ung ID column? Panu din po mg-search ng item sa listview1? tnx po

Submitted by Trixx on Fri, 06/04/2010 - 08:21

Paano po tanggalin ung ID column sa listview1 or palitan po ng DATE ung ID column? Panu din po mg-search ng item sa listview1? tnx po

thisiswelch's picture

Submitted by thisiswelch on Sun, 06/06/2010 - 19:51

you can remove the id by deleting it on the listview (right click on the listview, click properties, click Column Headers tab, select the column you want to delete then click Remove Column)

Submitted by Trixx on Mon, 06/07/2010 - 08:08

Tnx po.. I want to remove the id sa code at paano po dadagdagan ng item(s) sa pamamagitan ng code. Paano po gumawa ng search code pra po sa project? tnx po ulit...

Submitted by Anonymous on Wed, 06/16/2010 - 23:45

hello! sir send me a code add,delete,search,save,etc tnx a lot

Submitted by Anonymous on Sun, 10/17/2010 - 10:42

pls give me code for search sir.

Submitted by Anonymous on Sun, 10/17/2010 - 10:52

search code can u give me or help me to find the code 4 search..sir

Submitted by Anonymous on Mon, 08/22/2011 - 13:35

i would like to have a simple add, edit, delete and search with vb.net 2008 using msaccess as my database.... how to connect the db to the form and how to manipulate data there like adding, editing, deleting and searching? please send me a feedback to my e-mail account.... i hope you help me here

regards,
phreanz_44@bigstring.com

Submitted by Anonymous on Mon, 06/14/2010 - 15:26

when i delete data in gridview that one message come ask to "do you want to delete record" after giving yes data with delete in gridview plz sent it argent \ thanks

Submitted by Anonymous on Wed, 06/16/2010 - 23:47

helow sir i nid codes tnx add, delete, search , save, send me d codes tnx a lot hahah...e2 email q kervin_garcia@ymail.com tnx tnx

Pages

Add new comment

More information about text formats

Filtered HTML

  • You may insert videos with [video:URL]
  • 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.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.