Search results

Glad to be of assistance.

You have a couple of options 1. Create an UNION QUERY to join all the fields for the output. This involves copying the sql code 14 times and changing the field name. 2. Read the input table into an array and write the array to an output table where each column in the array is not null. I...

Here is an updated version using two queries. Open the report rpt_loan_balances. Query qry_loan_calcs calculates the total debits and credits, query qry_amount_owing calculates the current amount owing.

Here is an updated version I add a textbox called tot_to_pay and made the control source =[TotalToPay] for each entry in the report set the visible property to no. Set the running sum property of this text to Overall. In the footer changed the control source to =[tot_to_pay] this gave the last...

On the Got Focus of the combo box enter Docmd.requery "NAME" where name is the name of your combo box. Also make sure your combo box displays the correct list based on your selection in the part number.

Use the On Format or On Print Event of the report and set the value of the footer total. If you have problems post some sample data and report etc.

Change the the footer from =Sum([testcontrol]) to =sum([TotalToPay])

An updated version of your database is attached. I have added a text box to your Add Document Tab. Click on the three dots to the side of the text box to open the search window. After locating the file, highlight the file and the filename will be displayed in the text box. I have not changed...

No problem, just post again if you need help. Just a reminder do not take an average of averages as it is mathematically incorrect.

What I meant was upload some sample raw data from the table that you are using for your queries then I will be able to help you with your grouping. The sample data in your previous response only had one entry per name.

In the query used for your report select Totals. There will be a Totals row for each column.Use the Total row to Group By, Avg, Min and Max. You will need addiitonal columns to do your Min, Max. If you have problems upload some test data and your report so that I can give some assistance.

In the properties of the field go to the FORMAT tab and set the Decimal Places to 2.

Attached is an update version of your database with the following changes: 1. Changed the name of the Cutsomer Name textbox from text22 to customer_name as customer_name is a more meaningful name that text22. 2. Created an After Update event for your invoice combo box and added the follwoing...

On startup you could open the form as hidden, I use this method after an user logs in. This hidden form I call frm_utility stores details e.g. Employee Number etc. about the user that are used whilst the user is using the database. This saves using Dlookup each time and it also stores other...

You could try the After Update event and move the focus to another field or control. Using the On Change will trigger every time a character is entered in the field.

Just a tip, if you scroll down past the posting replies etc. you will come to a section called Similar Threads. These threads may not relate to your version of access but will point you in the right direction.

May I suggest you post any code with your question so that you will get a response to your problem without a general response.

Lookup DateDiff() in the help file.

I had trouble opening your Company form, an Invalid format error message was displayed. Anyway to solve your problem of updating you as you found out you cannot do it using a crosstab or a layout similar to your prices form. I used a previous copy of your database and made the follwoing...

If you type in Docmd. the list will be displayed but as soon as you enter a space the list will disappear. This will be same for other drop downs if you enter a space.