Prev: Clone Code Complication
Next: How to calculate diffrence between two dates
From: Piperlynne on 1 Mar 2010 14:15
Hi,

Trying to use the wonderful Allen Browne's
http://allenbrowne.com/ser-62code.html. Instead of a filter on the form
though, I want to export a report (filtered). Do I just change the me.filter
to something else? Or do I create a report macro and do a run macro command?

Help!!
Thanks!
From: Allen Browne on 1 Mar 2010 23:02
Export? Is this OutputTo? TransferText? Print to PDF? Other?

You may be able to OpenReport in Print Preview with the WhereCondition to
filter it. Then export it, and Access will apply the filter.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"Piperlynne" <Piperlynne(a)discussions.microsoft.com> wrote in message
news:0560F212-81C3-476C-B19C-C52184336D46(a)microsoft.com...
> Hi,
>
> Trying to use the wonderful Allen Browne's
> http://allenbrowne.com/ser-62code.html. Instead of a filter on the form
> though, I want to export a report (filtered). Do I just change the
> me.filter
> to something else? Or do I create a report macro and do a run macro
> command?
>
> Help!!
> Thanks!

 | 
Pages: 1
Prev: Clone Code Complication
Next: How to calculate diffrence between two dates