Search results

I am sorry if this is old hat but I am pulling my hair out on this. I hope it is something simple. I have a form; record source is Table "Invoices" The sub-form record source is the same. Using the wizzard, I created a combo box whose source was the table "Invoices" field called Law Firm. I...

Good point! I have now added the Form and the report

Here she is!

Windows XP

Thanks for going to all that trouble with the sample database. I have done everything you have mentioned but the report is still blank when one of the fields on the form is blank. Any other possible suggestions? I don't have a file compressor so cannot convert the query into Zip format so you...

There are three fields in total; a name field and the two date fields. If the name field is left blank but a date range is entered then the report brings up for the date range. If a name is entered and not a date range then all data is returned associated with that date. So far if a name is...

Yes that is right rainman89. So should it be something different?

I have tried the following: Criteria: Between [Forms]![Invoices]![Invoice date 1] And [Forms]![Invoices]![Invoice date 2] Or: Is Null But this does not work, it just returns blanks!

Thanks for coming back. I am sorry but the code was in the Criteria section and not field name. Any ideas on how I sort out the null value issue?

I am having trouble with some code I am using on a query. Part of the query comes from two fields in a form. The rest comes from a table. The query then populates a report. The code I have written works fine. The trouble starts when I try and enter in some code so that if some of the fields in...

I am trying to produce a report so that it groups figures greater than 50,000 and then over 100,000.

I have got the following code as an expression for a report: =Int(([Amount])/50000)*50000 & " - " & Int((([Amount])/50000)+1)*50000 How do I get it to pick figures greater than 50,000 and then figures greater than 100,000 plus?

I have created an invoice database. I have got various standard reports made up. I would like to be able users to create their own reports to their requirements. So for example create a report for invoices under their name. Ideally, this would be selected from a combo list from a form and/or a...

That's great that's done it. Thanks for you help.

Thanks for that. That is certainly what I want. However, as the Add New Invoice form is a pop up form, it stays on top, whilst the form showing the duplicated invoice is behind it. Is there perhaps some code to make the Add New Invoice close after I have hit the OK button on the warning box that...

I have a popup form called ADD NEW INVOICE that a user enters invoice data. This gets stored in the table INVOICES. Users can then view the invoices already entered in the form INVOICES. The first field in the popup form , INVOICE NUMBER, has a Before Update function that warns the user if an...

Run-time error I have put the same code in my database - obiously changing the filed names. When I test the database by entering in a number I know has already been enetrewd, it correctly tells me that the number has already entered. It does not take me to that record. Just typing this out, I...

I have the following code in the before update criteria of a text box. The database is for recording invoices and it is a safety device to obviously stop the user entering duplicate invoice material. Yet when any invoice number is entered the warning still comes up eventhough the invoive number...

Checking for repeat numbers I have a similar issue as illustrated in this topic. I have a text box called Invoice Number in a Data Entry form called add new invoice. This is stored in a table called Invoices. What I would like is when a user enters in an Invoice number, and that invoice has...

That's great thanks very much