Oops. I misspoke. It is Bill Mosca. :-)
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 Liz Ravenwood
Sent: Tuesday, April 24, 2012 7:37 AM
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: RE: [MS_AccessPros] Re: HELP! My accde file lost vba functionality.
This must not be Bill Mosca or he'd remember. I had done that and the accdb did work.
I am back on track now. Not sure what fixed it as last week I had done several recompiles and the compiled did not work and the uncompiled did work. i.e accdb did work accde did not. Yes, compiling the code was clean, and yes, code was bound to the buttons, and no, there were no break points as the code associated with the onload event did not fire but the form did load.
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: Monday, April 23, 2012 7:02 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Re: HELP! My accde file lost vba functionality.
Liz
I've had forms lose their "link" to buttons. I usually decompile and then open
the forms in design view and click on each button. Then I click on their OnClick
event and the builder button to the right of that line to re-sync the button
with its code. While I haven't found documentation to back me up, it does fix
formerly non-operating buttons.
Maybe that will get you back on track.
Regards,
Bill
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Liz Ravenwood
Sent: Monday, April 23, 2012 3:01 PM
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: RE: [MS_AccessPros] Re: HELP! My accde file lost vba functionality.
Interesting theory, but doubtful since the code "on load" of the form was also
inoperative although the form did load. I was able to see a click response on
the command buttons from button to button, but nothing was "frozen" just
inoperative.
I do agree, though, that something I did today (even though I did everything
from decompiling to building a new db from scratch and importing all the
objects) did something. That or, well, the wtf.
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 Steve Conklin
Sent: Monday, April 23, 2012 2:45 PM
To: MS Access Pros List
Subject: RE: [MS_AccessPros] Re: HELP! My accde file lost vba functionality.
Hi Liz.I know I am very late to this thread ... but I might have a clue as to
what may have caused your WTF (great acronym BTW LOL). When doing your last code
edits before it stopped working, did you debug with a breakpoint in your VBA? I
posted about this a few months ago; when the last thing you do is "clear all
breakpoints," the clear doesn't get saved when you save your modules. So maybe
... your code was silently hitting a break ... that's why it appeared to be not
doing anything ... you did a little bit today, and then saved it; by saving, the
prior "clear breakpoints" finally joined the party.
Steve Conklin
To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
From: liz_ravenwood@beaerospace.com <mailto:liz_ravenwood%40beaerospace.com>
Date: Mon, 23 Apr 2012 21:30:12 +0000
Subject: RE: [MS_AccessPros] Re: HELP! My accde file lost vba functionality.
Here's an update:
So... did nothing, did nothing... The ONLY thing I did today was mess about with
a couple of queries, changed a tiny little field on the main form to be unlocked
and changed some code in the on current event to lock or not based on not null
or not.
... and ... the ACCDE WORKS NOW!
Weird weird weird.
You know I went to a conference recently called Toward a Science of
Consciousness in which they had the gamut of sessions. One had to do with
devices measuring ghosts and an acronym they used was WTF for Weird Transient
Fluctuations. What should I call this... let's see... Weird Transient Fixes?
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 10:05 AM
To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: 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%40yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Liz Ravenwood
Sent: Thursday, April 19, 2012 8:21 AM
To: 'MS_Access_Professionals@yahoogroups.com
<mailto:%27MS_Access_Professionals%40yahoogroups.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%40yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.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>
<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>
<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%40yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.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>
<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>
<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%40yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.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>
<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%40yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.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>
<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>
<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%40yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.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>
<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>
<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]
------------------------------------
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]
------------------------------------
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]
------------------------------------
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.
Tidak ada komentar:
Posting Komentar