Search results

I have a form with a due date. I would like to change the color of the text from black to red if the due date falls behind the current date by 1 day. Is this possible?

I have a form with 4 text boxes. [frmPM] StartDate - CS Bound to query from tblPM MaxOfCompletionDate - CS Bound to query from tblPMTaskCompletion DueDate - CS =DateAdd("d",[txtCount],[StartDate]) txtCount What i am trying to achieve, If StartDate has a date entered into it the DueDate will...

I got it figured out. I just assigned a query to subfrmPMTasks to include the completion column from tblPMCompletions and used the group by max and assigned that to the unbound text box.

I input the following into the control source of the CompletionDate text box =DMax("completiondate","tblpmTaskCompletions") which displayed the value just fine. But it showed the same date for every record. How do I fix this?

Would this be the header/footer of the sub form the completion date is currently present in?. I need to display it in another forms sub form.

I have a form with a continuous subform. frmPM w/ subfrmPMTasks. When i click on the task description it opens up another form with a continuous subform. frmPMTaskDetails w/ subfrmPMTaskCompletions. I would like to display the last "Completion Date" entered from subfrmPMTaskCompletions in...

This was my problem. Thanks.

Thank you both for your input. It is very helpful. So I have created a query for my form that displays the [task] and [startdate]. I also included a [count] field from my frequency column. I made another text box on my form titled [Due Date]. I then used the following control...

Ok so I took your advice on not storing the due date. How would I go about having the count table add the correct amount of days/months to the start date/last complete date in a form. I made a form that shows the completion date using a query as well as start date and a due date field.

I have a basic maintenance schedule that i am trying to put together and i have a problem. I have 3 Tables as seen in the relationships below [tblPMTask],[tblPMFrequency],[tblPMTaskCompletion] I am trying to get the due date to populate with a date calculated by the [StartDate] + the amount...

Perfect Thanks.

I have a form with a autonumber field named [WorkOrderID]. I have a button that when clicked generates a report based on the form then auto emails it with the title "New Work Order". I am trying to get the title to concatenate the "New Work Order" with the current [WorkOrderID] and put them...

Got it, thanks.

So I removed the end sub and now it triggers the event, but it still triggers after the msgbox has notified the user. How would I get it to not send the email unless the boxes were complete?

Hello, So i have designed a work order request form that a user fills in. When the user clicks submit to submit the report generated the form checks to make sure the text boxes have values/data in them. If it doesn't it prompts the user with a message box. When all boxes are complete and the...

I have a work order system that has a WorkOrderID as PK in tblWorkOrderNew. I have a field within tblWorkOrderNew named CompletionDate. I use a query to filter and display only the records that have an is null value in the date field. How would i display the "Amount" of is null records that are...

Hello, I have a form that has some check boxes on that when selected, email a report to them. Is it possible to another another check box at the bottom of the list the says something like "Email address not on list" and when selected it will open another form where i can enter and email address...

So i have been doing a bit of research into class modules but i just can't seem to wrap my tiny brain around it. I have a form with a combo box. cboPermitType. There a 3 options in the combo A1 B2 C3 I found the following code online which i am tying to incorporate into my form which allows...

Ok so I have 3 combo boxes cboPlant cboEquipmentType cboEquipmentName All 3 come from different tables and have their own unique PK I'm using the following following query This is my form. When I filter the last combo box it will not record the data into my table and...

When I tried this is doesn't filter the records to the WO#. It allows me to assign he same Permit to another WO#