I have a db app that has all forms maximized continually (I have set the vba code to do so on Open, Close and GotFocus events). From my app Home Page form the user can browse to other forms in the db. When another form is opened the window automaically maximizes. However, when the user navigates back to the Home Page it goes in restore mode. I haven't told it to do this anywhere. I have also tried saving the form stretched out to fit the full screen, so that if it goes into restore mode it at least still fills the screen, but it still reverts to a restored window (about half the screen). It doesn't matter what configuration I use in the AutoResize, AutoCenter properties either.
I have been developing custom db apps in Access for over 8 years. However, this seems to be a stupid (albeit simple) problem that is annoying me. I currently use Access 2003 and this issue is new (or so I believe since I never ran into the problem in previous versions).
I'm using overlapping forms in my Access 2010 database.
When the form(s) open I want them maximized and I don't want the restore buttons to be available.
I have the Min Max Buttons set to None.
I have DoCmd.Maximize in the On Load.
I want the border style set to thing.
Is there any way to prevents the Restore button to be enabled?
I open the first form it's maximized as per the DoCmd.Maximize in the On Load. I then open another form (which has nothing to do with the first form) and it opens maximized. When I close the second form the first form is no longer maximized, it's restored.
I have several subform tabs and one that I have updated no longer shows up when I run the form on Form mode. The tab is there but no content or details of the subform
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.
On this form I have a button to open another form, this works fine. On the second form I have a button to close the form. When I press this it closes, and the first form is still there which is what I want, but somewhere along the line it has unmaximised itself and is about half the desired size. Basically I want it to stay Maximized the whole time it is open.
The way I can think to get round this is to close and re-open the forms as I navigate through them but just wondering why this is occuring?
Thanks if anyone can offer a suggestion, I cannot find a similar problem described on the forum.
I have a form which runs at startup maximised. Pop-up and Modal are set to 'NO', Auto Resize and Center are also set to 'NO', Border style has been set to various settings, and Moveable has also been tried at 'YES' and 'NO'.
A command button on this form opens another form with the same settings which I want to take the original form's 'place' in the application window.
This all works fine, just that when I close the second window (using DoCmd.Close), the original window is then no longer maximised underneath it. I want to make sure certain windows are maximised at all times.
I know I could hack this with a DoCmd.Maximise somewhere, (or by switiching to full Pop-up/Modal mode and hiding the Application window) but the results of these are all a bit of a hack.
Can anyone shed light on the mysteries of Access's default form maximisation behaviour?
Or does anyone do what I have described successfully?
I have a front end that I have distributed to four users. The front end sits on a shared drive and when I make design changes I just replace it and have the users copy it over to their desktops.
I set up a main menu for them to access the various forms, reports, etc. When I first open the front end on my desktop the main menu form is small and not taking up the entire screen. I put the cmd.maximize command in the on open event and still does not maximize the form when I open the database. I tried to size it and saved changes but still not working.
I just did a share session with a user and she opened the form and it was maximized on her desktop.
This is probably very simple and I am wasting time on it so I thought I would ask for a quick fix.
I have a form "Standby" that minimizes when a buton is pressed to open a second form "Filter." This works great. I want the "standby" form to restore to it's original size when I close the "filter" form.
I have tried several options the last being: under the on close event
Private Sub Form_Close() Forms!standby.Restore End Sub
Greetings all. I've got a minor housekeeping issue with my db that I can't seem to crack.
The db opens to the main form, which has a boat-load of control buttons that open a variety of forms and reports and 1 query.
The problem is that when you select the button that opens the simple query, the query opens in maximized view and then when folks want to close it, they often end up closing the whole db, instead of just the query. (Using the right corner X.)
I'd like to open it about half screen or so, to avoid the accidental closing of the whole database.
I can open the query directly or from the macro and in both instances it opens up the correct window size. But when I use the button it opens maximized.
I've searched the code, can't find any reference to maximize. Can't find anything in the button properties that would cause it.
Any idea why this is happening or how to get around it? It's probably something simple, but then, so am I. (hehehehe)
I want to load switchboard in maximum view only, but all other forms in a popup like format. I have the Swithboard_On-Load, docmd.maximize, but when I select a menu item from switchboard that form opens in max-view. If I make that form Popup=Yes, it works, but then any command button [printview] will bring up a form behind the "popup" form. How can I get just the switchboard to stay in max-view only?
I don't want to have to modify all forms and reports so that "popup"=Yes
This is such a newbie question I realise, but I have a form (frmFOBEntry) with a combobox (cboMarketCode) which returns a list from tblMarketCode.
New records are added to tblMarketCode using a form frmMarketCode
When I look through the combobox on the first form if the MarketCode I want is not there I want to be able to click a button which will open frmMarketCode in add mode.
Have looked through the forum and found all manner of flash ways to open on to certain records and the like, but nothing that simply opens the form so you can add a new record.
Also, if I add a record will the combobox update automatically?
I've created a form with Record Navigator which allows a user to create a new record. When the form is opened how do I immediately put the user into add mode by default?
Have a question on the switchboard choices I've always wondered about. Why are there only "Add" and "Edit" modes to open a form from the switchboard? I see many, many times when you want to allow a form to be opened in "readonly" mode to page through records but not allow edits or additions. Why does Access NOT have "Readonly" as an option?
I have two related forms.One is a list of transactions and the other is used for both inquiry and adding new transactions. If the Inquiry form is just sitting in Add mode and the List form tries to open it in Edit mode, it won't open. Is there a way I can tell from the List form that the Inquiry form is in Add mode and either close it or tell the operator about the issue?
I have an application where I have developed a tabbed user input form with several tab pages to populate several tables with data using the master/child linking philosophy. There is one subform in particular that has two combo box fields that are related. I have them both set up to display value choices based on an undelying query. I want to restrict the scond box's choices based on the choice made in the first box and have written the following code to be applied after the first combo box is updated.
Private Sub RteGroup_AfterUpdate() Form_Routing.OpType = Null Form_Routing.OpType.Requery Form_Routing.OpType = Form_Routing.OpType.ItemData(0) End Sub
This effectively limits my second combo box choices based on the selection of the first box. It works fine if I run the subform individually but if I run it as part of the master form in tabbed mode I get an "Enter paramter value" dialog box asking for the value of the first combo box. it appears the requery is not functioning under the tabbed mode.
I am writing a program that allows users to enter customer info and I want to be able to pop up a window that will search for Postal (Zip) codes using the Postal Service URL. (I would like to position the popup so that the contents of the Address and Postal Code fields are still visible on the form). I would also like to know if there is a way to copy the contents of the Address Field in my program to the Windows Clipboard, using VBA code, so that I can paste it into the Postal Code Finder without highlighting the field contents and pressing Ctrl-C.
When I access the form the column caption is "txtHours" !
As you can expect it looks ugly.
So to get a decent caption like "Hours" I am forced to set my textbox name to "Hours" !
As you can expect it goes against my coding standard to do that.
Beside I want the caption of some textboxes to include some non-standard letters such as `é' è' '!' ' ' etc. and if I put those in the textbox name it ruins the visual basic code !
I have put much time in designing a form. After exiting and saving it, I cannot now open it. Only the Page Header shows, and I cannot get into 'Design' mode. I have tried repairing and compacting to no avail. Any ideas?
I have a button using a macro to open a form in Hidden mode. Then I have another button on another form to open this form that was hidden.
When I open the form, the form is virtually blank apart from the form caption name. But when I close this and press the button again the form opens as normal.
I do not understand why?
I was told that once you hide the form and when you open the form again, it should appear normal. Why do I get this blank form??? Only by hitting the button again then the form is normal....
I created a form to enter the lookup data and build the SQL string to create a recordset in VBA that is a subset of the original data. Using the Form wizard I created a form that displays ALL of the records in that original table (actually a QUERY). What I want to do is open this second form but have it reference the recordset I built in VBA.
I would like to take advantage of using combo boxes to search records on a form but do not want user to be able to edit or change any of the data. Setting the form to read only of course, disallows use of any controls on the form.
I just imported all of my objects (tables, forms, etc.) into a brand new database file and all of my forms are now full screen instead of the size I set them to in design. What caused this? I can't get them back to their normal size.
I am using Access 2007 but imported files into 2003 .mdb file.
