Reports :: Save Report As PDF - Output To Action Cancelled With Access VB Macro

Jan 12, 2015

One of the users of my application, reports an error when saving a report to pdf by VBA code. She’s using Access 2013, on Windows 8.1.

The error is “error 2501 output to action was cancelled with access vb macro”

The VBA code is

StrReport = “RepInvoice”
StrDocumentName = “C:UsersMaryDocumentsAccessInvoice.pdf”
DoCmd.OpenReport StrReport, acViewPreview
DoCmd.OutputTo acOutputReport, StrReport, "PDFFormat(*.pdf)", StrDocumentName, False
DoCmd.Close acReport, StrReport, acSaveNo

This error occurs at the OutputTo line. This code is part of an user form with a button “save as PDF”.
When this code is run, the report is visible as an example (as meant to be) on the screen. The code stops at the OutputTo line.

When I use
DoCmd.OutputTo acOutputReport, StrReport, acFormatPDF, StrDocumentName,, False
the problem still exists.

I tried to save the report manually by Preview > Export > PDF. The preview is OK, saving as PDF results in the same error 2501. This may lead to the conclusion that this problem is not caused by the VBA code.

I verified whether user write rights are OK, and whether a default printer is available. Both are OK. The report consists of 1 page.
When this very same application is used with Access 2010, everything functions as expected.

View Replies


ADVERTISEMENT

Modules & VBA :: Output To PDF - On Click Action Cancelled

Jul 10, 2015

I have a button on-click action of:

Code:
DoCmd.OutputTo acOutputReport, "Bladereport", "PDFFormat(*.pdf)", , True, "", , acExportQualityPrint

It works perfectly with the box appearing to choose the directory and file name, having done this it then outputs perfectly.

However if you choose cancel at the file and directory selector box it crashes:

Run-time error '2501':
The OutputTo action was cancelled.

View 1 Replies View Related

Print Out Macro Action - Prompt To Save As

Sep 21, 2011

Why when I set up a macro with a PrintOut action does it always prompt me to "Save As" before it prints? I have a default printer set up in the system, but it still asks to "Save As." It does print after.

View 1 Replies View Related

The OpenForm Action Was Cancelled

Aug 23, 2005

I am trying to open a form with a specified record using double clicked event (list box) but access is throwin "The OpenForm action was cancelled". My code is:

Private Sub lstSchool_DblClick(Cancel As Integer)
Dim test As String
Dim thisForm As String

thisForm = "frmRegister"
test = "ID = " & "'" & lstSchool & "'"

DoCmd.OpenForm thisForm, , , test

End Sub

ID is a AutoNumber field. I have used this code in my other dbz and it works fine ....

View 12 Replies View Related

Create Macro Save Report As PDF

Sep 17, 2011

I want to be able to have a report automatically generate at the beginning of each month and save it as a PDF file and have that report saved to my access database.

View 3 Replies View Related

Reports :: Open Report Action Was Canceled Popup

Nov 10, 2014

I use the following code in the On No Data event of a report:

Private Sub Report_NoData(Cancel As Integer)
MsgBox "No data exists for the date range entered.", vbInformation, "No Data Alert"
Cancel = True
End Sub

This works fine to cancel the opening of the report however Ms Access annoyingly then pop-ups another alert that reads as follows:

"The OpenReport action was cancelled". There is no error number.

I've tried putting in a DoCmd.Close after Cancel = True however this doesn't do the job.

Any way to prevent the Ms Access pop-up from appearing?

View 4 Replies View Related

Trapping "The DoMenuItem Action Was Cancelled" On No To Delete Record

Jun 7, 2006

:confused: Anyone know how to trap/prevent the msg "The DoMenuItem action was cancelled" after answering no to deleting a record? I followed the instructions at the following thread but no luck:

http://www.access-programmers.co.uk/forums/showthread.php?t=53206&highlight=DoMenuItem+action+cancelled

Here's the code:

----------------------------------
Private Sub Delete_Click()
On Error GoTo Err_Delete_Click
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70
Exit_Delete_Click:
Exit Sub
Err_Delete_Click:
MsgBox Err.Description
Resume Exit_Delete_Click
End Sub

-----------------------------------
Private Sub Form_Delete(Cancel As Integer)
DoCmd.SetWarnings False
If MsgBox("Are you sure you want to delete this record?", vbYesNo) = vbNo Then
Cancel = True
Else
MsgBox "Record deleted!"
End If
End Sub
-------------------------------------

Thanks in advance.

View 2 Replies View Related

Reports :: Output A Report To Multiple PDFs

Feb 6, 2015

