Recent content by Toby3

OK, many thanks!! Here's rarred up database as it is now (14MB) http://rapidshare.com/files/357982820/Tonys_Database.rar.html Update: Added this to VB code: strSQL = "SELECT DISTINCT tblCustomers.CustomerID," On Sent Invoices page it has 170 invoices sent which is perfect!!!! On printing...

OK, added an extra bit to the WHERE line to include the only print ticked Inv customer records. Now 2 hiccups, first one I can fix which is length of designed invoice, some are going over two pages, no prob fixing that. 2nd and BIG problem is...e.g John gets lawn mowed 2nd Feb John pays 10th...

Soooooo sorry, but only one hiccup thats my fault. We went to print them out and it started churning out ALL customers an Invoice, I forgot to say that its only the customers that have Inv ticked in the Customer Information area, the control source = Inv?

Oh my gosh, cant wait to see it but just wanted to say thankyou sooooo much!!! I wasn't actually expecting you to do it, but then again....with the time it would have taken to walk me through it, it was possibly the faster option, lol. I shall go look now :)xxxx

Thankyou sooooooo much I thought I had compacted it to death, didnt think it could compact anymore, hehe. I could have however zipped it tho :( sorry about that Looking forward to your reply anxiously :)

Backend - http://rapidshare.com/files/357296250/Tonys_work_be.MDB.html Frontend- http://rapidshare.com/files/357297481/Tonys_work.MDB.html I would honestly be very very humbled and appreciative if someone could have a quick look????? The frmCustomer has the individual print invoice button I'm...

Thanks for your reply but it went right over my head, hehe Is there any possible way of sending it to you, via rapidshare or suchlike? Its only 30MB in size(backend and frontend collectively) I know this is a HUUUGE ask but Im in a real bind :( Needing to print off 200 invoices today.

Heya all, I'm needing help with trying to print multiple invoices in one hit of maybe a macro button? At present there is a button on a form where each customers monthly invoice can be printed (btnPrintReports). The fact that invoice has been printed (with details) also goes to a "Sent...

Yayyyyyyyyyyyyyyyyyyyy I luv you luuuung time stopher!!! knew I was using the wrong function before dangit!!! Sorry Galax but this was exactly what I was looking for, I wont be adding to it in the future on this form at least, but others probably!! Thanks so very much guys!!!

Hello all :) I have a very simple query that brings back a result of one $ figure. The queryname is "qryOutstandingBalance" There are only 3 lines filled Filed: Total Table: tblInvoices Total: Sum When query is run it brings back table with one column and one row, result is e.g $5782.00...