Solved: MS Access Forms And Screen Resolution
Download the report Message Author Comment by:GNOVAK ID: 395244112013-09-26 I would rather not do it with code if I can help it. Entering a new field to start a business leaves many developers unprepared and not even fully aware that it’s something they know so little about. 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 Solved: program expiration code Password Protecting records Solved: Sending Report via E-Mail Solved: Combining Multiple Textboxes Assigning data to text box run .wav application Solved: Adding records in a relational table http://sumolinux.com/solved-ms/solved-ms-access-forms.html
But surprisingly, I was unable to find a single article devoted solely to this topic. Alternatively, is there a way for Access to know which forms to use for each person? Do you think it wiser to use it onload or open? A far more palatable solution is to put in code to resize your forms to match your users' resolution.
Nov 13 '05 #3 P: n/a Jeff Conrad A couple more options to add to the list Doug already provided: http://home.bendbroadband.com/conrad...ormresize.html (Watch out for any line wrapping on that link) -- This site is completely free -- paid for by advertisers and donations. One faux pas that is often made by novice developers is to consider using an API call to alter the user's screen resolution when their application is started.
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 Solved: SQL subquery into Access syntax Solved: Database design Report help MS Access toolbars settings to another PC need help with a query or two Solved: how to create a pie more stack exchange communities company blog Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and I can limit the width my moving the property sheet on the right over making the property sheet wide and the width of my form, the desired size.
SEE THE WINNERS Question has a verified solution. A compiled MDE version of their utility can be downloaded from http://www.developershandbook.com/downloads.htm. He created and marketed his first commercial product in 1969 while an undergraduate at Bradley University, and received a master's in business administration from San Diego State University in 1974. http://www.access-programmers.co.uk/forums/showthread.php?t=228359 I don't know why this happens or how to prevent it.
The download also includes a valuable PDF file providing guidance on using the utility along with a detailed explanation of the processes and calculations necessary to rescale your forms. Manager's Guide to Avoiding 7 Project Portfolio Pitfalls MoreWhitePapers Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Solved: Run Execl Macro in Access Solved: Date in Criteria Debug Help Please help -- read / write to different tables Viewing Access Data in Excel Solved: Close Winword application from ideas? 0 LVL 74 Overall: Level 74 Microsoft Access 72 Message Expert Comment by:Jeffrey Coachman ID: 395246942013-09-26 I agree with the other experts...
If you choose this option then most users will be able to use your application without having to scroll too much and the application will therefore flow much more easily as https://www.experts-exchange.com/questions/28249723/Access-2010-Setting-Popup-Form-size-and-placement.html The Access Developer's Handbook The Access Developer's Handbook is often mentioned in the Microsoft Access newsgroups and comes highly recommended by many developers. Use the pages property to … Microsoft Access Access Desktop Databases – A Quick Tour Video by: Jim What’s inside an Access Desktop Database. After making such revisions, I normally revise something else within the form such as Go to Solution 4 3 +3 6 Participants Jeffrey Coachman(4 comments) LVL 74 Microsoft Access72 GNOVAK(3 comments)
Save it and close. 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. Andrew Thorne replied Aug 24, 2012 Hi, Jack, Hopefully this will get you started. have a peek here As well, some users may require the lower resolution, due to vision problems.
Another way you can size and position the form (if you don't use the AutoCenter property) is by using the MoveSize method in the form's OnOpen or OnLoad event. Anyone have any experience with these, or any other suggestions on how to solve this. ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! I don't understand the homework of my little sister - do you?
In the mean time, can you explain what you want to change with the different resolutions?
opened, which could be several times in a session. ERROR The requested URL could not be retrieved The following error was encountered while trying to retrieve the URL: http://0.0.0.8/ Connection to 0.0.0.8 failed. Alternatively, you can use the below code which checks the current screen resolution, warns the users and asks if the user wants to change his resolution. Thread Status: Not open for further replies.
Short URL to this thread: https://techguy.org/394596 Log in with Facebook Log in with Twitter Log in with Google Your name or email address: Do you already have an account? Rollin Rollin_Again, Aug 30, 2005 #5 Sponsor This thread has been Locked and is not open to further replies. I have decided to go with manual sizing in the form load. http://sumolinux.com/solved-ms/solved-ms-access-database.html Jack Pyles replied Aug 24, 2012 Thank you Roy, will check it out.