We recently had a similar problem when we upgraded our machines to Office 2007. Search functions which worked fine in Office 2000 and 2003 stopped working in Access 2007, in particular ones which were implemented using filter macros. Our inhouse IT people struggled with this for several weeks until we found someone at OfficeSoftworks who fixed the bug. If anyone out there is having the same problem here are their details. their links on the web:
http://www.OfficeSoftworks.com
http://www.OfficeSoftworks.co.uk
http://www.excel-expert.co.uk
http://www.AccessExpert.co.uk
JohnnyO wrote:
Access 2007 - Macros Not Working Properly
25-Aug-09
I created a shared multi-user .mdb file in Access 2000 and our company has
recently upgraded the MS Office Suite to MS Office 2007. Since the upgrade,
the macros for the .mdb file does not work properly. I have added the path of
the .mdb to the Trusted Locations. Case in point. I have a Form and one of
the control boxes(fields) is a combo box that acts as a pull-down selection
to filter the record upon selection. I have a macro on the "After Update"
property that uses the "Apply Filter" using the 'where condition' action
argument. In Access 2000 and Access 2003, this macro worked fine but now it
only works once upon the opening of the form. Because this .mdb file has
become a major working tool for my company, it has caused a work stoppage.
What can I do to remedy this problem?
Previous Posts In This Thread:
On Tuesday, August 25, 2009 8:15 AM
JohnnyO wrote:
Access 2007 - Macros Not Working Properly
I created a shared multi-user .mdb file in Access 2000 and our company has
recently upgraded the MS Office Suite to MS Office 2007. Since the upgrade,
the macros for the .mdb file does not work properly. I have added the path of
the .mdb to the Trusted Locations. Case in point. I have a Form and one of
the control boxes(fields) is a combo box that acts as a pull-down selection
to filter the record upon selection. I have a macro on the "After Update"
property that uses the "Apply Filter" using the 'where condition' action
argument. In Access 2000 and Access 2003, this macro worked fine but now it
only works once upon the opening of the form. Because this .mdb file has
become a major working tool for my company, it has caused a work stoppage.
What can I do to remedy this problem?
On Tuesday, August 25, 2009 6:00 PM
Steve Schapel wrote:
Johnny,I am not really sure of the cause of this problem.
Johnny,
I am not really sure of the cause of this problem. Can you let us know
exactly what you have in the Where Condition argument of your ApplyFilter
action?
But one thing to try in the example you gave would be to insert a
ShowAllRecords action in before the ApplyFilter.
--
Steve Schapel, Microsoft Access MVP
On Wednesday, August 26, 2009 7:56 AM
JohnnyO wrote:
I tried adding the ShowAllRecords Action and it still did not work.
I tried adding the ShowAllRecords Action and it still did not work. Here is
what I have in the where condition: [ECN]=[Forms]![ERR_E]![cboLookup2]
If the syntax of my where condition is the problem, why did it work in the
previous MS Access versions?
"Steve Schapel" wrote:
On Wednesday, August 26, 2009 8:01 AM
JohnnyO wrote:
I tried adding the ShowAllRecords Action and it still did not work.
I tried adding the ShowAllRecords Action and it still did not work. The
Where Condition clause is as follows: [ECN]=[Forms]![ERR_E]![cboLookup2].
If the syntax of the where condition is the problem, why did it work in the
previous versions of MS Access?
"Steve Schapel" wrote:
Submitted via EggHeadCafe - Software Developer Portal of Choice
What's New for Developers in SharePoint 2010 Object Model?
http://www.eggheadcafe.com/tutorials...evelopers.aspx
Similar Threads
