Database window size

[gibblin]

Is there anyway of specifying the actual database window (program window) on start-up?
I want to acheive this to avoid problems with screen resolution and want to disable the maximize option so the user can either keep it at the pre-determined size or minimize it.

If anyone can help i'd be grateful.

Cheers.

 

[PHV]

menu Tools -> Startup ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[gibblin]

Thanks for your quick reply, but i haven't explained what i want properly.

I want to specify the size of the actual MS Access window (not the database window where the objects are), so i can fit the whole database into a 800 x 600 screen. Then if the user has a 1024 x 768 screen the actual Access window won't have big blank spaces.

Does this make sense?

 

[hermanlaksko]

Hi

Perhaps this could leed you in the right direction:

DoCmd.RunCommand acCmdAppRestore
Try playing with the DoCmd.RunCommand and see what you can find, it has 1000's of poss.



Herman

They say that crime doesn't pay... does that mean my job is a crime?

 

[gibblin]

Hi, cheers for your reply i will have a look.

However i've thought of another possibility, how about determining the DoCmd.movesize option of my forms depending on what resolution the screen is on start-up?

 

[ZmrAbdulla]

here is Form Resizer from jaimies

Zameer Abdulla
_{Jack of Visual Basic Programming, Master in Dining & Sleeping}
Visit Me

 

[hermanlaksko]

I know that you can find the screen resolution via Kernel32.dll, but I do not know how. I am sorry

Herman

They say that crime doesn't pay... does that mean my job is a crime?

 

[ZmrAbdulla]

Get Screen Resolutionhere

Zameer Abdulla
_{Jack of Visual Basic Programming, Master in Dining & Sleeping}
Visit Me

 

[gibblin]

I'll have a look into them. Thanks for all your help everyone, appreciated.

 

[hermanlaksko]

And it works too - Thx Zameer

Herman

They say that crime doesn't pay... does that mean my job is a crime?