I have several reports that creates price sheets for all of my customers. It is a report with multiple subreports within, and I am trying to create a process to seperate them and export them all into [Customer Name].pdf. I have tried to scrap some code together from various forums, and it has been unsuccessful.

For example, one of the reports "rptPriceSheetQuarterly", has a field "txtCustomerName", that feeds the queries for the other subreports. I would like to create a new PDF when that field changes.

I understand I need some sort of looping code that will cut the report up dump them all into one folder, but I am totally out of my element here.

View 14 Replies View Related

Reports :: Output Access Reports As JPG To Display In Pictures Screen Saver

Sep 2, 2013

I have been tasked with creating a database to log employee suggestions and then automatically present reports around the site. I have developed the database and it works OK and can output *.PDF reports, but I'm having problems with how to display these reports. My idea was to output the reports automatically as *.TIFF or *.JPG files and have them stored in a folder that the My Pictures screensaver uses. The reports (in fact, any site report stored in this folder) can then be shown on any screen dotted around the site when it goes into screensaver mode. However I can't find any way to output/convert to a picture file.

The other option is to create a webpage that rotates through the saved PDFs, but this isn't ideal as the PC users will have to load the webpage to display the reports.

View 4 Replies View Related

Modules & VBA :: Save Access Report As PDF And Save To Folder

Jan 10, 2014

I have a few selected reports on an Access 2007 database that users can run. Is there a way for users to view the report, save as a PDF and automatically save a copy to a shared drive by modules/vba coding as an On Click event procedure?

View 4 Replies View Related

Reports :: Output A Report In Word Document Including Images

Oct 21, 2014

I need to know if exist the system in Access 2007 to output a report in word document including images. Normally the output is "*.rtf", with a quite good quality but due to the file type it doesn't include the pictures.

View 1 Replies View Related

Reports :: Saving Report To A Map In Macro

Oct 3, 2013

What I want to do is save a daily report to a map source, each day the map name changes so for today the map name is "Report2013-10-03", and tomorrow the map name will be "Report2013-10-04".

Is this possible? is there some function like save(Report%s) where %s = date() ?

View 4 Replies View Related

Reports :: Send Report As PDF With Macro

Sep 26, 2013

I want to sent out my report as a pdf file with my macro.. I've been trying to use the VBA

Code:
Option Compare Database

Sub Fix1()
DoCmd.SendObject acSendReport, "MarketRiskControl_HighestDiffs_AsOfCurrentDate", "PDFFormat(*.pdf)", "my mail@mail", "cc", , "SD Counterparty Report as of Current Date", "Regards, Trading Risk Control", False
End Sub

But this doesn't work, get run-time error 2282..

I am using access 02.

View 1 Replies View Related

Reports :: How To Save A Report As PDF

Jun 20, 2013

Is it possible to save a report as a pdf but give it a specific name on the click of a button? example if user presses a button the report will be saved as a pdf but the name of the pdf will be made up of two of the text boxes on the report. txtbx1 = "hello" txtbx2 = "123" name of pdf will be hello123...

View 1 Replies View Related

Modules & VBA :: Yes / No Action Does Not Halt Macro

Sep 17, 2014

I have inserted a function via a module at the beginning of a Macro using the RunCode action:

Function Msgbox_Yes_No()
Dim Response As Integer
Response = MsgBox(prompt:="Select 'Yes' or 'No'.", Buttons:=vbYesNo)
If Response <> vbYes Then
End If
End Function

However, it doesnt stop the macro from continuing on its way to delete a load of records if the user chooses no.

View 3 Replies View Related

Forms :: Run Macro Having Three Action Queries

Jan 9, 2014

I want to run a macro which is having three action queries from the another database when i click the button from my current database. I am using Access2010.

View 3 Replies View Related

Reports :: Save Report With Name From Parameter Value?

Mar 28, 2014

Background: Access 2003

I have a database with which I use to generate reports as pdfs to load to a website.

However when I go to save the file as a pdf it is always as the report name.I am trying to automate this by using a macro as I need to run a report 50 times for ships with a different parameter each time (name of the ship) Another report needs to be run about 30 times, this time the parameter being a date And finally two other reports, but I can live with those being the name of the reports.

Firstly can this be done?

Secondly which would be the best way?

I've tried using the macro route by I run my Report "Main_Ship" with a where clause of [ship]="wiltshire". This produces the report with the relevant ship, but I am then unsure what to use next to save it as a pdf with the name "wiltshire" using the macro route.

or

Create a VBA routine that runs the report as many times as required each with a different parameter for the name of ship or date.?

[URL]

View 6 Replies View Related

Reports :: Custom Macro Stopped Report From Rendering

Dec 13, 2014

