UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Auto sizing forms to fit all screens ........    
 
   
softspizzle
post Apr 7 2010, 08:26 AM
Post#1



Posts: 36
Joined: 6-April 10



I am having issues where my form size is different per user depending on there screen size. Is there a way to make the form fit any screen? Auto size or something? If you could help I would appreciate it.
Thanks,
Go to the top of the page
 
Jack Cowley
post Apr 7 2010, 09:06 AM
Post#2


Retired Moderator
Posts: 37,716
Joined: 11-February 00
From: The San Francisco Bay Area


Take a look here. Peter's Software has a resizer program, but it is not free.
th,
Jack
Access MVP 2008-2010
Go to the top of the page
 
RAZMaddaz
post Apr 7 2010, 09:33 AM
Post#3


UtterAccess VIP
Posts: 9,582
Joined: 23-May 05
From: Bethesda, MD USA


Design the Form so it is a little smaller then the smallest monitor in the group of User's who will be using the Form. Then do an "On Open" Event and enter the following:
oCmd.Maximize
This will enlarge the Form to the size of the User's monitor when the User opens the Form.
Go to the top of the page
 
softspizzle
post Apr 7 2010, 11:52 AM
Post#4



Posts: 36
Joined: 6-April 10



I tried the DoCmd.maximize for the form and I got an Error. "Microsoft Office Access cant find the macro "DoCmd."
That am I doing wr
Go to the top of the page
 
Jack Cowley
post Apr 7 2010, 01:30 PM
Post#5


Retired Moderator
Posts: 37,716
Joined: 11-February 00
From: The San Francisco Bay Area


DoCmd is VBA code. In the event double-click in the Event field and you should see "[Event Procedure]". Select that then press the button to the right to open the code editor. The cursor will be flashing between two lines of code. Enter the DoCmd code there then close the code editor.
th,
Jack
Access MVP 2008-2010
Go to the top of the page
 
RAZMaddaz
post Apr 7 2010, 01:43 PM
Post#6


UtterAccess VIP
Posts: 9,582
Joined: 23-May 05
From: Bethesda, MD USA


Thanks Jack! I got a little busy, so I didn't see the response.
AZ
Go to the top of the page
 
Jack Cowley
post Apr 7 2010, 01:48 PM
Post#7


Retired Moderator
Posts: 37,716
Joined: 11-February 00
From: The San Francisco Bay Area


RAZ -
just go back from the barbershop and there was the post so I went for it. Glad you are not ready to rip my throat out for jumping in.... <
Jack
Go to the top of the page
 
RAZMaddaz
post Apr 7 2010, 01:53 PM
Post#8


UtterAccess VIP
Posts: 9,582
Joined: 23-May 05
From: Bethesda, MD USA


Your hair looks great, much better than before!!!!
How what makes you think I would ever want to rip your throat off for assisting me? evilgrin.gif
Go to the top of the page
 
Jack Cowley
post Apr 7 2010, 02:13 PM
Post#9


Retired Moderator
Posts: 37,716
Joined: 11-February 00
From: The San Francisco Bay Area


Even if my hair looked worse I don't care because it was driving me nuts! Now I can drive with my head out the window and know that my hair will still look good when I arrive at my destination...
hroat-rippers are easy to spot...
Jack
Go to the top of the page
 
softspizzle
post Apr 7 2010, 02:30 PM
Post#10



Posts: 36
Joined: 6-April 10



Worked like a charm .. thanks...
Go to the top of the page
 
Jack Cowley
post Apr 7 2010, 02:37 PM
Post#11


Retired Moderator
Posts: 37,716
Joined: 11-February 00
From: The San Francisco Bay Area


Glad to hear you got the code working!!!
Sorry about that extra drivel between RAZ and myself, but we are trying to maintain or sanity...
Continued success with your database.
Jack
Access MVP 2008-2010
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    23rd May 2019 - 07:56 AM