2007 - form filtering problems

  • Thread starter backToASP via AccessMonster.com
  • 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.
 
A

Allen Browne

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
 
B

backToASP via AccessMonster.com

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
[quoted text clipped - 15 lines]
maybe new settings in Access 2007 that should be enabled or disabled. Any
help appreciated.
 
A

Allen Browne

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
[quoted text clipped - 15 lines]
maybe new settings in Access 2007 that should be enabled or disabled.
Any
help appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top