I am facing an issue The Custom Macro Stopped report from rendering. I have report which is having two sub reports inside. The report is opening in the report view properly but when the ExportWithFormating macro runs, it throws this error.

View 1 Replies View Related

Reports :: Save Additional Data From Report To XLS

Oct 25, 2014

I have a form where user can chose his own criteria for the report, like time period, ppl involved and other parameters. i open report filtered with these conditions. I also create a nice text (as public variable) bout what where the search criteria and put it in the header/footer. Then I export the report as xls file. it's nicely saved as column names and data, just what i need.how to add a field that would store the criteria, ie that string public variable that has it all neatly explained?

View 1 Replies View Related

FieldNames In Subject Line Of SendObject Action In Macro

Aug 6, 2004

I have a Macro setup and SendObject is one of the Actions. It is setup to send an existing report. Is there a way to insert a fieldname from that report into the Subject line of the e-mail that is sent? That would be great, instead of having the same subject line for every e-mail, using the date or something like that. Please let me know. Thanks.

View 3 Replies View Related

Using DLast Or DMax Functions Within SetValue Action In Macro

Oct 28, 2012

I am building a purchase requisition (PR) database.

The tables are (simplified) as follows:

Table1 - tbl_PRList - contains only 3 fields with one of these fields being the "PR No".
Table2 - tbl_PRData - contains all the item data, also with a field "PR No".

The intent of the "item entry" form is to add items to the latest PR that has been generated.

So, whenever an item that is to be placed on the new PR, you type in the item description, qty, etc in the form and then you press a button that saves this item to the main 'data' table (Table1). What I would like to do is, "on click" of this button, I'd like this record, prior to it moving to the next record, to set the value of the PR No field in Table 1 to be the same as the DLast value of the Table2 table.

View 2 Replies View Related

Reports :: Save Report As PDF And Auto Populate File Name

May 8, 2013

My reports are saved as a PDF at the moment I click the print report button, select cutePDF Writer then manually add the Quote number stored in Field from the Table or form into the file name, then select the location to store the PDF file

Can I make this process automated when I click the print report button to auto select PDF Print, then auto populate the file name with the quote/Inv Number and then save to nominated directory.

View 6 Replies View Related

Reports :: How To Save Report As Active Web Data Page

Jun 12, 2014

I am having ACC2003 + win7.my Db Version is a calendar of dailyblog type Tasks.The Tasks are viewed by everyone in office having PCs.

Db Type is F.E+B.E type.

MY question is how to save a Report as Webpage Local on harddisk and that flashes updated information .

Example :
Report---> Local WebPage

SomeChanges done
Updated Report-----> Changed info Webpage

View 1 Replies View Related

Reports :: Unable To Save Report As Excel File

Jul 19, 2015

I want to save my report as excel file on the user computer with a click of a button. I have tried this code:

Private Sub Cmd_ReporttoExcel_Click()
DoCmd.OutputTo acOutputReport, "Gastrolog Report", acFormatXLS, "C:UsersXXDocuments" & Format(Date, "yyyymmdd") & ".xls"
End Sub

But it is giving error 2282 - The format in which you are attempting to output the current object is not available.

The other part of this question is :

This is something similar when I didn't have "PDF add in " in access 2007, when I added PDF add in then option to save file in PDF was available in "output to" action of macro. There is nothing like excel add in. However when I can export the data in excel sheet by Export function in access why don't I have option to save file as excel in "output to " action in macro? I want to have this option so that user can click a button in the form rather than in the top ribbon try to find out how to transfer and save the excel sheet.

View 3 Replies View Related

Error (no. 2501): The Save Action Was Canceled

Sep 13, 2006

Hi all,

Recently I am getting this message in a database that would allow users to add new rows to tables, even when I look into the tables themselves I can't seem to enter data

Would anyone know what could be causing this error?

Error (no. 2501): The save action was canceled

Thanks

Polo
:)

View 3 Replies View Related

Modules & VBA :: Routine To Output Access Report To PDF Using Fields

Jul 3, 2013

I have a routine that outputs an MS Access report as a pdf file which works OK. It does not open the file which is what I want.

DoCmd.OutputTo acReport, "rptTransactionInvoiceExcVAT", acFormatPDF, "C:UsersJEFF1Documents
ptTransactionInvoiceExc VAT.pdf", False

What I would like to do is output the pdf file with a Customer name and number from the field Me.txtAmazonBuyer. I have tried:

DoCmd.OutputTo acReport, "rptTransactionInvoiceExcVAT", acFormatPDF, "C:UsersJEFF1Documents" + ([Me.txtAmazonBuyer]) + ".pdf", False

But no joy.

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved