2007 - form filtering problems

  • Thread starter Thread starter backToASP via AccessMonster.com
  • Start date Start date
B

backToASP via AccessMonster.com

A client installed Access 2007 yesterday and now her form command buttons are
not working. We have run a compile on the application code, with no errors.
Checked the referenced libraries, nothing missing. She mentioned the form
has a Filter OnLoad property that is not on my 2003 form properties. One
command button no longer working builds a simple form filter string as
follows:

me.filter = filterstring
me.filteron=true

There are other command buttons on the form that run very simple code such as
Docmd.OpenForm - nothing is working. I've reviewed the "Whats new in Access
2007" website and haven't found anything, but was wondering if there are
maybe new settings in Access 2007 that should be enabled or disabled. Any
help appreciated.
 
If no code is running at all, she may need to add the database's folder to
the trusted locations under:
Office Button | Access Options | Trust Center | Trust Center Settings
 
Thanks for this quick response. I had a feeling it would be something simple,
but without 2007 running in front of me I was having a hard time
troubleshooting.

I guess this means its time for me to dive into 2007. After 10 years of
developing in 95-2003, I was just not ready for another change. Thanks again!


Allen said:
If no code is running at all, she may need to add the database's folder to
the trusted locations under:
Office Button | Access Options | Trust Center | Trust Center Settings
A client installed Access 2007 yesterday and now her form command buttons
are
Click to expand...
[quoted text clipped - 15 lines]
maybe new settings in Access 2007 that should be enabled or disabled. Any
help appreciated.
Click to expand...
Click to expand...
 
No, worries.

If you are making the change, this may help you adapt:
http://allenbrowne.com/Access2007.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

backToASP via AccessMonster.com said:
Thanks for this quick response. I had a feeling it would be something
simple,
but without 2007 running in front of me I was having a hard time
troubleshooting.

I guess this means its time for me to dive into 2007. After 10 years of
developing in 95-2003, I was just not ready for another change. Thanks
again!


Allen said:
If no code is running at all, she may need to add the database's folder to
the trusted locations under:
Office Button | Access Options | Trust Center | Trust Center Settings
A client installed Access 2007 yesterday and now her form command buttons
are
Click to expand...
[quoted text clipped - 15 lines]
maybe new settings in Access 2007 that should be enabled or disabled.
Any
help appreciated.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top