Search results

still no joy

do i put this in the query or form tried both but does'nt seem to work syntax error (missing operator) in query expression

hi there is there a way of getting the dmax invoice number for a customer selected so if i select a customer on a form these results would give me the highest invoice number for that given customer where the invoiced field is "no" here are the fields from the table customer date invoice...

Thanks Would it also be possible to send me a small sample of your database of your so i can see how yours works as i think it is a simular sort of thing i need to do thanks simon

what is the VBA code you use

Hi there yes this is the way i would like to do it: use a query to raise a customers orders where the the invoiced field, which is a yes/no ( invoiced )= No i Know how to use the dmax function but how do i assign the invoice number to that order thanks simon

Hi Rabbie, This is the same thing that we do can you eliviate on this at moment i have something like this, we do not use products it is a service we supply and varies a great deal on day to day [invoice table] InvoiceId InvoiceNo InvoiceDate CustomerID TotalInvoice [OrderTable] JobId...

Hi there, i have a sample database to hopefully give you an idea what i am trying to get at: The sample attached is in various access formats: i am after, when i open the form for it to allocate and invoice number so when i select customerID this will show any records already entered along...

I knew something was wrong but can you explain a bit more as i am still learning i have attached a bit of the database i use to give you some idea thanks

Right here goes, I have now got rid of my old database as we did not have any relationships etc in place so information and data entry was a bit of a nightmare so i am starting a fresh new one and would like any help. I am quite new to relaionship and codes etc... Right! We have various...

i have a table which have all of the UK Postcodes in it PostcodeID, Postcode,Street, Town, County. What i am trying to do is after i have enter a postcode in a form field is for it to look for the results in th postcode table I know i can use a query but this would mean creating about 6...

I have a query that brings up a selected amount of records so when i select a customer the query brings up the records for that customer then i have a field a the top of the query form called order that i want the value of this added to the Ref fields of the query so it would be like this...

dont know if this helps open delivery/details form enter delivery details for selected customer on a daily basis at the end of the month open form invoice this will then call all records not invoiced and allocate the invoice number to the records maybe by way of a command button thanks...

thanks for that. nearly there, what i need is that when i start up the delivery form there will be no records showing and when i select the customer from the combo box then the records for that customer will show in the subform any ideas thanks simon

hi all i wondering if somebody can help i have been trying to get this database up an running but can't get by this bit... i have attached a database so you may be able to see what i am trying to acheive. we enter deliveries for a number of customers on a daily basis then at the end of the...

sorry to be a pest but your the only person who seems to have a clue what i am trying to do: i think i am nearly there just a couple of things i have changed field names and relationship etc as you said and everything seems ok i just a bit confused at how to create the form where the...

but wont i get a new invoice no everytime i enter a delivery, i need 1 invoice number for say 15 deliveries which we invoice at the end of the month. i have now removed customer id in the invoices table. other than that do you think the database looks about right. thanks simon

it is quite simular to what i am trying to acheive but there is a few modules on the databse which i have not got a clue about thanks any other thought

can somebody tell me where i am going wrong i want to allocate an invoice number for multiple records in this database database sample attached which may give you some idea

i have uploaded file so could you please tell me where i am going wrong i still get 1 invoice per delivery thanks simon