Modules & VBA :: Maximize And Minimize Forms
Feb 27, 2014
I have a Form [frmLogon] which opens on db open to allow users to logon, once they have entered their username and password they click a cmdbutton which then minimises [frmLogon] and opens form [Navigation Menu].
On close of form [Navigation Menu] how can I get [frmLogon] to restore to its original open state from being minimised.By the way i have to keep [frmLogon] open as it provides an OpenArgs reference to another form for security data!
View Replies
ADVERTISEMENT
Apr 3, 2008
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.
View 4 Replies
View Related
Sep 1, 2012
I created autoexec macrro. But when i open the form as a dialog box it doesn't show minimize and maximize button.. it only shows close button so what should i do..Also i want to create the log in form as well..So here is what i want
1) when i open the database it shows me log in box and if i put right password and username
- if i put wrong password it should keep promoting me until i put right login details and this login shouldn't be displaying the close button otherwise users can easily access through database.
2) the navigation form should be pop up.
View 2 Replies
View Related
Dec 9, 2013
im try to close a form called "new job" and re-maxmise Form "main switch board"
i have manage to get my pop up form "main switch Board to minmise with Macro but unsure how to recall it when "new job" closed
View 1 Replies
View Related
Nov 16, 2014
Who can tell me how to minimize Access window while it's form is on top of other open windows (e.g. other applications which are maximized like Excel). By using acCmdAppMinimize command, only the Access window is minimized and if other applications are maxmized, they will be on top. So is there any vba solution to do what I explained?
View 4 Replies
View Related
Mar 5, 2015
I would like to disable the Navigation Pane completely, based on the security level of the user that logs in, of course.
I have code that checks their level (I'm an "Admin" and everyone else is a "User"). If they are a user, then it hides the ribbon and minimizes the nav pane. If the login is mine, it enables everything.
That works, but the only problem is that the user can just maximize the Nav Pane on their own and access all the tables, and I don't want that. I can't find any code that completely disables the pane.
I have this code connected to my login button on my login form:
Code:
If Security = "User" Then
DoCmd.ShowToolbar "Ribbon", acToolbarNo
DoCmd.NavigateTo "acNavigationCategoryObjectType"
DoCmd.Minimize
Else
DoCmd.ShowToolbar "Ribbon", acToolbarYes
DoCmd.NavigateTo "acNavigationCategoryObjectType"
DoCmd.Maximize
End If
I can go to the options menu and disable the nav pane completely, so I know since only I have access to the ribbon, I could always go in each time and recheck the display nav pane option on that menu. But, that could be a little bit of a pain having to do that each time.
Also, I know I could finish the design and convert the DB to an MDE, but since my DB isn't broken up into a front/back end, I have to access that same DB everyone else uses, and if any changes need to be made, I don't want to have to use my backup, transfer over the changes any user made to the records, and then reconvert it back to an MDE each time.
If it's possible, I'd like to do all this using VBA. If they aren't an ADMIN user, then disable everything for them, but if I login, enable everything for me.
View 14 Replies
View Related
Feb 19, 2014
I have a form that maximizes when it loads and that works fine, but when I run a macro to open it the command is bypassed. Is there a way around this?
I've tried setting the code to run on different events (open/activate) but that didn't change anything.
The reason I want a Macro to open it is so I can set the property to Add only, perhaps there's another way I can do that, perhaps as part on the form open event in VBA instead?
View 2 Replies
View Related
Nov 2, 2013
I'm a newbie using Access 2007.I am trying to make things as easy as possible for the user of a database that I have been working on. The users maximum screen resolution is 1600 x 900 and I want to have specific forms automatically "maximise" to fit the screen.I have set the Form property "Fit to Screen=Yes" but it does not do what I am expecting and want.I also have "Auto Resize=Yes"
View 4 Replies
View Related
Mar 9, 2014
I need to disable or hide the restore, minimize and close window buttons found in the top right hand corner of a form.
I navigation buttons that controls open, close etc already set up.
View 4 Replies
View Related
Nov 10, 2005
Hi:
In MS Access:
In Forms section
DoCmd.OpenForm "Procedure", acNormal, , , acFormAdd, acDialog
I have one button for doing the above action, it works.
when the form come out, there is only close window (x), it doesn't have minimize window (_) option. How can I make minimize window button at the top right corner?
Thanks.
View 1 Replies
View Related
Feb 8, 2006
On my switchboard I have a button to open another form. I would like the switchboard to close autoatically when the button is pushed so that it is out of the way when the new form opens. Now, the new form opens in behind the switchboard which is why I want to ge the switchboard out of the way. Thank you.
View 3 Replies
View Related
Jul 12, 2006
Hi,
I have in the Form_Load() event, the following command:
Private Sub Form_Load()
DoCmd.Maximize
End Sub
It has been fine for several weeks, and today, when I open the form, it does not maximize. Also, there are a few other commands that are not working, connected to macros, plus an "Exit" button that was created using the wizard. I checked all of the code and macros for accuracy and nothing seems to be wrong. I have no idea where to begin looking.
Any clues, helps or suggestions will be greatly appreciated.
Thanks in advance,
Jake
View 1 Replies
View Related
Sep 27, 2004
I have read several tips to maximize my reports. The common one is the DoCmd.Maximize. However, when I type this into "On Open" on the properties window in the design mode I get the error message "Can't find the Macro "DoCmd".
How do I fix this?
Jeff
View 2 Replies
View Related
Mar 13, 2006
is there a way that we can minimize access application to system tray.
this can be done in a vb project.
View 1 Replies
View Related
Apr 27, 2006
Hello,
I have tried using the following code to maximize my form on open but it is not working, any ideas?
Private Sub Form_Open(Cancel As Integer)
On Error GoTo Err_Form_Open
DoCmd.Maximize
Exit_Form_Open:
Exit Sub
Err_Form_Open:
MsgBox Err.Description
Resume Exit_Form_Open
End Sub
View 2 Replies
View Related
Aug 21, 2005
When i make the maximized on opening by docmd.maximize, coud i get the form centered too?
right now im just adding form space on the leftside so it comes somewhere in the middle but if somone has a diffrent ressolution then it wont work as well.
View 3 Replies
View Related
May 22, 2006
I have some trouble getting a form to open maximized. This form is opening from a switchboard that is centered and not sizable. After clicking on a command button in the switchboard the form I am having trouble with opens in its own window, but I cannot get it to maximize automatically. I have been to every setting I know on the form properties but for some reason nothing seems to be able to get that form to open maximized.:confused:
Heeeeeeeeeeeeelp!!!!!
mafhobb
View 3 Replies
View Related
Nov 14, 2006
how to maximize the form when you load it?
View 1 Replies
View Related
Jul 11, 2006
How do I minimize/close the Switchboard to view a selected form/report. It shows up behind the Switchboard. Thanks!
View 1 Replies
View Related
Feb 28, 2005
I want my Switchboard, and all subsequent forms to be maximized on open...so that the form name doesn't show. Is that possible?
View 5 Replies
View Related
Jun 25, 2012
Is there a way to minimize the navigation pane and the upper tabs on start up? I have several big forms that don't seem to fit unless these are minimized.
View 5 Replies
View Related
May 26, 2015
How to hide, or disable the "Minimize", "Restore Down", and "Close" controls in the top bar (ribbon?) when previewing or viewing reports?
View 1 Replies
View Related
Oct 31, 2012
How to disable the Minimise, Restore and Close Buttons at the very top right hand corner of the Access application?
I have got buttons on my database to open / close everything so no need for them, even to hide the full Title bar probably be okay.
I am running Access 2007.
View 12 Replies
View Related
Dec 22, 2013
I have created a report with a subreport for my database. The user selects the project for which he/she wants to see a report. Once the project is selected, the report is displayed in a popup window and maximized in the print preview layout. This allows the user to view and read the report. Once this is done, there are no buttons or menus on the screen that allows the user to send the report to a printer or file.
Other than the report, there are minimize / maximize and close buttons at the top right of the window and page selection buttons at the bottom left of the window. If the user wants to print the report, they must either hit ctrl-P or right click the mouse on the screen to display a menu from which the user can select print to open a print dialog box. Is there any way to add a button or menu to the print preview that appears on the screen to make printing easier?
View 4 Replies
View Related
Jul 12, 2006
Hi
I have a form pop up calendar that returns the date in a date field on a form. This was a free popup and is activated by a double click which issues the command popupcalendar(screen.ActiveControl). I select the date from the calendar form and this date does update the correct filed with the date value I selected. What I have been trying to do is also display the day of the week which I can get using the vb weekday function. This all works well if I put the code in the on exit event of my date field and then use tab or any other way to exit the field. However I would like to be able to automate the process so that when I returne from the popup calendar the day field is updated at the same time. I have tried all the event options of my date field but do not get any changes to my day field. If a field is updated using VB does this disabe these events. Any help wpould be great.
View 2 Replies
View Related
Sep 11, 2014
I have a form which opens as a pop up when the system starts. On here are several buttons, which open other forms.Some of these just open another form and the user starts using the system, other close that form and open another one, and take go further into the structure of the system, then the forms that open have the same etc.For each of the buttons the code is very similar..For forms that open another one and don't close the main form:
Code:
Private Sub cmdescalations_Click()
DoCmd.OpenForm "frmEscalations"
End Sub
for those that close the form:
Code:
Private Sub cmdStock_Click()
DoCmd.Close acForm, Me.Name, acSaveNo
DoCmd.OpenForm "frmMain_Stock"
End Sub
Just the main of the form it opens changes, and sometimes with ,,,dialog in the options if its required.The opening part works every time without fail, but the form doesn't always close and I end up with two forms open instead of one. If I close the newly opened one and press the button again it works fine. This is purely random and only started a few days ago, up until then it has been working fine.
There is a hidden form that is open as well when the system starts, which check for something on a timer event every 60 seconds. If that event is firing would the focus shift to the hidden form, between me pressing the button and the event firing and the hidden form is getting closed? then the new form opening?
View 2 Replies
View Related
