I just change from a 1024x768 monitor to a 1600x1200. Now my database is squished due to the smaller pixel size and it is uncomfortably small. How can I adjust the DB to "fit" the new display, or any other monitor resolution setting.
I have built a few Access DBs and am looking to improve my development skills and attemt to migrate my Access DB to SQL Azure. I find access to be a very powerful development environment to build rapid applications . How to use multiple monitors so that I can display different forms on each monitor from a single Access DB.
Is it possible when loading a control form to set the users default display size to say 1024x768. I'm creating quite a complex form and it will be too large on an 800x600 display.
I have designed a bunch of forms that the user will access through the Switchboard. Things are working fine except that when I deployed the application to a different machine from mine, the forms appear to not display properly in the sense that they are appearing too big and the user needs to scroll horizontally to see it completely (which was not the case in my machine).
So, I just want to know if there is a setting that enables the forms to resize per the machine being dipalyed on or if I should have designed the form within a particular size that ensures that they displayed properly in most machine (fyi, most of my forms had a total horizontal width of about 9 on the horizontal ruler in form design view).
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 have a button on Form1 that when clicked opens Form2. I want Form2 to be a certain size everytime it opens. I can't seem to get this to happen, it always resizes depending on Form1 being maximised or not.
I need to make the text size smaller to fit everything on the screen (users use 17" monitors..). I have gone into each form and subform and changed the text size for each text box to 9, but when I view them in form view the size has not changed ?
Also .. is there any way to make the autocentre option actually work as it's name suggests !! ? it does in most cases centre horizontally, but never vertically, quite often putting the top of the pop up form over the ribbon bar.
I would actually like to be able to totally remove the ribbon bar so that only the database forms are the only thing the user sees.
I vaguely remember being able to do this in Access 97 (Which was the last version I used - a long time ago !) but this seems to be more difficult in 2010 version.
When I open a Form, it appears in the proper size. Then, I go and open a Report, which is a DoCmd.Maximum on open. This works well. The report is enlarged. Now, when I go to open a form, the size of the form is max. I tried Borderline dialog, fit window, DoCmd.MoveSize, and a couple of other things, but I cannot get those forms to keep their original size-they blow up! How can this be accomplished?
When I open a Form, it appears in the proper size. Then, I go and open a Report, which is a DoCmd.Maximum on open. This works well. The report is enlarged. Now, when I go to open a form, the size of the form is max. I tried Borderline dialog, fit window, DoCmd.MoveSize, and a couple of other things, but I cannot get those forms to keep their original size-they blow up! How can this be accomplished?
I have one form "Products" that I have a button on which opens up another form. The second form lists a different number of lines depending on how many items are in a group.
The problem I am having is that I can not make the second form shrink or grow depending on how many line items I have in each group. Currently, I have to make the form as large as the most possible lines I could have (which is 19) but sometimes I might only have 5 lines in a form.
I have a subform that shows notes entered but if there is more text in the field then you cant see it all. Can I make it so that this field will grow so the whole input is visible or can I make it so when you click on it it opens in a larger window showing all the txt?
I am having issues with a split form which modal and emergent (pop-up) properties are set to yes. When I open it, it is maximized or out of the size I had setup; although I saved it trying to "freeze" the height and width.
It has been a month and I'm still 'stuck' on my Microsoft Access lessons due to a peculiar error. I have a video of the error, but it won't let me post a link until I have 10 posts. When I create an action button and then scroll at all, the button jumps in size 50% to the right and down, but this extra space can't be edited. Clicking on the 'extra space' is like clicking the background.
I have tried
1. Reinstalling Office 365 2. Reinstalling my graphics card drivers (Using a GTX 560ti SLIx2) 3. Manually entering the size for the buttons in the button properties (still increases in size)
I have a project where the schedule calls for a web-enabled database for 100+ users to merge five separate systems into one. If I can't get past this problem, I can't continue my lessons.
I am relatively new to using MS Access 2010. Some fields which i have set up as Memo fields to take report comments. Is there anyway to make the size of the memo field box variable to fit in with the text in the form when viewing in htis mode?
When I create a form in design view and then open it, the form fills the whole area. The Fit To Screen property is set to No, and Auto Resize makes no difference no matter what it is set at.
How can I reduce the form size (so it looks like an Excel form)?
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 have a form to input data into a table1. On the form I have a combo box to read from a next table exchange rate to input into the table1. Field in Tablet for the exchange rate is set to Field size double, Format currency, and decimals 6.
I am unable to set the field size on the form to read the 6 decimals. The combo box is set to Currency decimal 6. I tried General Number and it still only shows only one decimal.
I have a datasheet on a form that is unable to show all records in the size allowed. Consequently it has a vertical scroll bar. However, the scroll bar allows scrolling to the bottom whereby there is white space almost the same size as the data records. The horizontal scroll bar does much the same.
Is it possible to just show the records and only the width of the data in them.? No extra records exist in the table to cause this.
I am trying to create a new macro in my database. I selected the Openform action and tried to choose the name of the form but when I try and select the name of the form from the dropdown menu, I receive the following message: THE SEARCH KEY WAS NOT FOUND IN ANY RECORD.
I am not able to see any of my forms on this dropdown menu.
Can anyone please help. I am using Microsoft Access 2002.
I have created a table in Access 2000 that contains among other things, hyperlinks to .txt files. This is a CD database, and the hyperlinks link to .txt files (local) containing track listings. I have designed a form that displays each record (CD). I can get everything to display except the hyperlinks. How do I tell Access (w/VB) to AUTOMATICLLY display these .txt files (w/o prompting) as users scrolls through individual records? I don't want to manually enter the paths, and I don't want to have to click the hyperlink to display it. Just like the other fields, I would like them to display w/o prompting. Any help would be greatly appreciated.
I have two table data base (Patient Info) + (Referral Info) with one to many relationship.I devised a form to display patients information and their mental health diagnosis. On my referral form (subform) I have I have list box facility with various possible diagnosis. What I want to do is ... if the user selected "Dementia" from the look up/list box...
I want to display a Butterfly next to the patient's name (Main form)
(1) I don't want the picture to be in C drive rather I want the picture to be part of the database
(2) How can I put the conditional display (if Diagnosis is = "dementia" then Butterfly)