Help | Site Map
Connecting Tech Pros Worldwide
 
 
LinkBack Thread Tools
  #1  
Old November 13th, 2006, 10:15 AM
Nick 'The Database Guy'
Guest
 
Posts: n/a
Default Opening and closing the relationship window from code

How do I acheive this, any one know.

Thanks in advance.

Nick

  #2  
Old November 13th, 2006, 11:35 AM
Daveo
Guest
 
Posts: n/a
Default Re: Opening and closing the relationship window from code

Hi Nick,

DoCmd.RunCommand acCmdRelationships should do the trick.

Cheers - David

On Nov 13, 10:31 am, "Nick 'The Database Guy'"
<nick...@btinternet.comwrote:
Quote:
How do I acheive this, any one know.
>
Thanks in advance.
>
Nick
  #3  
Old November 13th, 2006, 11:45 AM
Nick 'The Database Guy'
Guest
 
Posts: n/a
Default Re: Opening and closing the relationship window from code

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

Nick

Daveo wrote:
Quote:
Hi Nick,
>
DoCmd.RunCommand acCmdRelationships should do the trick.
>
Cheers - David
>
On Nov 13, 10:31 am, "Nick 'The Database Guy'"
<nick...@btinternet.comwrote:
Quote:
How do I acheive this, any one know.

Thanks in advance.

Nick
  #4  
Old November 13th, 2006, 02:55 PM
Nick 'The Database Guy'
Guest
 
Posts: n/a
Default Re: Opening and closing the relationship window from code

Help!


Nick 'The Database Guy' wrote:
Quote:
Thanks David, that works fine, but how would I close the window again?
>
Nick
>
Daveo wrote:
>
Quote:
Hi Nick,

DoCmd.RunCommand acCmdRelationships should do the trick.

Cheers - David

On Nov 13, 10:31 am, "Nick 'The Database Guy'"
<nick...@btinternet.comwrote:
Quote:
How do I acheive this, any one know.
>
Thanks in advance.
>
Nick
  #5  
Old November 13th, 2006, 05:25 PM
Granny Spitz via AccessMonster.com
Guest
 
Posts: n/a
Default Re: Opening and closing the relationship window from code

Nick 'The Database Guy' wrote:
Quote:
Help!
>
>
Nick 'The Database Guy' wrote:
>
Quote:
>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

  #6  
Old November 13th, 2006, 06:35 PM
Nick 'The Database Guy'
Guest
 
Posts: n/a
Default Re: Opening and closing the relationship window from code

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:
Quote:
Nick 'The Database Guy' wrote:
Quote:
Help!


Nick 'The Database Guy' wrote:
Quote:
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
  #7  
Old November 13th, 2006, 07:15 PM
Granny Spitz via AccessMonster.com
Guest
 
Posts: n/a
Default Re: Opening and closing the relationship window from code

Nick 'The Database Guy' wrote:
Quote:
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

  #8  
Old November 14th, 2006, 12:55 AM
Stephen Lebans
Guest
 
Posts: n/a
Default Re: Opening and closing the relationship window from code

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'" <nickmcm@btinternet.comwrote in message
news:1163444091.247546.130480@b28g2000cwb.googlegr oups.com...
Quote:
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:
>
Quote:
>Nick 'The Database Guy' wrote:
Quote:
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
>

  #9  
Old November 15th, 2006, 10:15 AM
Nick 'The Database Guy'
Guest
 
Posts: n/a
Default Re: Opening and closing the relationship window from code

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:
Quote:
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'" <nickmcm@btinternet.comwrote in message
news:1163444091.247546.130480@b28g2000cwb.googlegr oups.com...
Quote:
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:
Quote:
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
  #10  
Old November 15th, 2006, 12:55 PM
Stephen Lebans
Guest
 
Posts: n/a
Default Re: Opening and closing the relationship window from code

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'" <nickmcm@btinternet.comwrote in message
news:1163586984.204176.320610@k70g2000cwa.googlegr oups.com...
Quote:
>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:
>
Quote:
>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'" <nickmcm@btinternet.comwrote in message
>news:1163444091.247546.130480@b28g2000cwb.googleg roups.com...
Quote:
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
>
>

  #11  
Old November 15th, 2006, 01:36 PM
person
Guest
 
Posts: n/a
Default Re: Opening and closing the relationship window from code

On Wed, 15 Nov 2006 13:16:51 GMT, "Stephen Lebans"
<ForEmailGotoMy.WebSite.-WWWdotlebansdot...@linvalid.comwrote:
Quote:
>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.
  #12  
Old November 15th, 2006, 02:45 PM
Keith Wilby
Guest
 
Posts: n/a
Default Re: Opening and closing the relationship window from code

"Stephen Lebans" <ForEmailGotoMy.WebSite.-WWWdotlebansdot...@linvalid.com>
wrote in message news:YI86h.18857$cz.302272@ursa-nb00s0.nbnet.nb.ca...
Quote:
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.


 

Bookmarks

Thread Tools

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

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over network members.
Post your question now . . .
It's fast and it's free

Popular Articles