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

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

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

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

I have created the following formula in the Control Source field of a text box using the Expression Builder: = IIF([GRT]<= 500, "333,000")IIF([GRT]>500,333000+(2500*500)+ (([GRT]-3000)*333)) What I am trying to say is that if the field [GRT]'s value is between 1-500 then the default value is...

I have created a form in order to add data to an existing form. It has the same fields. It is just formatted slightly differently to make data entry easier. So ideally on the existing form I push a button saying "add new company", it opens up the new form with blank fields, data is then entered...

I am trying to run a IF, THEN expression. What I have created is : Private Sub Form_Open(Cancel As Integer) If Me!Type = "Workboat" Then Me!DWT.Visible = False End This works fine but where the TYPE field is enetred as another category other than workboat, the DWT field is still missing. Am...

I have a sub-form in a form that displays data that relates to the data in the single form. What I would like to do is double click on that record in the form which then opens a form that displays more of same data in the sub-form. I have created the double click action that opens a form, but...