dialog box size

[Guest]

I have made several small tables that I will use for pull downs, various
lists and things. I am continually resizing these dialog boxes to make them
much smaller in order to see several at the same time. They always seems to
return to their original size when I reopen these tables. How to I make them
stay the size I resized them to?

Thank you

John

 

[Guest]

What are these "dialog boxes" you are talking about? Something in your
tables? On forms?
Tables shouldn't have "dialog boxes", so if you are talking about resizing
columns, I would think changes in width do get saved automatically - the
program asks you if you want to save the changes when you try to exit.

 

[Guest]

When you open a table, you view it on a dialog box. I want to be able to
control the size of this box. It may just be a windows thing instead of an
Access thing. I hope this is clear. Is there a way to post screen shots? I
could put a screen shot out here and you would see what I am talking about.

Thanks

 

[Douglas J. Steele]

You should never be working directly with tables. Forms are how you interact
with the data.

Create forms and size them as you want.

 

[Guest]

Oh, you are talking about the window where you can make tables, queries,
forms, etc?

In that case you can write a macro that executes whenever you start your
database, ie. an autoexec macro.
Create a new macro, and in the Action pane, select MoveSize. Then at the
bottom of the screen you can specify width and height [in inches, or cm, or
in whatever unit of measurement you use], as well as position of the top
left corner of your window [also in inches, cm, or whatever you might be
using].
When you close the macro window, you'll be prompted to enter a name. Call it
"autoexec" [without the " "] and you'll be set.

Does this answer your question?

 

[Guest]

I think that will do it. Thank you very much. I am very new to using Access
so I am starting a very small DB and working up from there.

Again, thanks

John

Oh, you are talking about the window where you can make tables, queries,
forms, etc?

In that case you can write a macro that executes whenever you start your
database, ie. an autoexec macro.
Create a new macro, and in the Action pane, select MoveSize. Then at the
bottom of the screen you can specify width and height [in inches, or cm, or
in whatever unit of measurement you use], as well as position of the top
left corner of your window [also in inches, cm, or whatever you might be
using].
When you close the macro window, you'll be prompted to enter a name. Call it
"autoexec" [without the " "] and you'll be set.

Does this answer your question?

When you open a table, you view it on a dialog box. I want to be able to
control the size of this box. It may just be a windows thing instead of an
Access thing. I hope this is clear. Is there a way to post screen shots? I
could put a screen shot out here and you would see what I am talking about.

Thanks

 

[Guest]

Well, yeah, I understand but one of my tables is a very simple yes or no
thingie and I want the window it's in to be relatively small. In this case I
think it's much better manipulating the database (table) directly than to
create a form to interact with it.

Thank you for your input,

John

 

[Douglas J. Steele]

Sorry, I don't agree. It's never appropriate to work directly with tables.

 

[Rick Brandt]

I think that will do it. Thank you very much. I am very new to
using Access so I am starting a very small DB and working up from
there.

While Table Datasheets don't "remember" their position and size, Query
datasheets do. Just create a SELECT * FROM TableName query and use that
instead.