Newbie needs help.......again (1 Viewer)

[philbennison]

i have recently changed by table. deleted 20 column that contained yes / no answers. The reason i have doen this is that by fill was getting big. When i deleted these columns the size of the database stayed the same. do i need to purge it ???
can anyone help me again please


Phil

 

[MStef]

Hello philbennison!
Lern something about COMPACT database.

 

[philbennison]

another question ??

Got it thanks for that. One more question how do i set a form / table / switchboard, to open up maximised ??>

any ideas

 

[Jonathan Kok]

Use the 'on open' event to maximize the form via code. The code is:

docmd.maximize

That easy.

 

[philbennison]

where

Where do i find the on open command ??

 

[Jonathan Kok]

With your form in design mode, RIGHT-click on a blank area(DARK grey, outside of the grid area) and select 'properties'. This will take you to the FORM properties. Go to the 'Event' Tab, and you'll see the On Open function. Click the little '...', it will ask you to choose a builder, select 'Code Builder'. The VBA editor will open, type in your command (docmd.maximize), save it, run it.

HTH

 

[philbennison]

thanks

Thanks ever so much. what would i do without you guys

phil