Recent content by doucet1963

Ridders, It works like a charm. Thank you

MarkK, I appreciate your reply but I need to record the result in the table because it affects other part of the database... Ridders, I cannot get it to work, I select all the checkboxes in the subform but the checkbox above named "CAPs_Received" does not change. I might be doing something...

I include a copy of the database that I am working with... The column "Received" has checkboxes that once all checked should check the one above named "CAPS_Received" At this time any checkbox will either add or remove the check in the box. If I can get it to work that would be good if not...

Thanks but this does not help me. The observations are entered all at once on the subform and none are added later. A filter lines them up by type, it seems complicated but in fact it is easy. An audit may create 16 observations, once a reply is received, the checkboxes on the subform is...

I have a main form that has a subform that contains checkboxes. I would like the checkbox "Caps_Received" on the main form be true only when the last checkbox "Received" on the subform is true. The Subform is a datasheet type with a column of checkboxes that belong to the same fields named...

The problem has been solved many thanks

Still one issue with generating email to specific person based on the report. The report opens based on a query that is filtered by sections. If I remove the filter from the query ([Forms]![Frm_DTAES_4-5_TAA_Assigned_Authority]![Cbo_Section]) then I can generate email, but it will be for the...

Ridders, I am new at this. The case code came from someone else, I can use "1" and I get the same result. Why is 16388 not good? You mentioned to use the record source for the report, I tried everything and I cannot get it to work. I tried the SQL = not working, The Query's name =...

I have this code that works except that it generates an email with everyone's name that are in the table. What I need, is to adapt the code so it would send an email to the names that are in the opened report using an action button. The code is: Private Sub Generate_Email_Click() Dim rst As...

Steve, The solution that you developed works great. Once I embedded the queries in the database and linked the fields to the report wow it makes wonder. This is exactly what I was looking for. Thanks.

Steve, Your understanding is good, I made a mistake in the excel for the first organization, sorry about it. I corrected it in this attachement. the Report should be able to provide the last audit date and the upcoming for an organization / sub-Organization. The audit type is not a...

the attached spreadsheet is made of fields that are required in the report, The first organization shows three audits, but the report should be able to capture the date of the last completed audit and the date of the next audit. the second organization shows two rows, one completed and one...

Thanks Steve. Tell me what I need and I will do it. Roughly, I have several organizations that is made of many sub-organizations. There always will be a forecasted audit for each sub-organization, and the completed date field will be updated once the task is completed. The report...

I have a report generated based on the query from a table named audit. In the table each row (audit) has a completed and a forecasted date. Before an audit is performed, the forecasted date will have a value but not the completed until the audit is completed. The problem that I have is that...

Sorry JHB for the time you spent on this but this is not really what I was looking for. The word "Good and Bad" in the textbox of an organization should have no impact on the formatting (example, Fuji, (Good)) because another table indicates the status. The conditional formatting must act based...