Programmatically sizing and positioning Access Database Window?

Question

Can anyone tell me how to programmatically size and position the Access Database Window?  I'm referring to the object in this image, inside the red rectangle

I have seen a few articles and downloads that show how to size and position the Access Application window, as well forms, but nothing showing how to size and position the object in the picture.  Please explain if you know how or point me to any articles or sample apps that show how to do it.  Thank you

Answer 1

A.Stanton wrote:

Can anyone tell me how to programmatically size and position the

Access Database Window? I'm referring to the object in this image,

inside the red rectangle 

<http://img258.imageshack.us/img258/5764/clip1.jpg>

I have seen a few articles and downloads that show how to size and

position the Access Application window, as well forms, but nothing

showing how to size and position the object in the picture. Please

explain if you know how or point me to any articles or sample apps

that show how to do it. Thank you   

e.g.

'set the focus to the database window by pretending to select a table

DoCmd.SelectObject acTable, , True

'use MoveSize to set position and size of the db window

DoCmd.MoveSize 500, 500, 3000, 3000

---

cu

Karl

*******

Access-FAQ (German/Italian): http://www.donkarl.com

Answer 2

A.Stanton wrote:

I just meant suppose the current selection is like in this image:

<http://img408.imageshack.us/img408/3749/clip1j.jpg>

Any way to get back to this after running your code? I'm guessing

not but thought I'd ask.

Hmm, the first line of code i've posted

DoCmd.SelectObject acTable, , True

is ment to set the focus to the database window.

If you are already there as in your picture, you don't need this line

but only the other one with MoveSize.

---

cu

Karl

*******

Access-FAQ (German/Italian): http://www.donkarl.com

Answer 3

I just meant suppose the current selection is like in this image:

Any way to get back to this after running your code?  I'm guessing not but thought I'd ask.  Thank you

Answer 4

A.Stanton wrote:

Thank you Karl. Know a way to detect where I was when I issue those

commands? So that I can return to tab I was on? Otherwise, no

sweat, it works great. 

I'm not sure what you mean with "return to tab I was on".

In a form or report module you can always use

Me.Name

to detect the object's name. Other methods are e.g.

• CurrentObjectType and CurrentObjectName
• Screen.ActiveForm or Screen.ActiveForm.Name
• Screen.ActiveControl or Screen.ActiveControl.Name

---

cu

Karl

*******

Access-FAQ (German/Italian): http://www.donkarl.com

Answer 5

Thank you Karl.  Know a way to detect where I was when I issue those commands?  So that I can return to tab I was on?  Otherwise, no sweat, it works great.