I hope I can explain this clearly.
I have a subform that has a lot of information and I was wondering
if there is a way to make the subform appear as if one turned up the
resolution, thus making it's contents smaller, allowing me to pack more info
in it. I would love to leave the size of the main form alone.
I'm using Access 2000.
The sub form is currently displayed as datasheet.
Hello this is my first post in the definetely best Access & VBA forum on the net and i hope i am in the correct forum to ask this. I would like to know if there is any way in access to change the size of the for my users view according to their screen's resolution. E.g. i am creting the form using 1280 x 1024 resolution and my users have 1024 x 768 resolution how go i make the form adapt to their res. Thanks for any replies :D
how to make my form controls change size / position as my form is resized / loaded on a computer with a different resolution. Several of the tutorials out there suggest putting code on the "on resize" property of the form. When I looked at the Northwind database to try to mimic their code however, it looks like they must be doing something different as there is no on resize code under the form properties and I was unable to find the code they do use.
After a user completes a form, they click a button at the end that uploads the information the back-end database and creates a PDF copy using the DoCmd.OutputTo function. It has been working fine, but one user just had an issue where the form was very zoomed in and cut off. So I have 2 questions:
1) What is the cause of this problem? Is it based on screen resolution?
2) Is there a way to fix the problem to make sure it does not happen?
I created a form which fits to my screen resolution. When I open it through an another computer which has different screen resolution then my form is opening according to my 1st screen resolution.
I wanted to fit the form resolution to the desktop on which it it opening. Is it possible?
How to set the form the screen resolution on which the form is opening.
Hi. I have a main table (with other tables related to it). It has the 255 max number of fields. (I know... But bear with me.)
ANyway, I need to change some field's size to smaller sizes. But if I try to change them, even 1 at a time, I get the cannot do because I have too many fields defined.
Good afternoon. I am brand new to posting on this forum but I have been using this forum for help since I started my new job and I would like to start off with thanking you all for that. :)
Now onto my problem: I am currently trying to create a form in Access 2003 that can be easily read and seen because it will eventually be used as a touch screen interface. I have several text boxes on this form that simply display a counter's value that is updated by a neighboring updown control. The text displayed within the textbox is just the value of the updown control. This updown control is more specifically a Microsoft UpDown Control ver. 6.0 (SP4). Due to this interface ultimately being used as a touch screen, each and every button needs to be large enough so fingers can easily touch only one button at a time.
My problem is that I do not know how to change the size of the actual Up/Down buttons on this updown control. I can alter the height, yet I can not alter the width of these vertically oriented buttons. If anyone knows how to correct this problem, I would greatly appreciate it. The sites I looked through that deal with Visual Basic reference do not deal with resizing the updown buttons, but with other properties of the updown controls. Thank you for your time and assistance.
I'm running MS Access 2003. My SQL editing window has a really small font size. How do I change this window's default font size? Is it in tools or options?
Help!!!!!!! I'm going blind!!!!!!:confused:
Thank you for taking the time to read this and for being willing to help out!!
I have a form that contains a blank text box for each field in a record. Until very recently it functioned correctly for years. Lately data enterers tried to fill a ten character field with five characters (ANNNN format, example X9999). Some records require an entry in this text box, some do not, so their field is left blank. Lately when a new entry is tried in this field, only the first three characters are accepted, blocking character four through ten from being entered. It acts as if the text length for this text box has been changed to three characters, but it is still the correct length in the Properties box.
The system keeps track of clients who have attended a nutrition education class and the form involved is the location the class was taught.
I just bought a new computer. It came with a GIGANTIC (for me) 19 inch monitor.
Here's the question. What resoution should I set the screen to? I make databases for others. If my forms are too big for their monitors they have to use the scroll bars all the time. If my forms are too small it doesn't look professional.
I couldnt find a search facility to see if this had been covered before, so apologies if it has been answered before.
I have created an application in Access (2002) which from the users side of things will start in a form and give them no access to the back end.
Unfortunately, it is entirely possible that different users will have their screens set at different resolutions and so the application will be unusable on some and too small on others.
I was wondering if it was possible for access to automatically resize according to the users screen resolution.
I have searched the MS Knowledge Base and help files etc, but I think it is looking less likely that it is possible. Creating 5 or 6 different versions for different screen resolutions would be a none option.
How can I make my DB dectect the users computer screen resolution and adjust my forms and reports to it?
What is hapening is that is I make the DB on 1024/168 and than the user uses 800/600 the forms and reports look huge..... Is there a way to fix this automaticaly?
I have an Append Query that I developed and am wanting to use the SQL View statement in a piece of VBA code that I am writing. The problem is that it is not working.
Here is the SQL View when I am in Query Design View. Code:INSERT INTO tblMasterAccountList ( AccountNum, AcctName, [Account Type], [Billing Spec] )SELECT TEMPAcct.Acct, TEMPAcct.Name, TEMPAcct.Type, TEMPAcct.BillingSpecFROM TEMPAcctWHERE (((TEMPAcct.Existing)=False));
Here is the code I have in VBA... Code:Dim strSQL As StringstrSQL = "INSERT INTO tblMasterAccountList (AccountNum, AcctName, [Account Type], [Billing Spec]) "strSQL = strSQL & "SELECT TEMPAcct.Acct, TEMPAcct.Name, TEMPAcct.Type, TEMPAcct.BillingSpec "strSQL = strSQL & "FROM TEMPAcct "strSQL = strSQL & "WHERE (((TEMPAcct.Existing)=False));"DoCmd.RunSQL strSQL
The code runs fine in that no errors are generated, but it does not append the records. When I run the query outside of VBA, it does append the records. Is there something special that needs to be done with an action query for the SQL statement to work in VBA?
Will keeping your field size shorter result in a smaller MDB file?
Or does Access only use as much space as there is real data in its fields.
Way back in the dBASE III days, dBASE would pad all your "real" information with as many spaces as necessary to fill up your field. I suspect that the MDB structure is probably smarter than that.
Another question on the same topic - I believe there is a maximum number of characters in a record (4000?). Can your field sizes add up to more than 4000, as long as the actual data, all combined, never totals 4000...? Thanks............ ..dc
I am using an unbound object frame to display an .png image file which is set in vba.
The image is an excel chart saved as a .png
The problem I have however is that the image I save from Excel is great quality, and is pretty tack sharp, but when I display the same file in the unbound object frame in access, it is not nearly as sharp.
I am setting the picture property of the control as:
ubImageUserChart = "c: empmyChart.png"
It displays alright, but is just a bit fuzzy - still quite legible, but it is a complex graph with a lot going on - has regressions and formulas etc on the graph, and they need to be very clear.
BTW - the unbound frame is the same size as the Excel chart which gets saved as a .png file. If I tile the images (Access unbound frame and original file in picassa preview) side by side - they are identical - size, orientation etc.
It is not practical for me to try and do the chart natively in access as it is way to complex. I am using access vba to drive an excel session to do all the statistical yack work and chart rendering, then displaying a png image of the resulting chart in an unbound object frame in access.
I am trying to set the form size through VBA code when the form loads. I have autoresize set to No and then run this: DoCmd.MoveSize 100, 100, 100, 100
...except nothing seems to happen. The form is still maximised.
I have not done much work in later version of Access. Now I found if I change a design in one form and similar forms (names are different) which are linked to the same tables got changed as well without openning them up and making changes. Is this something new with Access 2003?
All my popup forms come up at the wrong size. I have popup = yes, modal = yes, border = dialogue box settings. I have tried this with both autoresize on and off. One form comes up to small and one comes up to big. I've tried changing the size of the form in design mode, but this has no effect.
I am writting a database and i am have difficulties with forms.
What i need to do is have one form (Main) maximized and the other windows set to a standard size, the main form is always visible the others need to be opened and closed via buttons on the main form and sub forms.
I am not sure if this can be done so any help would be good.
I have used the docmd.restore when closing a maximized report to keep the form from maximizing... but when I view a data sheet from my form then close the data sheet my form is maximized! Any help out there??:(