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

'Tis a mystery. Have you tried creating an accde on someone else's computer?
Maybe the problem lies in your installation.

Regards,

Bill

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Liz Ravenwood
Sent: Thursday, April 19, 2012 8:21 AM
To: 'MS_Access_Professionals@yahoogroups.com'
Cc: Bruce Patterson
Subject: RE: [MS_AccessPros] Re: HELP! My accde file lost vba functionality.

True. There isn't any documentation out there, and I don't know if my boss would
want to pay for the support. It's a few hundred dollars just for the phone call.

I've seen something similar where one module didn't work. I could even watch it
in debug say that it was doing the right thing, but it was not. I put a little
text box on the main form so that I could see values set even outside of the
debugger as real time. It said it was doing it, it was not.

The thing that did work for that database was the rebuild from scratch and
import all the objects. Remembering that experience made me optimistic that that
step would work for this one, but it didn't. It doesn't perform any of the code
on any of the command buttons. The user clicks and ... nothing ... unless they
run the accdb.

WEIRD.

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%40yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Bill Mosca
Sent: Thursday, April 19, 2012 7:23 AM
To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: [MS_AccessPros] Re: HELP! My accde file lost vba functionality.

So the accdb works and the accde doesn't work? That's just plain weird. Sorry,
but I don't have a clue as to why that would happen.

Bill

--- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , Liz Ravenwood
<liz_ravenwood@...> wrote:
>
> So what I did was moved the unsecure accdb copy out for the users to use.
Completely unsecure, but wtf I can't afford to waste any more time and I can't
afford to not have their code working for them. I have a lot of automation built
in and won't lose it.
>
> 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%40yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Bill Mosca
> Sent: Wednesday, April 18, 2012 3:10 PM
> To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> Subject: [MS_AccessPros] Re: HELP! My accde file lost vba functionality.
>
> Liz
>
> You never install Access on a server. What are you talking about?
>
> Bill
>
> --- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , Liz Ravenwood
<liz_ravenwood@> wrote:
> >
> > I guess not. This is bad. Corporate IT doesn't support Access officially. If
I have to have an install to the app servers, that'll not be so good...
> >
> > 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%40yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Liz Ravenwood
> > Sent: Wednesday, April 18, 2012 1:24 PM
> > To: 'MS_Access_Professionals@yahoogroups.com
<mailto:%27MS_Access_Professionals%40yahoogroups.com> '
> > Subject: RE: [MS_AccessPros] Re: HELP! My accde file lost vba functionality.
> >
> > Hey Bill Thanks.
> >
> > So it will work for 2007 too?
> >
> > 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%40yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Bill Mosca
> > Sent: Wednesday, April 18, 2012 1:17 PM
> > To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> > Subject: [MS_AccessPros] Re: HELP! My accde file lost vba functionality.
> >
> > Liz - maybe this hotfix will fix it.
> > http://support.microsoft.com/kb/2596585
> >
> > Bill
> >
> > --- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.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%40yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Bill Mosca
> > > Sent: Wednesday, April 18, 2012 1:00 PM
> > > To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.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
<mailto:MS_Access_Professionals%40yahoogroups.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.
> > >
> >
> >
> >
> >
> > ------------------------------------
> >
> > 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.
> >
> >
> >
> > ------------------------------------
> >
> > 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.
> >
>
>
>
>
> ------------------------------------
>
> 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.
>

------------------------------------

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.

[Non-text portions of this message have been removed]