Search results

getting error on this line invMax = Nz(DMax("InvoiceNumber", "activeinvoices", "CustomerID = " & Me.CustomerID), 0) Runtime Error 2471 the expression you entered as a query parameter produced this error: "sim001" the sim001 is the account number

so should be like this if no max in query then use max from invoice table +1 thanks

the way our database works there will always be an invoice number

add +1 from max number in the invoice table?

sorry is this Me.Bookings_InvoiceNumber = DMax("invoicenumber","lookuplastinvoicenumber") then I am stuck from here

afterupdate event from combo box Me.Bookings_InvoiceNumber = DMax(lookuplastinvoicenumber, InvoiceNumber) which works fine then i need something like this if isnull (me.bookings_invoicenumber) then me.invoicedetails.invoicenumber = dmax ("invoicenumber","invoicedetails)+1 end if

Hi all, Right here goes, I have a combobox on my form that lookups data in a query which gives me the last invoice number for the selected customer on then form then enters this number into field on the form called "bookings.invoicenumber" and if there is no number in the query then this...

hi there, thanks for reply the reason we have it like that is that there will always be 4 address's involved INVOICE ADDRESS WAREHOUSE ADDRESS COLLECTION ADDRESS DELIVERY ADDRESS as me might collect from their supplier and deliver to one of their customers so will always have seperate...

hi all, was wondering if anybody can help with this and check that the database looks ok I have now adjusted the database slightly and was wondering if you could have a look and see if this is Ok. You will notice that the customers details are all contained in 1 table and this is fine the...

I have now adjusted the database slightly and was wondering if you could have a look and see if this is Ok. You will notice that the customers details are all contained in 1 table and this is fine the way are customers table works so do not need to have adjusted as this is how the old one was...

ok many thanks, i will play about with it a bit more simon

Hi all, First of all, I am fairly new to this and still learning day by day so please go easy on me and would prefer if anybody can help me this rather then quote "see this link" ( please note that there will be only 1 user and that is me ) First of all, i would like to explain a little about...