By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,676 Members | 1,139 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,676 IT Pros & Developers. It's quick & easy.

Opening and closing the relationship window from code

P: n/a
How do I acheive this, any one know.

Thanks in advance.

Nick

Nov 13 '06 #1
Share this Question
Share on Google+
11 Replies


P: n/a
Hi Nick,

DoCmd.RunCommand acCmdRelationships should do the trick.

Cheers - David

On Nov 13, 10:31 am, "Nick 'The Database Guy'"
<nick...@btinternet.comwrote:
How do I acheive this, any one know.

Thanks in advance.

Nick
Nov 13 '06 #2

P: n/a
Thanks David, that works fine, but how would I close the window again?

Nick

Daveo wrote:
Hi Nick,

DoCmd.RunCommand acCmdRelationships should do the trick.

Cheers - David

On Nov 13, 10:31 am, "Nick 'The Database Guy'"
<nick...@btinternet.comwrote:
How do I acheive this, any one know.

Thanks in advance.

Nick
Nov 13 '06 #3

P: n/a
Help!
Nick 'The Database Guy' wrote:
Thanks David, that works fine, but how would I close the window again?

Nick

Daveo wrote:
Hi Nick,

DoCmd.RunCommand acCmdRelationships should do the trick.

Cheers - David

On Nov 13, 10:31 am, "Nick 'The Database Guy'"
<nick...@btinternet.comwrote:
How do I acheive this, any one know.
>
Thanks in advance.
>
Nick
Nov 13 '06 #4

P: n/a
Nick 'The Database Guy' wrote:
Help!
Nick 'The Database Guy' wrote:
>Thanks David, that works fine, but how would I close the window again?
The best way would be to use the Windows API functions, but most database
guys would use a simpler method:

1) Click the exit button, or
2) RunCommand acCmdCloseWindow

--
Message posted via http://www.accessmonster.com

Nov 13 '06 #5

P: n/a
Hi Granny,

Thanks for your help.

Do you have the details of the Windows API function?

Thanks in advance.

Nick
Granny Spitz via AccessMonster.com wrote:
Nick 'The Database Guy' wrote:
Help!
Nick 'The Database Guy' wrote:
Thanks David, that works fine, but how would I close the window again?

The best way would be to use the Windows API functions, but most database
guys would use a simpler method:

1) Click the exit button, or
2) RunCommand acCmdCloseWindow

--
Message posted via http://www.accessmonster.com
Nov 13 '06 #6

P: n/a
Nick 'The Database Guy' wrote:
Do you have the details of the Windows API function?
I'd recommend clicking on the exit button to close the window, but if you
want to hire me to write more code for you, that's fine with me. Do you want
to add or move the tables around in the window? Do you want to change
existing relationships? Does this job offer medical and retirement benefits
too?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200611/1

Nov 13 '06 #7

P: n/a
Nick I answered this exact question, closing the RelationShips window, for
you back in September.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Nick 'The Database Guy'" <ni*****@btinternet.comwrote in message
news:11**********************@b28g2000cwb.googlegr oups.com...
Hi Granny,

Thanks for your help.

Do you have the details of the Windows API function?

Thanks in advance.

Nick
Granny Spitz via AccessMonster.com wrote:
>Nick 'The Database Guy' wrote:
Help!
Nick 'The Database Guy' wrote:

Thanks David, that works fine, but how would I close the window again?

The best way would be to use the Windows API functions, but most database
guys would use a simpler method:

1) Click the exit button, or
2) RunCommand acCmdCloseWindow

--
Message posted via http://www.accessmonster.com

Nov 14 '06 #8

P: n/a
I know you did Stephen, and thank you very much, however I cannot seem
to be able to find the reply that you left on that occasion. Sorry.

Nick

Stephen Lebans wrote:
Nick I answered this exact question, closing the RelationShips window, for
you back in September.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Nick 'The Database Guy'" <ni*****@btinternet.comwrote in message
news:11**********************@b28g2000cwb.googlegr oups.com...
Hi Granny,

Thanks for your help.

Do you have the details of the Windows API function?

Thanks in advance.

Nick
Granny Spitz via AccessMonster.com wrote:
Nick 'The Database Guy' wrote:
Help!
Nick 'The Database Guy' wrote:

Thanks David, that works fine, but how would I close the window again?

The best way would be to use the Windows API functions, but most database
guys would use a simpler method:

1) Click the exit button, or
2) RunCommand acCmdCloseWindow

--
Message posted via http://www.accessmonster.com
Nov 15 '06 #9

P: n/a
Are you telling me that you do not use GoogleGroups? I simply cannot imagine
being able to develop in any language without being able to search
GoogleGroups, MSDN etc.
http://groups.google.ca/groups/searc...es&qt_s=Search

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Nick 'The Database Guy'" <ni*****@btinternet.comwrote in message
news:11**********************@k70g2000cwa.googlegr oups.com...
>I know you did Stephen, and thank you very much, however I cannot seem
to be able to find the reply that you left on that occasion. Sorry.

Nick

Stephen Lebans wrote:
>Nick I answered this exact question, closing the RelationShips window,
for
you back in September.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Nick 'The Database Guy'" <ni*****@btinternet.comwrote in message
news:11**********************@b28g2000cwb.googleg roups.com...
Hi Granny,

Thanks for your help.

Do you have the details of the Windows API function?

Thanks in advance.

Nick
Granny Spitz via AccessMonster.com wrote:

Nick 'The Database Guy' wrote:
Help!
Nick 'The Database Guy' wrote:

Thanks David, that works fine, but how would I close the window
again?

The best way would be to use the Windows API functions, but most
database
guys would use a simpler method:

1) Click the exit button, or
2) RunCommand acCmdCloseWindow

--
Message posted via http://www.accessmonster.com

Nov 15 '06 #10

P: n/a
On Wed, 15 Nov 2006 13:16:51 GMT, "Stephen Lebans"
<ForEmailGotoMy.WebSite.-WWWdotlebansdot...@linvalid.comwrote:
>Are you telling me that you do not use GoogleGroups? I simply cannot imagine
being able to develop in any language without being able to search
GoogleGroups, MSDN etc.
http://groups.google.ca/groups/searc...es&qt_s=Search
I was going to make this reply with the handle "David 'the Google Guy'" but you beat me to it.
Nov 15 '06 #11

P: n/a
"Stephen Lebans" <ForEmailGotoMy.WebSite.-WWWdotlebansdot...@linvalid.com>
wrote in message news:YI*******************@ursa-nb00s0.nbnet.nb.ca...
Nick I answered this exact question, closing the RelationShips window, for
you back in September.
I *thought* I'd heard this saga before. I thought it was my deja vu playing
me up again.
Nov 15 '06 #12

This discussion thread is closed

Replies have been disabled for this discussion.