Can you close the relationship(s) window programatically?

[Nick 'The database Guy']

Hello People,

Is it possible to close the relationship window programmatically?

If so how?

Thanks in advance.

Nick

 

[Rick Brandt]

Hello People,

Is it possible to close the relationship window programmatically?

If so how?

DoCmd.SelectObject acTable, , True
DoCmd.RunCommand acCmdWindowHide

 

[Nick 'The database Guy']

Hi Rick,

Thanks Rick, but I meant the relationships windows where all the
relationships are graphically displayed, rather than the database
window.

Nick

 

[Rick Brandt]

Hi Rick,

Thanks Rick, but I meant the relationships windows where all the
relationships are graphically displayed, rather than the database
window.

Sorry, I looked right at the word and saw something else.

 

[Nick 'The database Guy']

Good effort though!

Sorry, I looked right at the word and saw something else.

 

[Nick 'The database Guy']

Anyone else wanna have a go?

Good effort though!

 

[Keith Wilby]

Anyone else wanna have a go?

Why would you want to do it? The relationship window is for the developer,
shirley? ;-)

Keith.

 

[Stephen Lebans]

There is code in the RelationshipWIndow solution showing you how to obtain
the Window handle. You would than simply send a WM_CLOSE message to the
window.
http://www.lebans.com/saverelationshipview.htm

A GoogleGRoups search in the Access NG's for WM_CLOSE would yield the
SendMessage/PostMessage declaration and how to call this function.
--

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']

I know it is I just want to close all windows that are open, and before
you start I know that the relationships window should never be able to
be opened by a user, just don't ask! This project is a bit of a
nightmare.

Nick