Error 2501

[mike60smart]

Completely different filename out over at UA?

UtterAccess.com

www.utteraccess.com

FWIW OrderNo contains a slash which is NOT allowed in a filename. :-(

From post #11
C:\Quotes\02262024- Order No -1/2024.pdf

Hi Gasman
Doug over at Utter Access highlighted the same issue as yourself.

How I didn't remember that no symbols in filenames is beyond me.

Many thanks

 

[June7]

Consider the order of commands. Do you want to send filtered report? Do you want to save filtered report?

DoCmd.OpenReport
DoCmd.OutputTo
DoCmd.SendObject

 

[mike60smart]

Consider the order of commands. Do you want to send filtered report? Do you want to save filtered report?

DoCmd.OpenReport
DoCmd.OutputTo
DoCmd.SendObject

Hi June
The process now works after removing the Oblique Stroke from the Filename.

What I would like to happen is as follows:-

Opens Report in Print Preview for checking and Pause other actions for 10 seconds
Then displays EMail
Then makes a PDF copy of Report

 

[Gasman]

Seems this simple code over on UA fixed the issue??

110            DoCmd.OutputTo acOutputReport, strDocName, acFormatPDF, "c:\Quotes\" & Me.OrderNo & "_" & strDocName & ".pdf"

 

[mike60smart]

Seems this simple code over on UA fixed the issue??

110            DoCmd.OutputTo acOutputReport, strDocName, acFormatPDF, "c:\Quotes\" & Me.OrderNo & "_" & strDocName & ".pdf"

Hi Gasman

Yes Doug spotted what you had.

Much appreciated.

 

[mike60smart]

Many thanks everyone as the main issue is now solved.

Does anyone know how to pause the Event after the Report is displayed in Print Preview so the user
can double check the values are correct?

Once a check has been made after approx 10 seconds then generate the Email and send the PDF to file.

Any help appreciated.

 

[Isaac]

an someone point out where exactly I am going wrong with this one?

check out Tom's answer

 

[mike60smart]

check out Tom's answer

Hi Isaac

That specific element of the Code has been resolved.
Thanks anyway.

 

[June7]

May be able to pause code execution but likely it will 'lock up' Access and user will not be able to do anything such as scroll or zoom report to review it. Reports are not intended to be interactive. Data review should be done on form.

Review https://www.access-programmers.co.uk/forums/threads/vba-access-how-to-make-access-wait.167470/

 

[mike60smart]

May be able to pause code execution but likely it will 'lock up' Access and user will not be able to do anything such as scroll or zoom report to review it. Reports are not intended to be interactive. Data review should be done on form.

Review https://www.access-programmers.co.uk/forums/threads/vba-access-how-to-make-access-wait.167470/

Thanks June, if that is the case will not try to implement.