I have a function in Access 2007 that runs the following code:
DoCmd.OutputTo acOutputReport, "rpt-TOC Summary", "Rich Text Format
(*.rtf)", "C:\TOC\Working\PRE-X08-0295.doc", False
When I run this code in an mdb file, it executes with no problems.
When I execute the same function when compiled in an mde file, I get
Error Number "438" (Object doesn't support this property or method).
Does anyone know why this would happen?
Thank you. 2 3236
On Thu, 31 Jul 2008 12:44:41 -0700 (PDT), Icarus <tj******@gmail.com>
wrote:
It's possible that a space character was lost in the formatting. To be
safe, rewrite this as:
DoCmd.OutputTo acOutputReport, "rpt-TOC Summary", acFormatRTF,
"C:\TOC\Working\PRE-X08-0295.doc", False
-Tom.
Microsoft Access MVP
>I have a function in Access 2007 that runs the following code:
DoCmd.OutputTo acOutputReport, "rpt-TOC Summary", "Rich Text Format (*.rtf)", "C:\TOC\Working\PRE-X08-0295.doc", False
When I run this code in an mdb file, it executes with no problems.
When I execute the same function when compiled in an mde file, I get Error Number "438" (Object doesn't support this property or method).
Does anyone know why this would happen?
Thank you.
Have you had a look at Stephen Lebans ReportSpecs.mde?
It might be more than you need, but it works well in my apps. www.lebans.com
"Icarus" <tj******@gmail.comwrote in message
news:9a**********************************@f36g2000 hsa.googlegroups.com...
>I have a function in Access 2007 that runs the following code:
DoCmd.OutputTo acOutputReport, "rpt-TOC Summary", "Rich Text Format
(*.rtf)", "C:\TOC\Working\PRE-X08-0295.doc", False
When I run this code in an mdb file, it executes with no problems.
When I execute the same function when compiled in an mde file, I get
Error Number "438" (Object doesn't support this property or method).
Does anyone know why this would happen?
Thank you. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Robert Langen |
last post by:
I'm calling an Access XP application from an Outlook XP appointment form.
Everything works, but the lines
DoCmd.OutputTo acOutputReport, "testreport", acFormatRTF, "c:\test.rtf",
False
Docmd.Quit...
|
by: paul.hanti |
last post by:
This board has been a plethora of information. Thanks to all that
respond!
I have a quick question regarding the built-in OutputTo macro. I've
built a shared database in Access 2003 (in Access...
|
by: Ryan |
last post by:
Hello. I was hoping that someone may be able to assist with an issue
that I am experiencing. I have created an Access DB which imports an
Excel File with a particular layout and field naming. ...
|
by: dancole42 |
last post by:
I have a question regarding the DoCmd.OutputTo function.
I have an invoice report that shows all of the invoices for a
particular date. I want to create a button that will export each page
of...
|
by: Jim Devenish |
last post by:
I have a report which can be displayed on the screen with:
DoCmd.OpenReport "RemittanceAdvice",acViewNormal,,"PaymentID = " &
paymentRecID
I now wish to create a snapshot of this, using the...
|
by: inika301 |
last post by:
Mr Lebans. Could you help me ? We are trying to run your mdb to
convert access reports to pdf but we can not, because an error
happens. We are just using the A2000SnapShotToPDFver751 that is...
|
by: pdxrichard |
last post by:
Windows XP - Server 2003 - Access 2007 VBA - Code behind a form
Here is my code.
Why can't I find the exported file if the directories exist and there are no permission problems? Isn't a save...
|
by: jmartmem |
last post by:
Greetings,
I have several Access 2007 reports that I regularly export to individual PDF flat files on a web server. I've successfuly created a module sub to export the reports using the...
|
by: Busbait |
last post by:
Hi,
I have the following code which works fine in MS Access 2007. It export current access form records to an excel sheet:
DoCmd.OutputTo acOutputQuery, "RunQuery", acFormatXLSX, , True
Is...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |