Jim,
Is your database split? Does every user have their own copy of the frontend? If so, is the vba missing from all frontends? That would be very unusual indeed. On the other hand if all users are sharing a common frontend on the network, then corruption (and loss) of the Vba code is quite possible. I am asking because the shared frontend scenario comes to mind from the phrasing of your question – you are referring to “one of the databases” and it sounds like you are looking for the Vba code in a single location.
The recommended way to set up production databases is to split the application into front and back ends. The back end (data and relationships) resides in a single location on the network. Each user has their own copy of the front end (form, reports, queries, macros, and vba) linked to the backend. The front end should never be shared.
Glenn
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Jim Wagner
Sent: Monday, January 6, 2014 8:31 AM
To: ms_access_professionals@yahoogroups.com
Subject: [MS_AccessPros] VBA Code is missing
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 (2) |
Tidak ada komentar:
Posting Komentar