Access 2007 - Macros Not Working Properly

  • Thread starter Thread starter JohnnyO
  • Start date Start date
J

JohnnyO

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've 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?
 
Go Start --> Run
Type Regedit and hit enter

Now, Browse to HKEY_LOCAL_MACHINE
\Software\Microsoft\Office\12.0\Access Connectivity Engine\Engines


Now, where it says SandboxMode in the right pane, double click it and set the value to 0.


Restart Access and try again.

If you need to do it on multiple machines export the registry entry to .reg file and run it on each computer.



Let me know how it goes!
 
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.
 
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?
 
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?
 
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:

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?

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

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?

:

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?



:


Submitted via EggHeadCafe - Software Developer Portal of Choice
What's New for Developers in SharePoint 2010 Object Model?
http://www.eggheadcafe.com/tutorial...d8-3e2773fa29b5/whats-new-for-developers.aspx
 
Back
Top