Small database

[Molson]

I am trying to build a customer database with the fields detailed below in VB6

Record No FirstName Surname Amount(£)


I want to enter only ten customers into four 1-dimentional arrays.

I also want to be able save the details and be able to scroll through the file in order of data entry by clicking on ‘next’ and ‘previous’ buttons.

I do not require a high tech approach only an easy way to do this (however I require all the coding).

I am a new programmer and am stuck on how to do this

Hope someone can help

 

[coffeemonster]

It depends what you want to do with this database once you've created it. However if a database is all you want then there is no coding required. If you use a program called Microsoft Access, you should be easily able to create a database with all the required fields using the wizards.

However once you've created the database, what do you do with it? If you want to write an appliation in VB to enter and modify the data, that's not too difficult, but will require you to learn how databases work. I suggest looking for simple lessons on websites like

http://www.programmersheaven.com/

who can give simple lessons on how to do things like this

Have fun. happy learning ;-)

 

[daimaou]

Hi there. If you just need a simple database you can build it in MS Access and then if you want you can use the Visual data manager add-in on VB6. It won't allow you to do much, but it's as simple as it gets. Of course I don't know what exactly you are trying to do, but if you want an easy way to do that this should be it.

 

[Molson]

I know that I can use Access (which I'm not bad with) however this is part of an assignment from a college course on Visual Basic that I am doing and therefore need so help in the coding

 

[Beesknees]

If you just need the one table maybe Microsoft Excel would be an easier option, especially since it's only 10 rows a database would be a bit of overkill.

 

[Molson]

I know that I can use Access and understand about using Excel however the assignment I have requires me to use VB6 to pass the assignment (it's a visual basic course that I am doing)

Can anyone help me with the coding.