VB scrip doesn't work in Access 2007

[KimTong via AccessMonster.com]

Dear all,

I just upgraded my MS Office 2000 to Office 2007 recently. When I ran my
Access application that I developed in Access 2000 using VB scrip, it didn't
work. On click property, here is my Vb script:

Docmd.OpenForm "MembershipFee", acFormDs

When I click that button that has VB scrip, the screen stay on the current
form. It didn't go to Form 'MembershipFee'. Is anyone can tell me why??
Thanks
in advance.

KF

 

[Arvin Meyer [MVP]]

Your VBA code should work if you have permissions. Office 2007 and Vista
deny most permissions to run code, by default. Set the security permissions
in the database to Low, or get you administrator to set proper permissions.

 

[KimTong via AccessMonster.com]

Hi Arvin,
Thank you for your answer.
I still use Window-Xp in my computer. Is that possible, because of that so my
Vb don't get permission from my window-xp?

KF

Your VBA code should work if you have permissions. Office 2007 and Vista
deny most permissions to run code, by default. Set the security permissions
in the database to Low, or get you administrator to set proper permissions.

Dear all,

[quoted text clipped - 11 lines]

KF

 

[Arvin Meyer [MVP]]

Try to set you security to Low. I don't have Access 2007 on this machine,
but in Access 2003 it's in Tools >>> Macros >>> Security.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Hi Arvin,
Thank you for your answer.
I still use Window-Xp in my computer. Is that possible, because of that so
my
Vb don't get permission from my window-xp?

KF

Your VBA code should work if you have permissions. Office 2007 and Vista
deny most permissions to run code, by default. Set the security
permissions
in the database to Low, or get you administrator to set proper
permissions.

Dear all,

[quoted text clipped - 11 lines]

KF