VBA Not Working -- AT ALL

[twinnyfo]

OK, experts, here is the weirdest thing I have ever experienced with MS Access so far... and I've seen some really weird stuff.

Here I am, working along and building a new database, got a few tables built, designed a report, crafted a few forms--getting the look and feel right first, before I start writing the code.

Then I draft some quick code to perform a very simple function--nothing fancy, just a quick little exercise in recordsets. So, I open the form, click my command button and.... nothing.

What? Maybe I don't have the command button or the procedure named properly. Nope, click on the event launcher and it takes right to where my code is!

Let me insert a break point at the name of the procedure. maybe the procedure is firing, but just not "doing" anything. This wouldn't be the first time that I've written faulty code.

Open the form and click the button.... Nothing! Doesn't even highlight the procedure! Nothing.

Hmmmmm, maybe there is something wrong with "this" DB, but it is brand new--only a couple hours of work. But, let me create a "newer" db and import all my objects.

Open the Form, click the button. NOTHING!!!???

So, I'm trying to figure this out. I check the setting of the DB's I use all the time. Everything is identical.

I click on my Access Options, and under Current Database, I have the "Use Access Special Keys" unchecked. I don't like to let people misuse the DB, so I disable this feature (just like on all my other DBs that currently work!). Hmmmmmmm, I check it, close the DB and open it again.

Open the Form, click the button, and BAM! Works like a charm. Open my Access Options again, uncheck the "Use Access Special Keys" box, close the DB and open it again.

Open the Form, click the button, and BAM! Works like a charm!!!

I freely admit that I don't know everything about Access, but this one is so far beyond absolutely BIZARRE that I had to share to see if anyone has any insights into this?

Yeah! There is a reason why Goofy is scratching his head on this one.....

[Seth Schrock]

When code doesn't work for me, what I normally think of is that I haven't enabled content when the database first opens. If the database isn't in a trusted location, then it will (by default anyway) open the database with macros and code disabled. You would have to click Enable Content to it to work.

[twinnyfo]

Yep - done that. That humongous yellow warning sign that I get is kind of hard to miss....

This one was the craziest thing I've ever seen.

[NeoPa]

Which version Twinnyfo?

Seems like the fact of disabling Special Keys from the start gets it into some mode whereby the code doesn't work.

I'd be interested in a copy to play with if you can share. I can let you have my email address no problem if that helps.

[twinnyfo]

NeoPa,

2010 is the version. I'm not real concerned at this point, as I was able to get it working. But, it is incredibly strange that it exhibited this behavior. Now, after I've got it working, I can't "undo" it--that is, I can't get it to repeat its poor behavior.

Not sure there really is an "answer" to this, other than MS Access likes to have a mind of its own....

[zmbd]

What steps did you take to get things working?
I've seen this happen in only three cases...
- Virus
- Someone was looking at the references and disabled the VBA by "accident"
- Global security setting (GPOEditor: User Config, Admin Templates, Microsoft Excel 2010, Excel Options, Security, Trust Center,
VBA Macro Notification Settings )was set to disable all macros without warning. Convenced my IT departement to set this back to user control... showed them about the signed macros too; however, they thought it would be too much work (I agreed) to setup properly.

[twinnyfo]

Z-

This was exactly as described: New DB, turn off "Use Access Special Keys", buld stuff, nothing works. Turn on "Use Access Special Keys", everything works. Turn it off again, no effect (as it should be).

Weird......

[zmbd]

yes wierd... cannot recreate on my systems... .
not seeing it in the bug reports either...
the Gremlins love you, I'll send you mine too! (^_^)

[Both]

HI twinnyfo

Please tell me you found a solution. I have exactly the same problem. VBA not running from query , but same code runns perfectly inside a form

[twinnyfo]

Both,

The "solution" was exactly as described.

You mention "VBA not running from query." Sounds like the makings for a new question to be answered on this forum....

[NeoPa]

Hi 'Both'.

What he means is that if you think you have a similar problem then by all means post a new question. Do not hijack this thread for your problem as that is not acceptable, whereas new questions, potentially with a link to this one, are perfectly acceptable.

Welcome to Bytes.com :-)

[Nauticalgent]

The Access Gnomes...they are mischievous little varmits!