When developing MS Access Application, MS Access 2007 will come with VBA Macro disabled. You will not be able to run MS Access VB Code if this option is disable. The warning message will be on the top of MS Access Application right under the toolbar.
User will need to enable this option every time they open the application like the screen shot below.
To prevent this message from always poping up, you can just add the below VBA code to your start-up form in Form_Open event. Your problem then should be resolved
Dim ChangeReg
Set ChangeReg = CreateObject("WScript.Shell")
ChangeReg.regwrite "HKCU\Software\Microsoft\Office\12.0\Access\Security\VBAWarnings", "1", "REG_DWORD"
If you don't want to put this in your MS Access Application, you just need to modify your registry by setting up VBAWarnings value at HKEY_Current_User\Software\Microsoft\Office\12.0\Access\Security give it value as 1 with REG_DWORD (Hexadecimal). But with this way, you will have to do it on every machine that needs to use your application.
I would say the adding VBA code would be much more handy. Once you have it there, you won't have to do any more tasks. The only problem I would set up the value manually is when security come into play. For example, when OS login could not modify the registry and needs to have administrator user logged in to modify it.
0 comments:
Post a Comment