Hi there, i have looked into this but can't find a real solution. I have decided to keep certain of my forms maximised. I have tried pop up, or just have it ordinary sized but this doesn't work for my purposes.
So, the problem is that when the form is maximised, no matter what you do, you can't get rid of the "Restore Window" button in the menu bar. I have tried to make a workaround by putting "DoCmd.Maximize" in the Resize event of the form. The strange thing is that the event does fire but the form doesn't get maximised. Any idea why this is happening and what I could do to solve this issue?
I figured out to maximize a window when a report is opened, but now I want to restore the window sizes when this report is closed.
I think I kind of know what to do with the DoCmd.Restore and something about OnClose, but I'm lost in the syntax. If someone could help me out by giving me the syntax and where to put this code that would be fantastic :)
I have created a custom menu used on my reports which contains all the icons I need and anchored them to the right side of the report. I have been able to remove the min, max and the close icons from the default report menu bar at the top right hand side as well as the "Ask A Question" dropdown. But I am not able to remove the "Restore window" button that comes with the report print preview.
How do I remove the "Restore Window" icon from the report's menu bar?
Hi all - I have my DB on a large network with many pc's and I need to set it so it when users open the program, the DB window will automatically "Restore Down" to a height and width I specify. Is there a way to code this in the DB itself? Any ideas would be great. Thanks.
I have a parent window which upon clicking on a button will pop-up a child window containing a listbox. The listbox recordsource is a subset of the parent window. I want the user to select a record from the listbox which will load the selected record onto the parent window.
How does one pass argument back from child window to parent window?
From parent window to child window, I used docmd.openform ,,,,,,[argument] and me.openargs in the child window
I have an application that hides all the normal Access menus, so that the user can only use the buttons that I have put on the screen forms. Now however, when I open up access, I cannot get to any of the Access menus. It shows the toolbar, but not the normal FILE/EDIT...TOOLS/HELP menu.
How do I toggle this back on? Everything I have been able to find so far tells me to go to the TOOLS menu ---- I cannot get to the TOOLS menu.
Thanks. BTW, I am not really as stupid as this post makes me sound.
The novice that I am inadverdently deleted a record in a query. (I find it strange that it does not just automatically restore it the next time I run the query.) Is there any way I can get this record back without having to recreate the entire query?
I am using Access 2013 and I had a column that was accidentally deleted a few months ago. Is there anyway to restore a deleted column? If not, I have the majority of the data from that column saved in an excel spreadsheet with another column that is common to the access file and the excel file. Is there any way to take the data from excel and have it match up using the data from the common column?
Hi I have had a look on the forum but cannot find what I am looking for!! I need to back up all the contents of the tables of a database in a certain folder and then restore it. The reason for all this is to be able to update the database with new features so that the final user can receive the update and restore the data. How can I achieve this??? M
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).
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
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.
Is there any way to restore menus/editibility when they have been removed using ACCESS OPTIONS > CURRENT DATABASE then uncheck 'allow full menus'? Database was created in Access 2007. I always keep a back up of the pre-menu-disable state of my databases, but this is someone elses for which I can't find a backup.
I have a database with several reports that get constantly printed, however I am having an issue with their display properties that sometimes cause errors.I need the report to come up on top of everything, maximized and with the menu bar available to allow for it to be printed or close it. The report window cannot have "minimize" or "restore" available to make sure nobody access any form behind it.
To achieve this in a form I generally use the modal property, however if I do this in a report I cannot get to the menu bar to print or close the print preview.Thinking that modal was out of the question, I went ahead and maximized the report on load and set its properties to the image attached. The db is then compiled (accde) and then distributed.
On my computer (it is being developed on my machine) the report loads fine (maximized) with no min, max or restore buttons and the print preview menu bar is shown with the print and close buttons available. See "My PC" image attached.On any other computer, the report opens up maximized but the report's restore and close buttons are enabled, however the print and close buttons on the print preview menu bar are greyed out. See "Other PC" image attached.Why the inconsistent behaviour when using the same front end?
My application is developed in Access 2003 version. Recently we moved from Access 2003 to Access 2010. Now users are facing usability issues like - in Access 2003 all the forms are opening in different windows and they can move to forms easily. But in Access 2010 all the Forms are opening in same window, if they want to move to different forms then they need to close the current window or press ctrl+F6. How can I enable/open forms multiple window in Access 2010.
For my Access DB, I have unselected the relevant options in Tools – Statup to hide the Objects window so that inexperienced users don’t corrupt the design of the forms, reports etc. However, I find that hitting F12 key brings a pop up window ‘Save Form (name of the form open appears here) To: ……….(blank text box). As ……(form or data access page options here)’ with OK and Cancel buttons. Hitting OK saves the form as it is and typing something after ‘To’ saves the form in that name. Though it doesn’t corrupt the DB in any way, I find this pop up window an irritant. Is there a way to stop this?
ive been disabling the database window from the startup tab in MS access, just now when ive tryed to show it on startup it appears but its stuck in the top left hand corner and i cant move it! so i cant access the tables
I've imported somebody's access db which hides the database window by default. When I click the db window button in the toolbar, the db window pops up high up and is somewhat hidden by the toolbar. I can't pull it back down as the top is hidden and when I try to move the toolbar,the db window simple moves up so I can't grab it and move it. Any suggestions?
In order to prevent inexperienced users corrupting the design of the Forms, Reports etc. of my Access DB, I have unselected the relevant options at Tools – Startup and it doesn’t display the Objects window. However, I find that when I press F12 key, a pop up window appears with ‘Save As’ ‘Save ‘frm……’ To: As …..’ with OK and Cancel buttons. Though a user can save the form with a different name and this does not interfere with the proper functioning of the DB, I find this an irritant pop up window. Is there a way to stop this pop up window?
Hi, I have been using Access 2000 for quite a while now. I have been using the Immediate Window to call my code, but for some reason, this window won't display now, no matter what I do - I have repaired the installation and reinstalled it but to no avail