Whilst at college was positive there was some coding, to automatically re-size the form when opening?? can anyone help with this, have spoken to a few people and they say to change in design view but i am finding this annoying. Any help would be appreciated.
I have a subform that I use in a few different ways on my database. It has a comment log with a memo field for people to insert their comments. The struggle is some can be long some can be short. Is there any way to have each record height adjust to the length of the memo?
If it cannot be done for the subform in regular use, my main concern is having it formatted for reports that are generated for clients.
I clipped and attached an example from a report. Its not the best example but the extra column height is adding additional pages to my report to accommodate one long comment.
I would likw for my first and last name fields width to match the length of the name. So if the last name is Smith then the field width will resize itself to fit perfect fit the name. Then if I have a last name of Connor then it will grow to fit it perfect. I dont need this but it will be nice so everything looks a bit nicer an cleaner. I thought the following would have worked:
I can't get my columns on a form to resize and have the rest of the columns move along with it. So e.g. if I have a form with headers and under that a couple of records, I want to resize the middle of three columns. If I select the column and then select, with shift, also the column header, I can resize the column. But the column on the right side doesn't move along with it. So I have to reposition every column after the resized one.How can I get Access to pick up that I want to move the other columns too?
Hi grus!!! I have my switchboard that when opened it looks like pic "switchboard 1" when I use the menu to open and then close any form my switchboard appears like pic "Switchboard 2". I have the code maximise on the on open event of the switchboard. Do you have any idea on how to get back the switchboard as on the first pic?? Thanks to all Declan
I have been running 2003 on XP SP2 for some time but a couple of days ago I needed to do a 'detect and repair' on Word but without resoring defaults. When I opened Access, the Properties Window was back to its default (small) size and couldn't be resized. An uninstall/reinstall made no difference.
Has anybody got any idea what might have happened and what I can do to put it right? I usually have it the height of the screen and this is driving me nuts!
Ok, this seems really lame to have to post this but in Access2007 none of my form or table windows have Mininize, Maximize, or the ability to resize. There is a Close X but nothing else. Being used to Access2003, I am used to being able to resize the windows or at least minimize them. The properties panel has control for these items but they do not appear when I set the properties to yes.
Hi Everyone: Just wondering if there's an easy way in Access 2000 to resize listbox columns if necessary to show all information - like you can in a table by clicking, or by the columns autoformatting. Thanks for your help.
The clients use this app with their monitor resolution set to 800 x 600. Whenever I edit a form I need to set my screen resolution to 800 x 600 to make sure the form is within bounds.:mad:
I wan't a fast way to set the Main Access Window's size too 800 x 600 pixels.
Application.DoCmd.MoveSize(,,800,600) is supposed to work but I get a syntax error.
Hey guys, I know how to maximize a form when it opens, but I was wondering if there isn't a way to actually shrink down the Access app window to specified dimensions when it opens the form? I'm trying to write a dimension-specific app, so there is no distortion what-so-ever. thanks!
I can't seem to size any of my charts to 100% of their object's size. I've attached screen shots of a chart in Design View, the chart properties, Chart Design View, and Print Preview. I've tried all of the Size Mode options.
I have seen and created combo boxes that resize when clicked to fit the size of the data inside. That is, the bound column might be a small string, like a in-house code (i.e. "aa", "ab", "bb" etc), but the combo box, when opened, expands to show the code in one column and the definition of what that code actually means in another to be all user friendly like.
I am trying to do this again, but I can't seem to get the box to expand when clicked. I have looked at a form where the box does expand, checked the settings (there was no code behind the other (sub) form), but I can't see why that combo box gets bigger and mine won't. I googled and for some reason can't find the answer to this question. It must be something obvious. What's going on?
I should just make the column larger, but this was requested to be added to a form after the fact, and everything would just be... nicer if I could get it to behave this way.
Under Current Database, I have "Overlapping Windows" checked. When I open a table, it opens to pretty wide. Then I resize it so that it takes up less space. After resizing, whether I click Save or not, after closing, then reopening the same table, it opens back to its original size (very wide), instead of opening at the smaller size that I resized the table to.
Is it possible to resize a table, and get it to open at that size next time you open that particular table?
I am creating a database and need to produce a report that will form an itemised quotation.There can be up to 8 items on the quotation along with their associated costs to the customer. I am trying to make the "item" field dynamically expand if necessary when longer text is entered into it and then expand the corresponding "Totals" fields to match the new size.I have tried using the "Can Grow" property however for some reason the formatting does not cascade down to the fields below and the "Totals" fields remain the same size.
To try and explain better I have included a screen shot of the relevant part of the report and how it looks when printed. I should point out that the "QuotesQuote" box at the top of the screen is set to "Can Grow" and when that expands the boxes below automatically move to accommodate this.
Any way to copy files from a camera, to a new location using the dialog window and then resizing them before they reach there new destination. The selecting and copying them works fine, but I cannot find a way of resizing them in... or after the copying process.
I have created a report that includes 4 subreports. The subreports are displaying survey results from 4 different survey channels. New survey data is added to the tables monthly so the subreports will grow in size. Is there a way to have the subreports automatically resize and push down the subreport below? Currently what is happening is a subreport will grow and the additional data disappears underneath the next subreport. Is there a better way to create a report that displays information from multiple reports that will change in size?
I have a report, in which i have a unbound text box i want to control the size of the text box as actual characters means,
if the word is in box is elephant so in report it show complete word then next and if the word is small like cat then it resize then the other word next to cat comes automatically at normal space by auto resizing of text box ..
i have a database file that holds 1 inventory table.
Then i have 2 other database files that represent 2 retail stores.
my problem is that the store files have a form which acts like a sales invoice. The sales order number is an autonumber. this worked fine in the past with local network setups, but now going to a server the issue is that the sales order numbers cannot be the same from one store to the other. Since its related to the inventory table it steals the invoice from one store to the other..
i tried formatting the autonumbers differently.. like /100 on one and /3000 on the other. And they are still the same autonumber anyway.. the format doesnt mean much other than a different display..
is there a way to control the auto numbers to be in a specified range of numbers...
i would like to be able to say for store 1 the sales order numbers can only be from 1000-5000 and store 2 6000-9000...
I am releatively new to using Access. I have a form created and linked to tables. I would like to know if there is a way to have the form automatically tab to the next field for me. I have several fields that have the same number of characters entered for every record. I would like it to jump to the next field once I've entered the maximum number of characters in that field. I tried setting the fields in the tables to the length I want, and it does stop me from entering any more than that in the forms, but I still need to press the tab key. Kind of annoying after a while. Anyone know how to do this? THanks.
I'm looking for help with auto-fill (more specifically, I believe I need to use the "After Update" function.
What I have is an order form where I will be putting customer orders. I have a form and a subform, and the line items for the actual order go in the subform. Therefore the subform has a combo box for "products" which references the "products" table by fetching "productname" through "productID"
What I need to happen is when I select a specific product in that combo box (which works), I would like the "price" to be auto-filled into the "Price" box I have to the right of "product" and "quantity"
However I can't figure this out for the life of me, and I've searched places and tried different things, but I always end up with it not working. I can do this in Visual Studio with a DDL and a Label and a small function, but Access is way different from what I can tell with my little knowledge.
I have quite a few forms and reports in a database that are pop-up and modal. I've also auto centered them so they do not jump all over the screen. However, these forms and reports are centering when you open them but move whenver you close them. I am hiding the database window, which usually means that it minimizes to the upper left corner of the desktop screen. These forms then wind up closing or relocating to where the minimized database window is. Is there any way to fix this problem so that the users see centered forms and reports every time they are using the program?:eek: Thank you
I have a form for my customers where i also fill in the email adresses, know i don't wan't to fill in the hole email adres each time. I have seen a acces database before that gives a list when you typed the @ sign in the email adres field.I know that the builder used a tbldomain for listing al the domains that the putin the database. and each time you tab to the field emailsadres you begin to type
example.. markrutten@ and when you type the @ there popup a list of the table [tbldomain] en you begin to type for example Hotmail.com but you can hit the entrebutton afther the letters hot because the match of Hotmail.com is already in the field.
I am trying to develop a form in the light of budgeting, therefore, I am designing a form with all possible options being an accountant I can think (it just a try nothing else)
Now here's the scenario
Fiscal Year Period Month Working days
Period - Month - working (are my heading) 1 - Jan - 22 2 - Feb - 18 and so on
This is what I am trying to learn, if I select period 1 "Jan", application/code fill -out remaining months automatically, e.g. Period 2 "Feb"; Period 3 "Mar" .....
and if I select Period 1 "Mar", then period 2 "Apr", Period 3 "May" ......
Currently, I am using combobox, but problem is, if I selection period 1 = "Jan", then I am unable to restrict period 2 using "JAN" as both combobox are separate.