Glad to help, Liz.
Bill
From: MS_Access_Professio
[mailto:MS_Access_Professio
liz_ravenwood@
Sent: Thursday, August 21, 2008 3:31 PM
To: MS_Access_Professio
Subject: Re: [MS_AccessPros] Re: MDB vs MDE code
Bill,
GOOD stuff! The advice you gave, and coffee too!
Respectfully,
Liz, Data Base Administrator,
Methods Engineering
"Bill Mosca" <wrmosca@comcast.
Sent by: MS_Access_Professio
<mailto:MS_Access_
08/21/2008 02:00 PM
Please respond to
MS_Access_Professio
<mailto:MS_Access_
To
MS_Access_Professio
<mailto:MS_Access_
cc
Subject
[MS_AccessPros] Re: MDB vs MDE code
Liz
You are too funny! Yes, coffee Mongo's friend!
In answer to your queston, Anything that runs in an MDB should run in
an MDE except code that tries to open a form, report or macro in
design view OR code that alters and saves a form, report or macro. In
other words you cannot do this:
DoCmd.OpenForm "Form1", acDesign
OR this:
Forms!Form1.
DoCmd.Save acForm, "Form1"
You have to remember that a form, report or macro is protected from
permanent change. You can still make changes on the fly, but cannot
save them. the object will revert back to its original design.
On changing a RecordSource.
form view or datasheet view to TEMPORARILY change it. (man, it's
tough holding the Shift key down while typing. Who am I kidding it's
just plain tough typing at all.)
Regards,
Bill Mosca,
http://www.thatlldo
Founder - MS_Access_Professio
http://tech.
Microsoft Office Access MVP
http://mvp.support.
--- In MS_Access_Professio
<mailto:MS_Access_
wrote:
>
> Pros,
>
> Is there a list of things that will run in an mdb but not an mde?
I
> compiled a db, but get an error message saying that something
didn't run
> because it was an mde file........
file in
> design mode to set the recordsource. I don't have to get into
design mode
> to set the recordsource do I?
> I'll try... nevermind... but maybe you don't mind my learning
things as
> I type along...
>
>
> coffee good!
>
> Respectfully,
> Liz, Data Base Administrator,
> Methods Engineering
>
>
> ------------
------------
>
> 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]
[Non-text portions of this message have been removed]
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
__,_._,___
0 comments:
Post a Comment