Senin, 06 Januari 2014

Re: [MS_AccessPros] VBA Code is missing

 

Glenn and John,

We support over 50 databases located on a network.Sorry I used that sentence.  The database in question is shared between 3 users and it is not split. They are not in the database at the same time. I do have a backup and when I open that, I get the same error messages. 

The first message refers to a report that is loading and if I want to continue loading the project. The report is not set up to load at start up. 

The next message is about the vba being deleted. 
 
Jim Wagner



On Monday, January 6, 2014 7:03 AM, John Viescas <JohnV@msn.com> wrote:
 
Jim-

If the "code" part of the database is shared on your network, then that's your problem.  Anyone could have done something to corrupt the database.  I hope you have a backup!

You could try running decompile against a copy of the database to see if that restores the code.  You could also try importing all the objects into a new, empty database.

Best of luck.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)




On Jan 6, 2014, at 2:30 PM, Jim Wagner <luvmymelody@yahoo.com> wrote:

Hello all,

I have been off on vacation for a couple of weeks and I came back to an email from my boss that none of the buttons in one of the databases we support do not work. So I went to the database this morning and no buttons are working. I went to alt -F11 and the vba window came up empty. I went to the onclick event of all the buttons and there is no code between the Private sub and end sub for any of the buttons. 

The database is on a network and I have only seen this before when we converted from 2007 to 2010. Far removed from that scenario, I am questioning why I am now playing "Where's Waldo" with the vba code? 

I will ask what anyone saw or did, but what do I tell my boss?

Thank You
 
Jim Wagner



__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (5)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar