Visual Basic Forum for Visual Basic Programmers VB

[amardeepsingh]

i want to create an database application using microsoft access and visual

basic
for phonebook i.e saving name and addresses of my friends
but i want to know how can i
- display the records from database in form of labels instead of displaying

in the text field

- most importantly i want that this application would work without requiring

access and visual basic to be installed on the computer.

in short i want to create an database application which can be run without

installing visual basic and access.

hows that possible.
plz help

[VB_Developer]

Hi,
You could do this, it's very simple.

-give a reference to ADO 2.8
- write code in your application to connect to a database and open the recordset.
-place some label controls on your form. then assign the field values to your label controls.
- like this.....for Example : lblName.Caption = RecordSet!FieldName (else...RecrodSet.Field("Name")...else....RecordSet(Index))
- this way you can assign values to all your label controls
- then place 2 buttons, as MoveNext and MovePrevious.
- In the click event of these 2 buttons you can write the code....as
RecordSet.MoveNext(On MoveNext Click)......RecordSet.MovePrevious (on MovePrevious Click)
- Once you finish your coding, you can create a EXE, going to the File Menu, create MyProj EXE
-Once the EXE is created you can create a package using Visual Studio, Packaging and Deployment wizard.
- when you create a package, It automatically takes the dependency files and the required Dlls and Files need to make the application run.
-then using the installation package you can install the application anywhere and run.

Hope, this will help you.

Thanks

Deepak