"Me" Macro

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

Guest

Hello
In setting up code for faxing invoices in Northwind (using Article 145787)I
have been having problems with the me macro. It states to go into the report
and add the line "me.filter = strinvoicewhere" but when I run the code as
written in the article, it errors out with a run time error of 2492 - access
can't find the macro "filter=strinvoicewhere" in the macro group 'me'.

What step am I missing? I am sure it is a certain macro but I am not sure
what to select in the macro.

Thanks for your help

Lisa
 
There is no "Me" macro. Me is a shorthand way (in VBA, not in a macro) of
referring to the object to which the module belongs. For example, if you're
running VBA code in a form's module and want to get the name of that form,
the VBA code would use
Me.Name

I don't have any idea about how you're trying to use this, but the little
snippet (which, by the way, is a VBA statement, not a macro statement)
me.filter = strinvoicewhere
suggests that you're wanting to use a variable to set the filter property of
a form or report. That means that you need to run this code step as part of
an Event Procedure for the form or report.

But, give us more information so that we can suggest how to fix this.
 
Ken,

Thanks for your quick response. Sorry I should have sent this into the VBA
discussion group. What I am trying to do is to fax out only the invoices
that belong to that customer. When I take that filter out, it sends the
whole report out to each customer. Am I heading down the wrong track? Is
this possible without creating reports for each customer out of a table? If
you want me to send this to the other discusstion group please let me know.

Thanks again!!
Lisa
 
This topic probably would be better in another newsgroup, but first tell me
a bit more info... such as, in which object are you trying to use this code
step (form or report)? And where are you trying to put it? When are you
running it?
 
Back
Top