PC Review


Reply
Thread Tools Rate Thread

How can I filter by macro in access 2007?

 
 
Brian W
Guest
Posts: n/a
 
      15th Nov 2009
I have an Access 2003 database which includes a feature to filter the records
displayed on a form according to their first letter. The letter required is
selected by clicking on the appropriate key in an option group, which runs a
filter macro. That feature does not work when I import the database into
Access 2007. Is there an equivalent method in 2007 to do the same thing?
 
Reply With Quote
 
 
 
 
Daryl S
Guest
Posts: n/a
 
      18th Nov 2009
Brian -

I would look at the code behind the option group and in the macro on both
the Access 2003 and Access 2007 versions and see if anything is missing or
different. Maybe there was a hard-coded value in the Access 2003 that might
have changed. If you don't see anything different, then post the code and we
might be able to help you get it working.

--
Daryl S


"Brian W" wrote:

> I have an Access 2003 database which includes a feature to filter the records
> displayed on a form according to their first letter. The letter required is
> selected by clicking on the appropriate key in an option group, which runs a
> filter macro. That feature does not work when I import the database into
> Access 2007. Is there an equivalent method in 2007 to do the same thing?

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Advanced Filter by Macro does not work anymore under Excel 2007 - Help ! Sagace Microsoft Excel Discussion 3 5th Jun 2008 06:20 PM
Right-Click Filter Access 2007 vs Access 2002 Noel Microsoft Access 0 28th May 2008 07:07 AM
Access 2007 Apply Filter Macro Conditions Bidders Microsoft Access Macros 0 28th Apr 2008 05:03 PM
Filter macro stopped working in 2007 Clddleopard Microsoft Access 0 30th Jan 2008 08:32 PM
Date Filter Access Macro FSCK! Microsoft Access 2 16th Aug 2006 06:29 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:16 PM.