I am trying to write a simple program for printing invoices for a video club.
I have 3 simple excel files
The first file keeps customer information, which has 3 columns of data: Phone, Name and Address
The second file has 2 columns of data including dvd# and dvd title
and the third file is a template of an invoice in excel, which I want to fill in the data and print it by designing a form containing some text boxes and a command button (to enter data into cells and print command).

I know how to update my cells from vb6 and get a print of invoice.
And at this time I don’t want to deal with the customer information part of this project.

But let’s say a customer comes and wants to rent two dvds.
I have 10 text boxes in my vb6 form, which I can enter dvd #s
(10 dvd is the maximum no. of dvds that customers can rent!)
After entering dvd #s I hit the command button 1 to enter these dvd #s
to my invoice in excel and I can handle this part.

But my problem is how can I show the dvd title related to the dvd numbers (stored in excel file) in my invoice?
Do you think this is a good idea to have my dvd information in an excel file at all?
Any suggestion,
Thank you.
`Ali

Hi Ali

Excel is not the best option to store the data. You can use Access for it (that's why thye are created for)

You can still do the same with Excel..

The scenario of displaying the title with the DVD number can be better handled by ComboBoxes than text boxes. You can use the change event of the combobox to display the titles.

Cheers
Shasur

http://www.vbadud.blogspot.com