 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / March 2008Buttons have stopped working in my Access 2007 database
Thisis my first database in Access 2007, it is in a .accdb file which is linked to tables in an online SQlServer database as well as having local tables. I have imported most of the forms from an earlier Acces 2002 database configuring them to new data sources as neccessary. All this has worked satisfactorily in this development phase until quite suddely the buttons have ceased responding on all my forms. Their function is mostly to open up forms but they do other things as well. The buttons open up forms through using a click event to run code in Visual basic. I am wondering if I have inadvertently changed some setting or other which disables VB in the database. If i insert a test button using the wizard to create a macro then that will open a form but that way of doing things will not meet my needs. I woould be grateful for any help in getting the original buttons responding again to the vb code, Best wishes, John Morgan In 2007 your source file has to be in a "trusted" location for VBA code to work. Open A2007, click the "Office" button in the upper left, go to Access Options/Trust Center and add the source file of the db to the list of trusted locations.  SignatureThere's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 You can also sign it with a certificate and then add publisher to trusted publishers depending on how your network folks lock down your computer. > In 2007 your source file has to be in a "trusted" location for VBA code to > work. [quoted text clipped - 3 lines] > > and add the source file of the db to the list of trusted locations. Thanks very much, its all working properly now, more to Access 2007 than I thought, Best wishes, John Morgan > You can also sign it with a certificate and then add publisher to trusted > publishers depending on how your network folks lock down your computer. [quoted text clipped - 7 lines] >> >> and add the source file of the db to the list of trusted locations. Someone here, don't remember who, made a statement that I thought was rather telling. They said that people who had used previous versions of Access had a much larger learning curve with 2007 than people who had never used Access before! SignatureThere's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.