Code ?

[Scientific]

Hello all,

I have two forms of different sizes named form10x7 and form 8x6 and both
forms use the same tables and resources. I want a user to be able to select
which size form to open after loggin into the database. Is this possible and
if so how to code this?

BTW, I tried using the resize form software but form elements don't resize
correctly.

-S

 

[Arvin Meyer [MVP]]

I'd use a hidden form after login. Once the user selects the size, just hide
the form instead of closing it. That way you can refer to the form and not
have to reselect the size later. Let's code an option group, called optSize
with 8x6 being option 1 and 10x7 being option 2 (untested):

Private Sub optSize_AfterUpdate()
If Me.optSize = 1 Then
DoCmd.OpenForm "8x6"
Else
DoCmd.OpenForm "10X7"
End id
End Sub

 

[pddxxx]

BTW, I tried using the resize form software but form elements don'tresize
correctly.

Which resize form software did you try? There are several options:

A shareware version of a form rescaling module I wrote called
ShrinkerStretcher is available at this web site: http://www.peterssoftware.com/ss.htm

There's a form resizer at http://www.jamiessoftware.tk/resizeform/rf_jump.html
..

Another one: http://sourceforge.net/projects/modscaleform

The Access Developer's Handbook has form resizing code included:
http://www.amazon.com/exec/obidos/ISBN=0782119417/107-8064361-7403703

You can use code at this page to find the screen resolution:
http://www.peterssoftware.com/c_scrres.htm

Hope this helps,

Peter De Baets
Peter's Software - Microsoft Access Tools for Developers
http://www.peterssoftware.com

 

[Scientific]

Arvin, pddxx

Thanks to both of you for your input. Sorry I didn't get back sooner. I'll
try both approaches and see how things turn out. Will post back and let you
know what happened.

-S