Events are not firing in my access programming

I recently installed Office 2010. But my access code doesn't fire the events. I made small data base and code just enough to test if events are firing and it works as long as I don't close the database.  If I close the database and open again, the code doesn't fire the events anymore. Is there anyone who can help me with this problem.  Another question, I bought office 2010 but when I open access database I can see "Mydatabase : Database(Access2007) - Microsoft Access" on top of screen. Does the Office 2010 package have Access 2007 instead of 2010 ?

Sangwoo Lee

 

 

 

Question Info


Last updated July 11, 2019 Views 5,577 Applies to:
Answer
Answer

Please insure your database is in a Trusted Location...

To put your database in a Trusted Location...

http://www.access-diva.com/d4.html

In that same area check that your Macros are set to enable all.

As for the labeling or Access 2007, yep it's an issue and Microsoft is aware.  However, note that you are using Access 2010 and you should access to all the new features in Access 2010.


--
Gina Whipp
2010 Microsoft MVP (Access)

Please post all replies to the forum where everyone can benefit.
Gina Whipp
Microsoft MVP (Access 2010-2015)
https://www.access-diva.com/tips.html

4 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Answer
Answer
"Sangwoo Lee" wrote in message
news:*** Email address is removed for privacy ***...
> Yes I bought Office package from Bestbuy (499usd) and I installed and
> registered correctly. I put afterupdate event to a text box to calculate
> currency USD to Pesos.  Macros are correctly running such as add or delete
> record, close form....
 
I'm not sure you understood the issue with Trusted Locations.  VBA code
won't run in a database unless it's either in a trusted location, signed
with a trusted digital certificate, or explicitly trusted at startup.  Check
out the link that Gina posted in her reply.
 
 

Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html
Dirk Goldgar, MS Access MVP 2001-2015
Access tips: www.datagnostics.com/tips.html

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.