Search results

  1. D

    "Simple" array with formula

    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. Cheers again Jake
  2. D

    "Simple" array with formula

    Kulrom, 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...
  3. D

    "Simple" array with formula

    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...
  4. D

    "Simple" array with formula

    Hello again, 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...
  5. D

    "Simple" array with formula

    Kulrom, 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? Thanks again, Jake
  6. D

    "Simple" array with formula

    Hi, 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...
  7. D

    "Simple" array with formula

    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...
  8. D

    "Simple" array with formula

    Kulrom, 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? Jake
  9. D

    "Simple" array with formula

    Hi everyone, 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... I have...
Top Bottom