Help with VB/Access DB

[saladbarkid]

Hi guys,

I would like to create a VB6 program that can keep track of info on customers, and orders in databases. It would have around 5 buttons.

1) view 'customer info' in database (Access 2002)

2) 'add customer' to db

3) 'delete customer' from db

or combine 2 and 3 for 'edit customers' in db

4) 'search for customer' in db

5) button that would take needed info from single customer in db and 'paste' it onto a receipt form to be printed out.


I have Visual Studio 6.0 and Access 2002 - should I use Access or SQL? (Which I don't know how to use!)

I havn't programmed in quite a long time and I'm trying to get my feet wet (again), so any and all help would be greatly appreciated, thanks in advance.

[DocEvi1]

SQL or Access? I guess at your level they are the same thing....Access is just a GUI for SQL and brings together a few other things.

For what you are doing, use Access. The system would be far to complicated otherwise.

Stefan

[saladbarkid]

Okay, how would I go about doing that?:confused: I don't even know where to start with code.

[theory53]

you first need to create your database with appropriate fields and/or a macro for the search.

then you in VB you are going to need to create your interface(forms and action buttons).

you will need to create your functions

view = READ function
add = WRITE function
delete = DELETE function
Search = Search function (or) reference database search macro


i work more so with web-based interfaces, so i am hesitant to give you any example code for it may mislead you.

work with this and post any questions you may have along with current code.

[DocEvi1]

wizards.

Stefan