Thanks everyone for all your help with this. The reason it didn't work was a combination of not including an "Else" statement and placing the code in the wrong part of the procedure. We live and learn.
I know this thread is getting old now but I need some more help with the programme!
I tried to use the IsNumeric function followed by a msgbox to make sure the Price and Qty textboxes contain numbers only and it didn't like it at all!
'Checks textbox data for Price and Quantity are...
Thanks again for all your help Kulrom. Your code worked a treat.
I agree- the listbox method is far more effective in this instance and I'd definitely choose it over an array. Obviously I won't be submitting your code as it's not my creation, but I will probably modify it and use a similar...
I wasn't really expecting anyone to take it seriously- it's the first bit of code I've ever written... certainly not professional material! ;-)
The part that didn't work was the discounts. If you look at the attachment in the console, you can see that my array has the following...
Thank you very much for doing this. Much appreciated! I'll run it in a few hours when I get home. Just out of curiosity, did you find out why my array couldn't work out the discounts properly?
I've attached a jpg of my GUI plus the full code so far.
After clicking "Done" the DVD details are formatted and saved to the array (with the discount and subtotal). I had a quick look at the ListView control and I'd still prefer to use an array as it means I can store the data without...
Thanks Kulrom. If I used a ListView control could I still have contents as objects, the formulae for discounts in each row and the ability to save them in a .txt file in a grid format?
It it obvious why my array isn't working? I'm sure it's performing the discounts for previous rows instead...
I assumed an array was the best way to save textbox data in a table. That way, I could expand it and implement formulae within the last two columns. I'd then like to add up the subtotals and display them (along with the table) in a .txt file.
Is there a better way of doing this?
I've joined this forum in the hope that I can get some help with part of my code. It's very straightforward but I cannot seem to get the hang of arrays. I'm doing this as part of an electronic engineering course but I'm very new to programming and so my code is flaky...