C
clive750
Guest
Please can you help.
I have designed a User Interface on a form, that looks like an Invoice, for a tyre Company, where the customers number is entered and the other relevant details are recalled and placed on the screen, then other information is entered like:date settled, is the invoice settled, how much is owing, location, vehicle type, order number, quantity and the price...........then on the click of a button the total is calculated....this is quite easy stuff and it all works lovely, recalling invoices and input no problem, but the real problem comes when we want to print more than one invoice, because there are 1500 invoices so far, starting at 9030, to print a range I type in from say 10000 to 10002, when I click enter the whole computer freezes every time and have to reboot, but if i want to just print a single invoice ( this will be the invoice on display) then this is ok but very impractical as this database is suppose to save time, and the user will have to print off about 30 to 50 separate invoice at one sitting, I'm sorry that I'm not really sure about the code as this database was built purely on the GUI and with the wizards, if you need to see any of the forms, table etc I will be only too pleased to send some over for you to inspect. Also sorry if I've missed out any vital info, have sent you 2 parts of the invoice to give you an idea of what things look like.
I think this maybe because there is only one set of invoive details visible at any one time, not realy sure how to get around this.
I have designed a User Interface on a form, that looks like an Invoice, for a tyre Company, where the customers number is entered and the other relevant details are recalled and placed on the screen, then other information is entered like:date settled, is the invoice settled, how much is owing, location, vehicle type, order number, quantity and the price...........then on the click of a button the total is calculated....this is quite easy stuff and it all works lovely, recalling invoices and input no problem, but the real problem comes when we want to print more than one invoice, because there are 1500 invoices so far, starting at 9030, to print a range I type in from say 10000 to 10002, when I click enter the whole computer freezes every time and have to reboot, but if i want to just print a single invoice ( this will be the invoice on display) then this is ok but very impractical as this database is suppose to save time, and the user will have to print off about 30 to 50 separate invoice at one sitting, I'm sorry that I'm not really sure about the code as this database was built purely on the GUI and with the wizards, if you need to see any of the forms, table etc I will be only too pleased to send some over for you to inspect. Also sorry if I've missed out any vital info, have sent you 2 parts of the invoice to give you an idea of what things look like.
I think this maybe because there is only one set of invoive details visible at any one time, not realy sure how to get around this.
