Persistent Connetion

[QB]

I am wanting to put in place some best practices to try and optimize a db and
am working on the 'Persistent Connection', as discussed in
http://www.granite.ab.ca/access/performanceldblocking.htm

Now, Tony starts off talking about opening a bound form in hidden mode using

DoCmd.OpenForm "frmKeepOpen", acNormal, , , , acHidden

Then he goes on to talking about referencing the fields ... using

forms!GlobalOptions!goReportBandingColour and
forms!GlobalOptions!goCorporateLogoPathandFilename

I am just a little confused since the form he originally opens was called
frmKeepOpen? Where is GlobalOptions coming from?

I am sure it is something very obvious, but I seem to be missing this
evening. Could someone oblige me and explain.

Thank you,

QB

 

[Tom van Stiphout]

On Tue, 16 Mar 2010 20:17:01 -0700, QB <[email protected]>
wrote:

It seems like the page was not written in one sitting. Replace
GlobalOptions with frmKeepOpen. I'm sure Tony woudn't mind you
contacting him with a request to update the page.

-Tom.
Microsoft Access MVP

 

[david]

"frmKeepOpen" is a general example form name for you to use:

"In your startup form ..."

"GlobalOptions" is the specific example form name that he uses
when he is specifically writing about what he personally does:

"I always ...."
"I then reference ...."

(david)