Share Your Source Code or Article

Do you have source code, articles, tutorials, web links, and books to share? You can write your own content here. You can even have your own blog.

Submit now...

Database Programming Made Easy

This tutorial will teach you step by step on how to connect and manipulate database. If you'd like to suggest a tutorial please write a comment at the bottom of this article.

Read more...

Hire Us to Do Your Work

Do you want a customized system? Do you want to setup your own website to do business? Then we are here to help you in your programming needs.

Read more...

Search

A Simple Add, Edit, Delete, and Search using VB and MSAccess
thisiswelch's picture
Level: Beginner
Language:

21549 reads



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.

0
Your rating: None

Download Code




Your Vote!

0
Your rating: None


Note

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.


Set Item = .Add(, ,

Set Item = .Add(, , RS!trans)
Item.SubItems(1) = RS!E
Item.SubItems(2) = RS!T
Item.SubItems(3) = RS!em
Item.SubItems(4) = RS!tm

Run-time error '3265':

item cannot be found in the collection corresponding to the requested name or ordinal.

please send any solution to my email sit_me@yahoo.com.ph

problem with creating database in vb.net

sir i have written a command in sql that is create database college.,but there was a error message that master cant create database ,access denied ,,,,,,,tell me step by step solution for this problem.

sakura's picture

codes for null values

..sir pwede mg.ask about sa codes for null values....f u have time email to bbder_08@yahoo.com...

...sakura...

i need help pleas

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

My command Button is not working please help me.

Private Sub cmdSearch_Click()
If Me.cmbSearch.Text = "" Or Me.txtSearch.Text = "" Then
MsgBox "All fields are required!", vbExclamation, "Error"
Exit Sub
End If

Select Case LCase(Me.cmbSearch.Text)
Case "Last Name"
SQL = "SELECT tbl_info.lastname, tbl_info.id_info, tbl_info.lastname, tbl_info.firstname, tbl_info.area, tbl_info.department, tbl_info.badge, tbl_info.cid, tbl_info.date_hire, tbl_info.date_resigned " & _
"From tbl_info WHERE (((tbl_info.lastname) Like '" & Me.txtSearch.Text & "%')) order by tbl_info.lastname asc;"
Unload Me
Call goSearch(SQL)

Case "Badge No"
SQL = "SELECT tbl_info.badge, tbl_info.id_info, tbl_info.lastname, tbl_info.firstname, tbl_info.area, tbl_info.department, tbl_info.badge, tbl_info.cid, tbl_info.date_hire, tbl_info.date_resigned " & _
"From tbl_info WHERE (((tbl_info.badge) Like '" & Me.txtSearch.Text & "%')) order by tbl_info.lastname asc;"
Unload Me
Call goSearch(SQL)
End Select

End Sub

helow sir nid codes tnx

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

delete in gridview

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

Help

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

remove id

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)

DISCUSS, BLOG, BE HEARD.
http://www.thesacrificiallamb.com

please send me a code in VB 6.0

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

ID

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

Help

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

update

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

help

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

BEST SITE FOR GETTING CODES

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

give answer

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

devote911's picture

ahha!

thank you sir!

yes

ang guwapo mo

Can u give me the code

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

Thanks

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

thanks for infor

really nice
thanks a lot
from usa

help

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

idol!!!

all i can say is "ASTIG"

with regards to add, edit, delete, search by MR. WELCH REGIME

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.

Database Programing with Ms Access

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

need help ......

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

eow po..

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

help

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

RE: vb.net, and sql server

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

admin's picture

re: RE: vb.net, and sql server

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

i need help pleas

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

how to add/edit/delete/save using vb

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

howcan i transfer database from vb.net to sql server dynamically

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

re: howcan i transfer database from vb.net to sql server...

You can use a Create Table syntax.

Problem with delete record ms acess database

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.

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

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

how to find

how the find in excel field iten (specific item)

annti viruse

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

billing system

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.

about the INSTALLER

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

re: about the INSTALLER

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.

ui..

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

galing

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

thisiswelch's picture

thanks. uu ba.

thanks. uu ba.

DISCUSS, BLOG, BE HEARD.
http://www.thesacrificiallamb.com

i need help please

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

help..

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

Post new comment

CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
Image CAPTCHA
Enter the characters shown in the image.

Step by Step Java Tutorial

In this tutorial you will learn how to program with Java. It has a rich of information to be educated well with Java.

Read more...

Do You Have Question?

Do you have any question related to computer programming? Visit our forum and post new topic on the category you like. Be gentle when asking a question.

Ask now...

Point of Sale

Point of Sale is very useful especially for supermarkets or restaurants. I have included a barcode scanner in this program. Please check it out.

Read more...