Search results

Good Afternoon, I am trying to sum a calculated control in a report footer but not having any luck. This is a quarterly report that calculates the insurance payable per month within the quarter based on a set percentage per invoice. Note, the insurance payable is not calculated per invoice but...

Good Morning, I would really appreciate assistance as I have been trying for over 2 weeks to get the relational combo boxes to work. I am trying to set up a Material Requisition DB. In the details section of the subform I tried to create a category combo box, which when a selection is made...

Hello, I have a database that I have been using for the past 2 years which from this week has started giving some trouble. In the main form there are different categories which before I would use the filter button on the ribbon to narrow searches within a category. However, from this week...

Hi, I am creating a drawing register database for a construction project and would like to see the latest revisions for each drawing. Right now I have a drawing with two revisions - revision C1 was issued March 3rd and revision C2 issued March 28th. In my query I changed the group by to Max...

Hello, I have a report that is based on a crosstab query which shows the deliveries of water tanks by year and month. The row headings are year and month, column headings are the different size water tanks and the value is the qty received. For this new year, I would like the 2022 deliveries...

Hello I have a report showing the dates various activities on a project occurred. We are installing water tanks so I have a date field named TankDate which is the date the tank (or tanks) are installed at a particular property. I also added a field named TotalTanks with the following formula...

I am experiencing some issues with my database and I'm not sure if it's the database or the Access program. One day a combo box or button will work and the next day they won't. Today I updated some customer information and when I went to print the report a field that previously had information...

Hi, I have a report which is based on a query that includes the following expression named "PreInstallationInspectionDate" (I know it's a long name) DLookUp("[PreInspectionDate]","tblWorkOrder","CandidateID=" & [CandidateID]) In the report, I would like the PreInstallationInspectionDate field...

Hi, I have created a form which includes a multi-selection combo box. Is it possible to show each selection on a different line in the field of the report as opposed to separated by a comma?

Hello, I need help with the below code. I am trying to name and save to PDF my Invoices without having to manually name them. The problem with the code is that it is saving ALL the invoices as one document when only need the current record/invoice saved. Here is the code: Dim FileName As...

Hello. I am creating an equipment maintenance schedule. I would input the date the equipment was last serviced and then input the suggested maintenance period in months e.g. 3, 6 or 12 months. I have added a simple formula that returns the next service date based on the maintenance period...

Good morning, I am trying to sum the amount after December 31, 2019 and a date selected on a form. I am not getting an error message, the result is just blank. =DSum("[Amount]","qryStatement2","[TransactionDate] > #31-12-19# and [TransactionDate]<#" & [txtLastStatement] & "# AND...

Good Morning, I changed an existing form to a tabbed form so I could add a second subform. This is causing an error when I first open the form which says "The expression On Current you entered as the event property setting produced the following error: Return without GoSub". The only On...

Good morning, I am using Dmax to create a unique sequential numbering in a form. I would like the first entry to start at 1, however it keeps starting at 0. I tried changing the default value in the table design to 1, but it keeps going back to zero. I put the below code in the forms Before...

Good Morning, I have a query that calculates the insurance on the sum of an invoice. I have two invoices - the first one consisted of 3 items totalling $75.00 (30+30+15); the second one was 1 item totalling $75.00. The insurance is 17.1%. For the first invoice the calculation returned a...

Hello, I have a client task sheet form with a combo box cboJobName that lists all the jobs for that specific client. I have the List Items Edit Form property set to frmClients (which includes the subform frmJobs). How can I open the frmClients to the Client whose task sheet I am working in...

Hello, I have two slightly annoying issues. I have a DLookup formula on my data sheet subform that is working, however, in the next blank record, that field has an #Error message which is a little irritating to see. But when I key in data the #Error goes away. Below is the formula...

Good evening, Using the DateDiff formula I have been calculating the total time worked. I need to round this formula to the nearest quarter of an hour. How can I amend my formula =DateDiff("n",[StartTime],[EndTime])/60 to achieve this? Thanks in advance for your response.

Another Subtotal Formula in Subform Problem (DateDiff Forumula) I have another sub-form subtotaling issue. I am entering work that is task based, time based or other. The below sub-total formula was working until I came to a record that had no time based work at all. The sub-total control...

Hi, I have an invoice form in which there are 3 categories of works - time based, task based and other. For task based, there is a Dlookup formula that looks up the program used and applies a rate to the work. The problem I am having is subtotalling the tasks in the forms footer, so I can see...