Sizes

[Guest]

I have a database, it looks and runs how i want it to on my computer.
when someone else in the office opens it, the look is all wrong.

is there a way that i can set the database to open for 800X600 when the
settings are like that. And open in 1024X768 when the settings are like that?

I am not sure, i have looked into this and I cant seem to tell me if i can
do this.

Thanks in advance

 

[Douglas J. Steele]

There's sample code to do this in Access Developer's xx Handbook by Litwin,
Getz and Gilbert et al (where xx is whatever's appropriate for the version
of Access you're using). You can learn more about their books at
http://www.developershandbook.com/

They've also produced an MDE version of the code that you can download from
http://www.developershandbook.com/downloads.htm and use in your application.

Another option is to purchase ShrinkerStretch from Peter De Baets
http://www.peterssoftware.com/

There's also code at http://jamiessoftware.tk/resizeform/rf_download.html
but I don't really know anything about it.

 

[George Nicholson]

http://www.mvps.org/access/general/gen0002.htm
Provides a link which you can use to download a (free) tool from the authors
of the Access Developers Handbook that resizes forms based on the resolution
they were originally designed in vs the resolution of the current user.

Note to all: I know the ADH website had been down a few months ago. It seems
to be back. I have no idea how old this news may be
http://www.developershandbook.com/

HTH,