Procrdures not working

[funderburgh]

I am new to Access and adding a login form to my project. I have several forms working well, with macros and VBA procedures tied to events. In my new form, nothing works! I have put MsgBox commands on a variety of events to debug this issue, but I can't get any event to respond except a close macro on the click event of a buttom control. Any ideas are welcome. Thanks.

 

[Ziggy1]

what version of Access? and what method are you using to Open the form (switchboard or you own)?

 

[funderburgh]

I'm using 2007, and I am opening the form in the switchboard. The form is Modal Dialog - is that the issue perhaps?

 

[georgedwilkinson]

2007 you say? And VBA code is not working?

Our Giga-MVP moderator's web site has some instructions that might help:
http://www.btabdevelopment.com/main...owtoenablecodeandmacros/tabid/57/Default.aspx

 

[Ziggy1]

Modal forces you to act on the form, but not sure if that is your problem. with the switchboard which option did you choose when opening the form..edit/add, did you change any form properties...try running the form on it's own ( without switch)

also for debugging is there any code in the Open/activate, place a debug mark to stop the code of any procedure you are testing and step through with "F8".

 

[funderburgh]

OK, thanks very much for the help - I got it. Vista had disabled the content of the database because I was not a trusted source. It make me believe that Microsoft knows more about me than they should. Thanks again to all.

John

 

[Ziggy1]

Good Call George, I am getting used to that myself ( the 2007 changes), but I haven't run any new code in 2007 version....I'll have to add that to my checklist

 

[georgedwilkinson]

Glad to help.

I have an association in my mind: 2007, doesn't work: check settings. Fixes about 80+% of the problems with 2007.