Recent content by russ0670

Worked Great Thanks.

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...

Sorry JHB, it may just be the result of the last 12 hours coding but I have no idea how to implement your Suggestion. Do I just put DoEvents MyRS.MoveNext No idea on the below. "Else can't you check if the file is created and if not wait until it is created? Do the check it in a loop and...

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...

SOLVED Kind of. Used the following code and works great. However does anyone know if there is a way to add dynamic text above the content of a .oft template in the email. e.g Set a greeting line based on the form data and then put this greeting line above the generic content from the...

SOLVED Found it was because Access was open as administrator and outlook was not. Set both to normal and fires perfectly. Also works if both set to open as administrator. go figure

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...