?
Solved

filter report content using vba

Posted on 2007-11-28
3
Medium Priority
?
592 Views
Last Modified: 2010-10-05
i'm trying to open a report filtered to a certain ref:

 Dim stDocName As String

    stDocName = "PAYMENTRECIEPTSBANK"
DoCmd.OpenReport stDocName, acViewPreview, , wherecondition:="TransferRef = " &  Me.TransferRef

the transferref Datatype is Text because it is a mix of details which may be entered

Any Suggestion to why it does not filter the report????

rgds

benyaw
   
0
Comment
Question by:Benyaw
  • 2
3 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 20366201
try

Dim stDocName As String

    stDocName = "PAYMENTRECIEPTSBANK"
DoCmd.OpenReport stDocName, acViewPreview, ,"[TransferRef] = '" &  Me.TransferRef &"'"
0
 

Author Closing Comment

by:Benyaw
ID: 31411434
Thank you very much
0
 

Author Comment

by:Benyaw
ID: 20366268
worked perfect........thank you
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question