Access 2007 Error 2487
Contents |
to Snapshot. DoCmd.OutputTo acOutputReport, "", "SnapshotFormat(*.snp)", "", False, "", 0, _ acExportQualityPrint This works fine when I open with ShiftKey to runtime error '2487' test, but returns an error when opening the DB without the shifkey. Error
The Object Type Argument For The Action Or Method Is Blank
2487 - The object type argument for the action is blank or invalid. Any suggestions will be appreciated. Guest, Nov 22, 2007 #1 Advertisements Tom Ventouris Guest Resolved. it seems A2007 will not output the active report when the report name is left balnk, like earlier versions. I used Screen.ActiveReport.Name to do the job: DoCmd.OutputTo acOutputReport, Screen.ActiveReport.Name, "SnapshotFormat(*.snp)", "", False, "", 0, acExportQualityPrint "Tom Ventouris" wrote: > I have a function on my Ribbon to send the active report to Snapshot. > > DoCmd.OutputTo acOutputReport, "", "SnapshotFormat(*.snp)", "", False, "", > 0, _ > acExportQualityPrint > > This works fine when I open with ShiftKey to test, but returns an error when > opening the DB without the shifkey. > > Error 2487 - The object type argument for the action is blank or invalid. > > Any suggestions will be appreciated. Tom Ventouris, Nov 24, 2007 #2 Advertisements Show Ignored Content Want to reply to this thread or ask your own question? It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum. Sign Up Now! Similar Threads A2007 message: A potential security concern has been idenfied Dean Slindee, Jan 14, 2007, in forum: Microsoft Access Replies: 0 Views: 692 Dean Slindee Jan 14, 2007 A2007: container =?windows-1250?Q?Vladim=EDr_Cvajniga?=, Mar 4, 2007, in forum: Microsoft Access Replies: 4 Views: 426 =?windows-1250?Q?Vladim=EDr_Cvajniga?= Mar 5, 2007 A2007: interval keys =?windows-1250?Q?Vladim=EDr_Cvajniga?=, Mar 21, 2007, in forum: Microsoft Access Replies: 0 Views: 317 =?windows-1250?Q?Vladim=EDr_Cvajniga?= Mar 21, 2007 A2007: interval keys =?windows-1250?Q?Vladim=EDr_Cvajniga?=, Mar 21, 2007, in forum: Microsoft Access Replies: 0 Views: 293 =?windows-1250?Q?Vladim=EDr_Cvajniga?= Mar 21, 2007 A2007 mis-feature? =?windows-1250?Q?Vladim=EDr_Cvajniga?=, Mar 28, 2007, in forum: Microsoft Access Replies: 12 Views: 364 =?windows-1250?Q?Vladim=EDr_Cvajniga?= Mar 31, 2007 A2007 combo-b
Community Links Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find All Thanked Posts Go to Page... Thread Tools Rating: Display Modes 03-10-2005, 01:45 PM #1 BigMr.C Registered User Join Date: Feb 2005 Posts: 14 Thanks: 0 Thanked 0 Times in 0 Posts object type argument blank or invalid I'm trying to attach a report to an email - it can be any report on screen, the user hits F12 key and the report is attached. The following code has been working fine for years and now all of a sudden it returns the error 2487 "The object type argument for the action or method is blank or invalid" code on hitting F12 key: Private Sub f12() On Error GoTo http://www.pcreview.co.uk/threads/outputto-error-in-a2007.3326345/ err_f12 DoCmd.SendObject acSendReport, , acFormatRTF Exit_f12: Exit Sub err_f12: Resume Exit_f12 End Sub BigMr.C View Public Profile Find More Posts by BigMr.C 03-10-2005, 06:33 PM #2 WayneRyan AWF VIP Join Date: Nov 2002 Location: Camarillo, CA Posts: 7,064 Thanks: 4 Thanked 54 Times in 52 Posts BigMr.C, Hope this link helps: http://support.microsoft.com/kb/260819 Wayne WayneRyan View Public Profile Find More Posts by WayneRyan « Previous Thread | Next Thread » Thread Tools Show Printable Version http://www.access-programmers.co.uk/forums/showthread.php?t=83018 Email this Page Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Rate This Thread Excellent Good Average Bad Terrible Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Access World Access World News Site Suggestions Introduce Yourself The Watercooler Microsoft Access Discussion General Tables Queries Forms Reports Macros Modules & VBA Theory and practice of database design Access Web Microsoft Access Reference Access FAQs Code Repository Sample Databases Microsoft Access Tutorials Microsoft Access User Groups Apps and Windows SQL Server Crystal Reports Visual Basic VB.NET Word Excel Web Design and Development ASP and ASP.NET PHP & MySQL Windows Other Software Hardware Questions and Answers Non-Access Issues Politics & Current Events Debates Gaming Sports, Health & Fitness Gadgets Small Business All times are GMT -8. The time now is 04:56 PM. Microsoft Access Help General Tables Queries Forms Reports Macros Modules & VBA Theory & Practice Access FAQs Code Repository Sample Databases Video Tutorials Sponsored Links How to advertise Media Kit Contact Us - Home - Privacy Statement - Top Po
sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 12 http://www.dbforums.com/showthread.php?1660389-sendobject-problem of 12 Thread: sendobject problem Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search http://www.fmsinc.com/microsoftaccess/errors/ErrorNumber_Description2010.html Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 09-17-10,12:14 #1 jpadilla View Profile View Forum Posts Registered User Join Date Sep 2010 Posts 5 Unanswered: sendobject problem Below is a sample of my code which is used to populate a message that must be e-mailed. When outlook comes up, it is seen in the proper format and shows the carriage access 2007 returns as was formatted by my code. When the message is sent, I lose the carriage returns. Can anyone help me with this one? Why is outlook defaulting to plain text when I use the sendobject command? c1 = " The following purchase requisition requires additional approval due to the following reason: " c1b = " [indicate with an X all that apply]" c2 = " [ ] Air Conditioners (DC and Facilities)" c3 = " [ ] Clothing And Jackets(FDC)" c4 = access 2007 error " [ ] Food Purchases (DC)" c5 = " [ ] Furniture(DC And Facilities)" ... Msg = Chr(13) & c1 & Chr(13) & c1b & Chr(13) & Chr(13) & c2 & Chr(13) & c3 & Chr(13) & c4 & Chr(13) & c5 & Chr(13) m1 = " I, John Doe, approve this requisition on " & Date " m2 = " Requisition: " & Left([fy], 3) & Me![dhs #] m3 = " Description: " & Me![DESCRIPTION] m4 = " Budget Code: " & Me![BCODE] m5 = " Object Code: " & Me![OCODE] m6 = " Total Cost: " & Me![Req Amt] m7 = " Requester: " & Me![CONTACT] m8 = " Suggested Vendor: " & Me![CONTRACTOR] Msg = Msg & Chr(13) & m1 & Chr(13) & Chr(13) & m2 & Chr(13) & m3 & Chr(13) & m4 & Chr(13) & m5 & Chr(13) & m6 & Chr(13) & m7 & Chr(13) & m8 DoCmd.SendObject acSendNoObject, , acFormatHTML, "jpadilla@dot.nyc.gov", "jpadilla@dot.nyc.gov", , "Approval for requisition " & Left([fy], 3) & [dhs #], Msg2, -1, "E:\fiscal programs\req\ReqApproval1.htm" Reply With Quote 09-17-10,12:35 #2 Sinndho View Profile View Forum Posts Moderator Join Date Mar 2009 Posts 5,440 Provided Answers: 14 Try replacing Chr(13) by vbNewLine which is Chr(13) & Chr(10) (or CrLf). Have a nice day! Reply With Quote 09-17-10,12:45 #3 jpadilla View Profile View Forum Posts Registered User Join Date Sep 2010 Posts 5 sendobject problem I tried doing what you suggested but it did not work. It looks like the
Visual SourceBook Total Access Speller Total Access Startup Total Access Statistics Multi-Product Suites >> Overview of Suites Total Access Ultimate Suite Total Access Developer Suite Total Visual Developer Suite Visual Basic 6 >> Total Visual Agent Total Visual CodeTools Total Visual SourceBook Total VB Statistics Multi-Product Suites >> Overview of Suites Total Visual Developer Suite Total Visual Enterprise Suite Sentinel Visualizer Total ZipCode Database Catalog and Fliers Product Awards Product Reviews Product User Matrix Pre-Sale FAQs Version Compatibility Chart Language Support User Manuals Order News Announcements Current Newsletter Upcoming Events Product Reviews Media Videos Free Resources Overview Product Demos Microsoft Access Developer Help Center Microsoft Access Query Help Center Microsoft Access to SQL Server Upsizing Microsoft Outlook Tips Technical Whitepapers Tips and Techniques Technical Videos Consulting Overview Success Stories Technical Expertise Microsoft Access About About Us Contact Us Why Choose FMS? Awards Quality Pledge Microsoft Access 2010 Error Numbers and Descriptions Here is a list of all 2,976 error codes and descriptions for Microsoft Access 2010. Ranging from error number 3 to 32682, each error code describes a different event. Some of the descriptions have tokens (e.g. | and @) that are replaced by Access with text for the specific error. This list of error numbers and descriptions is also available in a PDF file: Microsoft Access 2010 Error Number and Descriptions 100 page PDF Report (738 K) Most of the error numbers and descriptions are identical to past versions, but there are some differences. To see how the error messages compare to Microsoft Access 2007 and 2003, read this: Microsoft Access 2010-2003 Error Number and Descriptions 205 page PDF Report (1.3 MB) Additional Resources Technical Paper: Error Handling and Debugging Tips and Techniques for Microsoft Access, VBA, and Visual Basic 6 (VB6) Error between Access 2007 and 2010: You cannot save this database in an earlier version format, because it uses features that require the current file format Main Error Number and Description page For additional Microsoft Access help visit our: Microsoft Access Resource Center Microsoft Access Developer Help Center Microsoft Access Developer Services Error Number Error Description 3 Return without GoSub 5 Invalid procedure call or argument 6 Ove