Search results

It works a million thanks to you bastanu and ebs17

is there a way that i can use criteria that excludes the Pdfs and only selects jpgs in this code DoCmd.OpenReport "ReportToPdf", acViewPreview, , criteria , acHidden DoCmd.OutputTo acReport, "ReportToPdf", "PDFFormat(*.pdf)", PathOfFile & NumDoc & "\" & NumDoc & "-" & Format(Now...

i tried it and it still adds an additional blank page to the second time maybe it's because it loops through the records and incules the pdf and generates it as a blank page

i scan paper documents (archive) and export to pdf , my problem is the pdf contains additional blank pages.

unfortunately it didn't fix it thank you arnelgp & ebs17 for your time and effort this is the file in case you want to modify it, if you fix it please send it to me.

there is no problem with report layout it adds the pdf file that is on the list as an additional blank page i need to find a way to baypass or exclude the pdf when the convertion process is working i guess the problem is here in this code: DoCmd.OpenReport "ReportToPdf", acViewPreview, , ...

i have a subform that has scanned images (jpg) and also converted pdfs like shown here when i click to convert again the second/third time i think it includes the pdfs in subform list and adds them as blank pages because when i have like 10 pdfs and one jpg in the list it exports a pdf...

the problem is not in the layout i think it includes the pdf in subform list and adds them as blank pages because when i have like 10 pdfs and one jpg in the list it exports a pdf containing jpg(image) and 10 additional blank pages(previously converted pdfs).

it works perfectly thank you very very much one last thing if you could help me with when i click to convert the second or third time the output pdf file contains a second blank page , i think because it adds the previously converted pdf this is the code DoCmd.OpenReport "ReportToPdf"...

i get an error here i tried everything Kill PathOfFile & NumDoc & "\" sFile i would appreciate if you take a look at the file and maybe help with problem.

it works great deleting the jpgs on the subform list but doesn't delete the images from the drive

thank you i did what you told me and i think it needs some kind of criteria in this line DoCmd.OpenReport "ReportToPdf", acViewPreview, , , acHidden or here If Me.OptionDeletePicAfterConvertPDF = -1 Then DoCmd.GoToControl "ImagesSubform" DoCmd.RunCommand acCmdSelectAllRecords...

i have this application that scans and attaches documents when i click convert to pdf button it exports the pdf file in the same directory with jpgs as shown in the image above and they appear in the subform list , but when i scan the second time and then click to convert to pdf the function...

hello my name is ramzi i'm from algeria i'm just starting out with access and like this answers provided from this forum. thank you