Search results

I have a form which uses a loop command to output reports as a PDF The reports take a bit of time to produce and the record set could contain 100-150 records. Does anyone know a way that you can split the recordset down into batches. Maybe have a button which creates 1-20 and another 21-40...

I have a access table which exports a PDF report using 'DoCmd.output' for each record in the recordset using a loop. The query the report is based on takes around 10-15 seconds to run due to some complex calculations in the query. I think this delay is effecting the loop command as it moves on...

I am using the following code but when i run it produces the following error. Run-time error '429': ActiveX component can't create object. then on debug it highlights the line Set objOutlook = CreateObject("Outlook.Application") I have searched online and already tried a suggestion to...

Hi am am really struggling with this piece of coding. I have an access form. It has -Two textboxes with client first and last name -Two textboxes with a contact 'email1' and 'email2' for the client -A combobox with a list of templates to use for the email. -A checkbox to include a copy of...