I am working with Access 2010 on Win7 Ultimate. I am having to
constantly repair and compress my database as the functions and sub-
procedures keep breaking. The coding is very simple so there is no
reason for this.

Also the Microsoft office built-in online help is useless, almost
every inquiry turns up with "not found". I have to use Google to find
basic help topics. For example looking for help topics on "object
dependencies" turned up "not found"

What the hell are Microsoft thinking?

DaveJJ <(E-Mail Removed)> wrote in
news:cd512adb-fa74-4188-b204-(E-Mail Removed)
m:

> I am working with Access 2010 on Win7 Ultimate. I am having to
> constantly repair and compress my database as the functions and
> sub- procedures keep breaking. The coding is very simple so there
> is no reason for this.

Is is split into front end/back end?

Have you decompiled recently?

Do you have COMPILE ON DEMAND turned OFF?

Do you compile regularly?

Do you have OPTION EXPLICIT in all your modules?

Have you tried creating a new blank database and importing
everything into it?

> Also the Microsoft office built-in online help is useless, almost
> every inquiry turns up with "not found". I have to use Google to
> find basic help topics. For example looking for help topics on
> "object dependencies" turned up "not found"

Turn off the OFFLINE help and make sure it uses the local help -- I
don't have 2010 on this PC so can't give you exact instructions, but
this is something Albert Kallal has been telling people to do, and
he works all the time in A2010. I always do that in any copy of
Access, since the online help is almost always completely useless.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

On Jan 26, 5:06*pm, "David-W-Fenton" <dfas...@dfenton.com> wrote:
> DaveJJ <garypalm...@gmail.com> wrote innews:cd512adb-fa74-4188-b204-(E-Mail Removed)
> m:
>
> > I am working with Access 2010 on Win7 Ultimate. *I am having to
> > constantly repair and compress my database as the functions and
> > sub- procedures keep breaking. *The coding is very simple so there
> > is no reason for this.
>
> Is is split into front end/back end?
>
> Have you decompiled recently?
>
> Do you have COMPILE ON DEMAND turned OFF?
>
> Do you compile regularly?
>
> Do you have OPTION EXPLICIT in all your modules?
>
> Have you tried creating a new blank database and importing
> everything into it?
>
> > Also the Microsoft office built-in online help is useless, almost
> > every inquiry turns up with "not found". *I have to use Google to
> > find basic help topics. *For example looking for help topics on
> > "object dependencies" turned up "not found"
>
> Turn off the OFFLINE help and make sure it uses the local help -- I
> don't have 2010 on this PC so can't give you exact instructions, but
> this is something Albert Kallal has been telling people to do, and
> he works all the time in A2010. I always do that in any copy of
> Access, since the online help is almost always completely useless.
>
> --
> David W. Fenton * * * * * * * * *http://www.dfenton.com/
> contact via website only * *http://www.dfenton.com/DFA/

There is no option to turn off online help as far as I can see and no
option called "Compile on demand"

DaveJJ <(E-Mail Removed)> wrote in
news:7b51ce73-a93b-4b89-9066-(E-Mail Removed)
m:

> There is no option to turn off online help as far as I can see and
> no option called "Compile on demand"

When I open a database in A2007 and hit F1, I get a help window. At
the bottom right of the window is a button that indicates the
ONLINE/OFFLINE mode for Help. Mine originally said OFFLINE, and when
I clicked it, I saw these options:

- Show content from Office Online
- Show content only from this computer

I believe the default is to use Office Online, which would mean your
button likely says CONNECTED TO OFFICE ONLINE. Click the button and
choose the second choice and see if you get better answers from
Help.

For A2003, if you open the help, there is a link in the Task Pane
for ONLINE CONTENT SETTINGS, which are pretty much self-explanatory.
The UI in A2003 and A2007 is not exactly the same, but the
functionality basically is. And both default to using Online
content, and I always turn that OFF, not because I'm not connected
to the Internet, but because the Online content is USELESS.

COMPILE ON DEMAND is an option in the VBE (since it applies to VBA
code). So, in the VBE, on the TOOLS menu, choose OPTIONS and on the
GENERAL tab, uncheck COMPILE ON DEMAND. This works identically in
A2007 and A2003.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

Thank you very much!

On Jan 28, 5:24*pm, "David-W-Fenton" <dfas...@dfenton.com> wrote:
> DaveJJ <garypalm...@gmail.com> wrote innews:7b51ce73-a93b-4b89-9066-(E-Mail Removed)
> m:
>
> > There is no option to turn off online help as far as I can see and
> > no option called "Compile on demand"
>
> When I open a database in A2007 and hit F1, I get a help window. At
> the *bottom right of the window is a button that indicates the
> ONLINE/OFFLINE mode for Help. Mine originally said OFFLINE, and when
> I clicked it, I saw these options:
>
> - Show content from Office Online
> - Show content only from this computer
>
> I believe the default is to use Office Online, which would mean your
> button likely says CONNECTED TO OFFICE ONLINE. Click the button and
> choose the second choice and see if you get better answers from
> Help.
>
> For A2003, if you open the help, there is a link in the Task Pane
> for ONLINE CONTENT SETTINGS, which are pretty much self-explanatory.
> The UI in A2003 and A2007 is not exactly the same, but the
> functionality basically is. And both default to using Online
> content, and I always turn that OFF, not because I'm not connected
> to the Internet, but because the Online content is USELESS.
>
> COMPILE ON DEMAND is an option in the VBE (since it applies to VBA
> code). So, in the VBE, on the TOOLS menu, choose OPTIONS and on the
> GENERAL tab, uncheck COMPILE ON DEMAND. This works identically in
> A2007 and A2003.
>
> --
> David W. Fenton * * * * * * * * *http://www.dfenton.com/
> contact via website only * *http://www.dfenton.com/DFA/