Loading

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

Submitted by: 
Visitors have accessed this post 256496 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.




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

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

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

thisiswelch's picture

thanks. uu ba.

Best Regards,
Welch Regime Marcellana
Email: [email protected]
Website: http://thisiswelch.hostei.com

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...[email protected]
waiting for positive response...

what kind of system?

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

mark baladad

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..

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

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.

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.

if u hv coding idea for antivieus
send me on [email protected]
i write a antivirus project in vb6

how the find in excel field iten (specific item)

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

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

You can use a Create Table syntax.

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.

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

hi, do you know the codes for edit, delete in vb.net connecting sql server? [email protected]

admin's picture

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

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...[email protected]
waiting for positive response...

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.. [email protected]

> 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.

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

thank you.,.

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

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.

all i can say is "ASTIG"

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

really nice
thanks a lot
from usa

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

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

thank you sir!

ang guwapo mo

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
[email protected]
name KALGONDA PATIL, KOLHAPUR
MAHARASHTRA CELL 9096995757
OKAY

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

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

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?

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

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

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

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

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

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

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)

Best Regards,
Welch Regime Marcellana
Email: [email protected]
Website: http://thisiswelch.hostei.com

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...

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

pls give me code for search sir.

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

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,
[email protected]

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

helow sir i nid codes tnx add, delete, search , save, send me d codes tnx a lot hahah...e2 email q [email protected] tnx tnx

Pages

Add new comment

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.
  • Lines and paragraphs break automatically.