calling a Access Outputto method from VB6 and passing a filter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using the Access.Application object to call the docmd.outputto method.
All works fine until I try to put in a filter. I tried docmd.applyfilter but
it would not work. How can I assign a filter to the report that is running?

I am calling this from within VB and VBScipt so that I can do webbased
reporting from access reports to a snp file format.

Thanks, Jeff
 
Hello Jeff,

Please see if you have encountered the following known issues:

228641 ACC2000: Access Help for the ApplyFilter Action or Method Is
Incorrect
http://support.microsoft.com/?id=228641

269380 ACC2000: ApplyFilter Action in a Macro Is Not Applied as Expected
After
http://support.microsoft.com/?id=269380

Thanks & Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security

=====================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
| Thread-Topic: calling a Access Outputto method from VB6 and passing a
filter
| thread-index: AcT0J2UsLUYpiZkxQQKEdHY6+57YXA==
| X-WBNR-Posting-Host: 69.15.20.18
| From: "=?Utf-8?B?amVmZg==?=" <[email protected]>
| Subject: calling a Access Outputto method from VB6 and passing a filter
| Date: Thu, 6 Jan 2005 11:39:11 -0800
| Lines: 9
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.modulesdaovba
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.access.modulesdaovba:145005
| X-Tomcat-NG: microsoft.public.access.modulesdaovba
|
| I am using the Access.Application object to call the docmd.outputto
method.
| All works fine until I try to put in a filter. I tried docmd.applyfilter
but
| it would not work. How can I assign a filter to the report that is
running?
|
| I am calling this from within VB and VBScipt so that I can do webbased
| reporting from access reports to a snp file format.
|
| Thanks, Jeff
|
|
 
Back
Top