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

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.


"ChessNut" wrote:

> 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

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

"Niniel" wrote:

> 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.
>
>
> "ChessNut" wrote:
>
> > 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

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

Create forms and size them as you want.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"ChessNut" <(E-Mail Removed)> wrote in message
news:EED7CEA8-30B3-483C-AAEC-(E-Mail Removed)...
> 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
>
> "Niniel" wrote:
>
>> 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.
>>
>>
>> "ChessNut" wrote:
>>
>> > 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

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?

"ChessNut" wrote:

> 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
>
> "Niniel" wrote:
>
> > 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.
> >
> >
> > "ChessNut" wrote:
> >
> > > 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

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

"Niniel" wrote:

> 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?
>
> "ChessNut" wrote:
>
> > 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
> >
> > "Niniel" wrote:
> >
> > > 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.
> > >
> > >
> > > "ChessNut" wrote:
> > >
> > > > 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

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" wrote:

> You should never be working directly with tables. Forms are how you interact
> with the data.
>
> Create forms and size them as you want.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "ChessNut" <(E-Mail Removed)> wrote in message
> news:EED7CEA8-30B3-483C-AAEC-(E-Mail Removed)...
> > 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
> >
> > "Niniel" wrote:
> >
> >> 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.
> >>
> >>
> >> "ChessNut" wrote:
> >>
> >> > 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
>
>
>

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

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"ChessNut" <(E-Mail Removed)> wrote in message
news:B75B6294-ED2B-4EA6-84A4-(E-Mail Removed)...
> 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" wrote:
>
>> You should never be working directly with tables. Forms are how you
>> interact
>> with the data.
>>
>> Create forms and size them as you want.
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no e-mails, please!)
>>
>>
>> "ChessNut" <(E-Mail Removed)> wrote in message
>> news:EED7CEA8-30B3-483C-AAEC-(E-Mail Removed)...
>> > 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
>> >
>> > "Niniel" wrote:
>> >
>> >> 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.
>> >>
>> >>
>> >> "ChessNut" wrote:
>> >>
>> >> > 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
>>
>>
>>

ChessNut wrote:
> 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.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com