how to connect visual basic to the access

[blueberry]

hi,i have problem doing the front end and back end for my website...i have this contact us in my website and under contact us i have first name,last name,email,addr ess,contact number,feedback for customers to fill in...n bellow there is submit button...how to make sure that when people click that submit button the data can b sent to the back end(so that in the database can b updated)..n after they submit,we can show a confirmation like"thank you for contacting us"....

as for my track order,i have user id/email address and order id for customers to track their purchase...same thing,how to make sure once submit button is clicked,the status of the order can b shown out..?how to do for the back end part,so that we can edit the status or delete some of the things?just like any other website for track order.....

please provide the solution step by step...i do not really understand how it works...and i dont get some of the terms...thanks in advance....

[VijaySofist]

Hai bluebery!

We can connect access to VB in 2 methods.

1 is by using DAO and
another is by using ADO

Here I give the steps for connecting the DAO to VB

1. Create a New VB Project.
2. Select Add-Ins menu--> Click Visual Data Manager.
(Now a Screen Named VisData will Appear)
3. In the VisData Screen, Select New Menu--->Microsoft Access---->Version 7.0 MDB
(Now Save Dialog Box will Appear)
8. In the Save Dialog Box, Type a Name for the Database.

(Now a Database will be Created and a Database window will be shown)

9.In that Database window, Right Click Mouse and click New Table menu
(Now a Table Structure Screen will be displayed)

10. In that window, Type a Name for the Table.
11. By clicking Add Field you can add new field to the table.
12. After you have added fields to the table. Click Build the Table Button.
(Now a table will be created as per the details you had given)
13. Now Select Utility menu--> Data Form Designer
(Now the Data Form Designer screen will be displayed)
14. In that screen give a name to the form you want to create and select a Record source.
15. Now you will find the fields you have created in the available fields list.
16. Include all the Fields to the Included List.
17. Now Click Build the Form Button.
18. Now you will find the form included with the basic functionalities .
19. Run the form & Study the code well.
20. Now you can make alterations as you need.

Bye............ ....
By Vijay

[rkmalbz]

Hai bluebery!

We can connect access to VB in 2 methods.

1 is by using DAO and
another is by using ADO

Here I give the steps for connecting the DAO to VB

1. Create a New VB Project.
2. Select Add-Ins menu--> Click Visual Data Manager.
(Now a Screen Named VisData will Appear)
3. In the VisData Screen, Select New Menu--->Microsoft Access---->Version 7.0 MDB
(Now Save Dialog Box will Appear)
8. In the Save Dialog Box, Type a Name for the Database.

(Now a Database will be Created and a Database window will be shown)

9.In that Database window, Right Click Mouse and click New Table menu
(Now a Table Structure Screen will be displayed)

10. In that window, Type a Name for the Table.
11. By clicking Add Field you can add new field to the table.
12. After you have added fields to the table. Click Build the Table Button.
(Now a table will be created as per the details you had given)
13. Now Select Utility menu--> Data Form Designer
(Now the Data Form Designer screen will be displayed)
14. In that screen give a name to the form you want to create and select a Record source.
15. Now you will find the fields you have created in the available fields list.
16. Include all the Fields to the Included List.
17. Now Click Build the Form Button.
18. Now you will find the form included with the basic functionalities .
19. Run the form & Study the code well.
20. Now you can make alterations as you need.

Bye............ ....
By Vijay

----------------------------------------------------------------------------------------------------------------
what about using ADO??and what if we will not use the datacontrol only codes...please help me...the basic one...please no user define codes or the other thing..