Home > Solved Ms > Solved: MS Access Forms And Screen Resolution

Solved: MS Access Forms And Screen Resolution

Not visually, but programmatically set both width, and height of the userform and make controls dependable on the current resolution. All Rights Reserved Microsoft, MS, Office, Excel, Word and Windows are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. Any help on a module code would be appreciated. Jack Pyles replied Aug 24, 2012 Thank you Roy, will check it out. Source

Now if I go into the design view and change it to Thin, I'm back to a larger screen. Note: depending on how many controls you have this may be the best approach but if you have lots of controls on the userform I would look for an alternative. You can achieve that by accessing the current resolution and modifying your Userform_Initialize() event. By Jamie Czernik Jamie Czernik is the webmaster of Jamie’s Software providing downloads, articles and tips for MS Access developers.

The application I am working on will be used on several different computers with several different monitors, some landscape and some old school. Thanks Nov 13 '05 #1 Post Reply Share this Question 3 Replies P: n/a Douglas J. As for the monitors, don't worry about it.

I originally wrote the module, but over the years various developers have sent in their additions and suggestions to further improve and refine it. Even the old four thirds were wider than they were higher, making them "landscape". I think this is the reason why the "Tabbed" documents window option was created. Phishing Email Servers Microsoft Access Email Protocols Email Software The Email Laundry MS Access – Adding “Page ‘x’ of ‘y’” Over a Group in a Report Video by: Jim Learn how

If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members. My computer has a screen resolution of 1400x1050 while others are 1028x768 causing my forms to "overflow" their screens. HELP? http://www.access-programmers.co.uk/forums/showthread.php?t=228359 My application does this.

But lets go back... I try to avoid user sizable forms, I try to design the form to be a good size with our companies I knew what you meant but was just in a funny mood this morning when I go in to work. (giggles evilly) Andrew Top White Papers and Webcasts Popular The MDM Solved: print current record Automatic form generation. I don't understand the homework of my little sister - do you?

Newer Than: Search this thread only Search this forum only Display results as threads Useful Searches Recent Posts More... Are there any tips for preventing a vehicle from being broken into while parked at a trailhead? I mean, if they have a list with 100 items, then they will have to scroll... They are the types of people you feel privileged to call colleagues.

Please start a New Thread if you're having a similar issue.View our Welcome Guide to learn how to use this site. this contact form However, this does require basic VBA coding skills and is recommended for scaling up to a higher resolution rather than down. There was also a post on something similar here on AWF earlier this year - try restricting google to awf. Two of the individuals have lower screen resolutions that makes it difficult to utilize the program as written Is there any way to reset the resolution when the program opens and

I've created an access program that's used by 5 people. I will see if I can find the answer. Browse other questions tagged forms vba ms-access ms-access-2010 or ask your own question. have a peek here This is where MVC comes in very handy and you can distinguish between different components.

Thanks. You can have different views for different devices. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group.

Password Register FAQ Community Top Posters Today's Posts Search Community Links Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find

SHA-1 – Why is it hard to find a certificate collision? opened, which could be several times in a session. Covered by US Patent. As well, some users may require the lower resolution, due to vision problems.

If you're keen and have a good level of VBA knowledge, you can view the code yourself to see exactly how it works and even edit the code to better suit Jack Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Smolin shares insights from his own experience and covers topics you may never anticipate but are vital to success, like pricing, documentation, licensing, and tracking customers. Check This Out If designing your forms at a baseline screen resolution is not adequate for you then you will have to look at scaling your forms using either a third party tool or

The below code comes from here and the original author is DRJ You stick the first part in the Workbook code behind Option Explicit Private Sub Workbook_Open() Call VerifyScreenResolution End Sub True Resurrection ruins plot hooks more hot questions question feed lang-vb about us tour help blog chat data legal privacy policy work here advertising info developer jobs directory mobile contact us The people using 1024 cannot go to 1400 and those with 1400 have no problem. 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).

Please try the request again. A compiled MDE version of their utility can be downloaded from http://www.developershandbook.com/downloads.htm. How to count ActiveX control is printed wrong Solved: Combobox with two columns How to set up a quoted blank in an SQL ststement Solved: Error accessing file.


© Copyright 2017 blightysoftware.com. All rights reserved.