Search results

I have a form that looks up various records the current funtion i use are like this Expr1: [bookingdate]=[Forms]![FindDelivery]![bydate] Or [Forms]![Finddelivery]![Bydate] Is Null How do i get to look up the month values i.e. if i select october i want to see records entered in october

I am trying to create a form to search records from a table the text boxes and combos will be: By Specific Date By Date Range By Customer By Order No By Invoice No By Month Any ideas on the simplist way of tackling this as i dont want to really create millions of queries if possible Many...

I have a form that shows me all invoice numbers that have not been invoiced and a command button to the right of the invoice number that prints the invoice but what i am trying to do is when i have printed the invoice for the given invoice this is then updated to Invoiced=Yes here are the...

I have a report for print invoices these are printed from a form so i can either print the invoice for a selected customer or print all invoices the problem is when i print for a selected customer the report is fine but when i print all, i am getting all records for every customer on one...

probably really simple but i need the code or a macro to print 2 copies of a report the report name is DetailedInvoice thanks all

Hi all, i am looking at changing my address fields with 1 list box the problem i think i am going to face is that these fields are automatically filled in from results from a query but i need the address to have a couple of blank fields for the house number any ideas

how do i do this

I have a form based on a query for jobs that have not been printed Can you add some sort of grouping to the form or query as at the minute the form looks like this please note that these all have a seprate job id and the only information from the query i want to see is this customer inv...

Hi there thanks for the reply, the problem i have is that i have never used modules could you explain where and how i use this thanks

hi there i have a report based on a query where all my records are printed based on where the invoice field = "no" then i have a button to print these i am trying to put a page number on the report so if there are 3 pages for a given customer it would be like 1of3 2of3 3of3 then the same...

thanks for your reply tried that and got totally confused with the whole setup as my orders are quite different as i do not have products etc.. any other sugestions this task i thought would be quite simple but this does not look like the case

Hi all i need urgently if any body can help with the following i have finally got my customers, invoice and invoice detail to communicate with each other ( finally ). but what i am trying to do is on my form i have the invoice as the header and the invoice detail subform below and i am using...

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