Search results

Hi Pat thanks for your help in this - so I didn't want a batch, as the main form linked to the subforms each need to be submitted as separate emails and reports as and when they happen as there is a second stage to the meeting which has another report populated with dates that gets sent to the...

Hi Pat, thanks for your suggestion - I completely agree with Date() that is a good call out that I hadn't thought of and something I will change throughout the database! So the process is that we will be on a call with someone, asking which services they require. We can tick the box or untick...

Hi thanks for the welcome. So, the continuous form can have anywhere between 1 and 30 records, some of which need to be sent to a different department, others may or may not be sent later. The tickbox would be me saying, this record should be part of an emailed report. The VBA then sends an...

Hey there, Thanks for coming back so quickly! In an ideal world yes - I would just have the date which would be the easiest solution, but the date will be locked and will only get populated after the part of the VBA script where the report has been emailed, which is our way of covering...

Hi All, This is my first time posting but I am having a little trouble with some code that I thought was pretty simple. I have a continuous form, that I am trying to update using a query. The form is for frmNavigation!frmSubform!frmContinuous. On the continuous form, there is a tick box to...