Rabu, 18 April 2012

[MS_AccessPros] Re: HELP! My accde file lost vba functionality.

 

Hi Liz

I forgot to ask...did you check to see if the folder is still in your trusted locations?

Bill

--- In MS_Access_Professionals@yahoogroups.com, Liz Ravenwood <liz_ravenwood@...> wrote:
>
> Hi Bill, It's good to hear from you.
>
> It's in a folder that has been working and where I run all 33 databases and nobody has quit complaining. Just to rule that out, I did compile to my own area and tried to run it to no avail.
>
> I have:
> 1. compact and repair
> 2. decompiled
> 3. created a whole new db and imported all the objects, compiled to same area, and tried to run
>
> The accde will not perform the vba that is in the accdb.
>
> At the end of the day, if I can't get this to work, I'll send up an unsecured accdb file for the users to use. I can't have people not getting their work done.
>
> Here's some irony: I googled this, and about 8 different links sent IE in to a "Internet Explorer is not responding..." message and I had to shut the tab.
>
> Liz Ravenwood
> Database Developer / Programmer
> Super First Class Products
> B/E Aerospace
> O: 1.520.239.4808
> www.beaerospace.com
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bill Mosca
> Sent: Wednesday, April 18, 2012 1:00 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Re: HELP! My accde file lost vba functionality.
>
> Liz
>
> Take a deep breathe.
>
> Oh, let it out.
>
> Is the folder a trusted location? Check it to make sure. If it isn't your code won't run.
>
> If it is, use the decompile switch to decompile your .accdb file. The easiest way to do that is to create a desktop shortcut with the full path of your MSAccess.exe and then add the switch.
>
> Example (all one line with space before /decompile:
> Target: "C:\Program Files\Microsoft Office\Office14\msaccess.exe" /decompile
>
> Make a backup copy of your accdb just in case. Now drag your accdb to the shortcut. When it opens compact it and close it.
>
> Open the accdb the regular way and make a new accde.
>
> That work?
>
> Regards,
> Bill Mosca, Founder - MS_Access_Professionals
> http://www.thatlldoit.com
> Microsoft Office Access MVP
> https://mvp.support.microsoft.com/profile/Bill.Mosca
>
>
>
>
>
> --- In MS_Access_Professionals@yahoogroups.com, Liz Ravenwood <liz_ravenwood@> wrote:
> >
> > I've been compiling out my accde to accde to the same folder for years, and for some reason today I can't get any of the code for the accde to run.
> >
> > Liz Ravenwood
> > Database Developer / Programmer
> > Super First Class Products
> > B/E Aerospace
> > O: 1.520.239.4808
> > www.beaerospace.com
> >
> > This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>
> This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
>

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar