dbTalk Databases Forums  

Reference another database

comp.databases.ms-access comp.databases.ms-access


Discuss Reference another database in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #41  
Old   
Tony Toews
 
Posts: n/a

Default Re: Reference another database - 12-23-2010 , 01:39 PM






On Thu, 23 Dec 2010 08:36:12 GMT, "Phil" <phil (AT) stantonfamily (DOT) co.uk>
wrote:

Quote:
Hope I won't need to pester you any more - but don't bet on it.
If you were pestering us we wouldn't answer. <smile> There's only
four people who I generally view as pesters. And they shall remain
nameless. The most recent one is famous for his four letter language
and has been seen as recent as a week ago.

In addition a wide variety of viewpoints and problems are discussed.
So I'm always learning something new although the rate these last few
years in Access has decreased for me.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/

Reply With Quote
  #42  
Old   
David-W-Fenton
 
Posts: n/a

Default Re: Reference another database - 12-23-2010 , 07:27 PM






imb <imb4u (AT) onsmail (DOT) nl> wrote in
news:0fd0079a-4535-4d46-9be4-3b542be2c1f5 (AT) g25g2000yqn (DOT) googlegroups.co
m:

Quote:
However, I have a problem with understanding “without jumping
through hoops”.
http://idioms.thefreedictionary.com/jump+through+hoops

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

Reply With Quote
  #43  
Old   
David-W-Fenton
 
Posts: n/a

Default Re: Reference another database - 12-23-2010 , 07:29 PM



"Phil" <phil (AT) stantonfamily (DOT) co.uk> wrote in
news:ietvag$ns4$1 (AT) speranza (DOT) aioe.org:

Quote:
I want to use a standard "Menu database" in all my applications
that uses tables from a FE database (FeA) which has linked tables
from BeA. Having clicked on an item in the menu, the menu should -
I think - stay open, but then control passes back to a form in
FeA. When that form closes, presumably the menu would still be
visible. If I can get that right, I want to go further and have
say a standard Backup database, again getting information via FeA
but the backup form being initiated by clicking on the menu. How
does your suggestion of Application.Run do this?
I haven't a clue. I have never implemented anything like what you
describe, nor see any reason to do so, so really haven't a clue what
the issues are.

I wouldn't go with something so complicated precisely because it's
not the way Access was designed to work. Or, at least, work WELL.
Outside references are something that MUST be kept to a minimum to
insure the app runs in all environments. I would never sacrifice
that for the purpose you describe.

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

Reply With Quote
  #44  
Old   
Access Developer
 
Posts: n/a

Default Re: Reference another database - 12-27-2010 , 03:50 PM



"Tony Toews" <ttoews (AT) telusplanet (DOT) net> wrote

Quote:
There's only four people who I generally
view as pesters. And they shall remain
nameless.
Aha! They have now been relegated to the status of "The Nameless Four".
Will everyone here remember that, when we use it in a sentence such as
"That's barely above the standards of The Nameless Four!"? <GRIN>

Reply With Quote
  #45  
Old   
Tony Toews
 
Posts: n/a

Default Re: Reference another database - 12-27-2010 , 08:03 PM



On Mon, 27 Dec 2010 15:50:38 -0600, "Access Developer"
<accdevel (AT) gmail (DOT) com> wrote:

Quote:
There's only four people who I generally
view as pesters. And they shall remain
nameless.

Aha! They have now been relegated to the status of "The Nameless Four".
Will everyone here remember that, when we use it in a sentence such as
"That's barely above the standards of The Nameless Four!"? <GRIN
Now you wouldn't know of this but there was an excellent Canadian
comedy called Corner Gas about a village in the middle of
Saskatchewan. With one bar, one grocery store, one gast station and
one cafe, etc, etc.

The locals in the bar, when the local rival village is named, all
rellexively spit on the floor. So we could accompany the mention of
the Nameless Four with at least the motion

(BTW the first of my nameless four the Access folks have never
encountered. He's famous in the Edmonton newsgroups though for being
homophobic, anti-semitic, racist and every other stereotype you can
think of. <shudder>)

Tony

--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/

Reply With Quote
  #46  
Old   
Access Developer
 
Posts: n/a

Default Re: Reference another database - 12-28-2010 , 01:08 AM



I can think of four that the Access people _do_ know (though it appears that
one of them has gone to the Great Trolling Ground in the Sky)... so I wasn't
upset at your use of the number four.

Larry

"Tony Toews" <ttoews (AT) telusplanet (DOT) net> wrote

Quote:
On Mon, 27 Dec 2010 15:50:38 -0600, "Access Developer"
accdevel (AT) gmail (DOT) com> wrote:

There's only four people who I generally
view as pesters. And they shall remain
nameless.

Aha! They have now been relegated to the status of "The Nameless Four".
Will everyone here remember that, when we use it in a sentence such as
"That's barely above the standards of The Nameless Four!"? <GRIN

Now you wouldn't know of this but there was an excellent Canadian
comedy called Corner Gas about a village in the middle of
Saskatchewan. With one bar, one grocery store, one gast station and
one cafe, etc, etc.

The locals in the bar, when the local rival village is named, all
rellexively spit on the floor. So we could accompany the mention of
the Nameless Four with at least the motion

(BTW the first of my nameless four the Access folks have never
encountered. He's famous in the Edmonton newsgroups though for being
homophobic, anti-semitic, racist and every other stereotype you can
think of. <shudder>)

Tony

--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/

Reply With Quote
  #47  
Old   
Tony Toews
 
Posts: n/a

Default Re: Reference another database - 12-28-2010 , 06:35 PM



On Tue, 28 Dec 2010 01:08:28 -0600, "Access Developer"
<accdevel (AT) gmail (DOT) com> wrote:

Quote:
I can think of four that the Access people _do_ know (though it appears that
one of them has gone to the Great Trolling Ground in the Sky)... so I wasn't
upset at your use of the number four.
Ah, you're including Steve. I'm not because while he was irritating
he was about 1% of the viciousness of the others.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/

Reply With Quote
  #48  
Old   
Access Developer
 
Posts: n/a

Default Re: Reference another database - 12-28-2010 , 10:25 PM



"Tony Toews" <ttoews (AT) telusplanet (DOT) net> wrote

Quote:
Ah, you're including Steve. I'm not because
while he was irritating he was about 1% of
the viciousness of the others.
Over all, he was surely less vicious than the others, but I suspect it
wasn't for lack of trying or desire on his part, because he could be pretty
nasty at times -- he just was not as capable in the arena of viciousness.
Send me an e-mail with the "other" besides the Edmonton newsgroups, because
I obviously missed someone. <SMILE>

Reply With Quote
  #49  
Old   
Tony Toews
 
Posts: n/a

Default Re: Reference another database - 12-30-2010 , 02:07 PM



On Tue, 28 Dec 2010 22:25:48 -0600, "Access Developer"
<accdevel (AT) gmail (DOT) com> wrote:

Quote:
Ah, you're including Steve. I'm not because
while he was irritating he was about 1% of
the viciousness of the others.

Over all, he was surely less vicious than the others, but I suspect it
wasn't for lack of trying or desire on his part, because he could be pretty
nasty at times -- he just was not as capable in the arena of viciousness.
Send me an e-mail with the "other" besides the Edmonton newsgroups, because
I obviously missed someone. <SMILE
Your list of four and mine had three duplicates. Mine had the
Edmonton guy whereas yours had Steve.

Tony

--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.