Open 2nd Form In Minimized Window
Apr 12, 2005
Hi all,
I have a main form which is open in a maximized window (which i want to leave as it is), i have a command button which opens a form, now i want the form to open up as the size of a box i have created in the form, without altering the size of the first form. Also is it possible to move the 2nd form to the bottom left hand corner of my screem.
This is code i have so far does minimize window to what i want it to but also restores first form, which i want t leave maximized:
Code: Me.InsideHeight = Me.Box15.HeightMe.InsideWidth = Me.Box15.WidthDoCmd.Restore
Thanks in advance for any help,
M-.
View Replies
ADVERTISEMENT
Mar 29, 2007
I already have this working by means of:
doCmd.RunCommand acCmdAppMinimize in Form_Load (or Form_Open) events.
This works great to hide Access and only display the main form (like a standalone app).
But I have 2 issues:
1. The PopUp form (main or "switchboard" if you like) opens, then Access is minimized, but then the form looses focus. If there are other programs running, form will be behind them!
2. Access is first seen opening (for a moment) and THEN minimized (see 1.). Is there a way NOT TO SEE IT at all? :)
Thanks!
View 3 Replies
View Related
Sep 24, 2013
I recently completed a db for a client and they have since asked that the access window be hidden for certain types of users.This I did using
Code:
ShowWindowAsync Application.hWndAccessApp(), SW_HIDE
if a relevant user opened the db. All well and good, except they then wanted to be able to see the Access link in the taskbar (which SW_HIDE doesn't do) - so I changed it to SW_MINIMISE and they were happy again until..They then realised (and it was a surprise to me as well) that the right click context menus used to filter and sort continuous or datasheet forms were no longer available to these users - nor was the context menu for datasheet columns to freeze or hide columns - see attached.
I've experimented with a number of options and these context menus are available if ShowWindowAsync is not called or if called with SW_HIDE, but not for SW_MINIMISED, SW_SHOWMINIMISED, SW_SHOWMINNOACTIVE, SW_SHOWNOACTIVE.
Why the shortcut menus are not available when the Access window is minimised? The requirement being that the context menus are available to all users the Access link appears on the task bar for all users the access window is hidden for some users.I should say that due to hiding/minimising the access window all forms are popup and modal.
View 1 Replies
View Related
Dec 7, 2006
Hello I have a database that opens in maximized form.
I also have another form that opens when a button is clicked.
What I want is for the second form to open small and not maximized like the main form.
Can this be done?
Thanks
View 2 Replies
View Related
Aug 12, 2005
Folks,
i open my relationship window from a form and i after hide its visibility using the code below.
DoCmd.RunCommand acCmdRelationships
Forms![frmRelations].Visible = False
I need to open the hidden form after clicking on the close(x) button of the relationship window.
Are there any ideas please.
View 2 Replies
View Related
Sep 6, 2005
Hello,
I am a researcher creating critical editions of ancient texts by collating readings from several manuscripts (i.e. different mss all contain minor differences). I create my edition in Word and use footnotes to record the variant readings. I also have a database - created from the word file - in which I can add context to each variant e.g. decisions, history etc. So I have a word file containing the text and its variants uniquely identified with a footnote reference and a database with one table and a record per variant and where the variant records are also unique and share the same number as the footnote. I would very much like to be able to open a window on my variant form which displays the word file at the correct variant (i.e. footnote reference) location. This will make it easier for me to record my assessments of the variant in the dbase while looking at where the variant occurs in the text. Obviously I don't need to see the footnote window as I have this info in the dbase.
I haven't got a clue how to do this and would appreciate any pointers.
Many thanks in advance,
Tim
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
Aug 17, 2014
I have just noticed when I open one of my forms . the database window becomes inactive and I cannot open another , form , report etc.
View 2 Replies
View Related
Oct 21, 2013
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.
View 3 Replies
View Related
Nov 27, 2006
Hi,
I would like to open the MS Access Window in a certain position and size.
Somehow similar to open a form when using:
- to set the position and size:
Private Sub Form_Load()
Form.Move Left:=11500, Top:=6500, Width:=7000, Height:=6000
End Sub
I would like to open the MS Access Window within the screen area at a certain location, and having a certain size.
Is there any option in the Access Menu, or I can write some code, and where has to be written, so when I double click on the *.mdb file, the MS Access Window will open where I want and the size I want.
Thank you.
View 8 Replies
View Related
Jan 28, 2006
Hello everybody, it's been a while since i wrote on the forums and yet again I am in the need to ask for the help of this wonderful community.
I have a form on which is a button that I want when pressed to open a Windows Explorer window displaying the contents of a directory.
The exact way that I want this thing to work is like this : The user is browsing a form of lets say client details and on the form lies the button that when pressed will take the client's name and apply it to the path in order to open that Windows Explorer window and create a path like C:program filesclient name and display the contents of that window.
I would like if possible someone who can point me as to how I can construct this button to work cause I cant see to get it done.
Many thanks for your time :)
View 3 Replies
View Related
Aug 21, 2013
Is there a command that I can use to export a spreadsheet to Excel...
I could use docmd.transferspreadsheet
however that would also mean i would need an input window where users would need to manually put in the location they wish to save to...
Instead, could i not get a "SaveAs" command window or a file browser at least for them to search that way?
Alternatively, If it was possible to use VBA to pop up the "Export - Excel Spreadsheet" window, that would be just as good.
View 2 Replies
View Related
Jun 7, 2013
I am new to VBA for access. I am working on a form as a user interface. I have added an picture to the form and it will change, according to the selection in the combobox. It looks small, and not clear because of the size, and each image has different size. I would like to know if there is a VBA code that will allow me to click on it, and then it will open in another window so it is bigger with the right sizes.
View 6 Replies
View Related
Jan 16, 2013
I was reading how to make a a button open a webpage. I found out how to and what to type in the Visual Basics. It worked but like another user said, when ever he clicks the button, the window opens for the website but the window is not maximized. He said "I set the open new window value to True".
View 1 Replies
View Related
Jul 18, 2014
I'm working on a database that produces employee contracts. To make it look as professional as possible I hide the Access main window when the splash screen loads using the ShowWindow function. The various forms to check and enter details all pop up without any problem, but when I get to the last stage where I use a report to produce the contract and then open it in PrintPreview mode, it won't display (unless I show the main window again , which looks very untidy!). Is it actually possible to display a report with the main Access window hidden?
View 6 Replies
View Related
Apr 11, 2006
It has been ages since I visited the forum, feb 23 to be more exact...
Life has been hell and am crammed for time... This time I have run into something I cannot get a handle on...
On just about any PC this db I build works perfectly, but on one I having some trouble (see attached). I have never experience this.
If I (or the customer) opens the database either by double clicking on the database on the network, double clicking the shortcut it looks like [see attachments OnOpen]
This is not very nice offcourse but is simply solved by clicking the maximize button. After which we see this... [see attachments AfterMax]
From this I can maximize the database screen, but not the form. It stays like that, unless I click design and then Form view. After which the database works normal.
Does anyone have any clue?
View 1 Replies
View Related
Sep 30, 2013
I'm trying to use this command:
Code:
Shell "C:WINDOWSexplorer.exe """ & Me.txtSource & """, VbMaximizedFocus"
to open a folder from within Access 2007 & Windows7. It works, but it always opens the folder minimised, whether I use VbMaximizedFocus or VbNormalFocus. It used to work properly in Access 2003 & WinXP.
View 2 Replies
View Related
Aug 13, 2015
I'm having trouble with a shell() command in my vba.
I'm trying to call up the picture viewer showing the file of the photo I clicked on in a form. Everything is happening as expected - the file opens in Windows Photo Viewer, but it is minimized.
I can open a picture fine from Windows Explorer, but something about my shell command is forcing a minimize.
Here is my code:
Code:
Dim sFile As String
PicFile = "C:Pics" & Me!PicName & ".jpg"
Shell "RunDLL32.exe C:WindowsSystem32Shimgvw.dll,ImageView_Fullscreen " & PicFile
I would have assumed ImageView_Fullscreen would do what I want!
View 4 Replies
View Related
Feb 15, 2005
Hi,
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
thanks in advance.
View 4 Replies
View Related
Jun 5, 2006
Hi..
Is there anyone can help me?
how to create a form that automatically can make the form longer when user click a button?
thank you..
View 1 Replies
View Related
May 25, 2005
I have a pop up form that appears (with a beep) when a condition occurs. I would like that form to appear on top of all other window applications.
Access is an active application but the pop up form is hidden if other applications are in use.
Is there a way to have the pop up window appear on top?
Any help would be appreciated.
View 6 Replies
View Related
Apr 5, 2006
How do I keep a form window always on top? Thanks..
View 3 Replies
View Related
Apr 2, 2014
I have a pop-up form that is coded through VBA to open on certain button clicks. I would like this form to always open in the top-left corner of the window. For the life of me, I can't find anyway to specific in access where the form should open when called...
Is there a way to specify this? Or does access simply determine that itself? (arbitrarily it seems...)
View 1 Replies
View Related
Dec 12, 2005
I need to have Access open with a form that does not take up the entire screen and I don't want to see the Access stuff behind it. How can I make just the start up form appear when I open the db?
Thanks for any help...
View 3 Replies
View Related
Feb 15, 2006
I have a form which I want to move OnLoad to the top-right of the Access window. Something like this:
Private Sub Form_Load()
Me.Move Right:=150, Top:=150
End Sub
But there isn't a Right:=, only Left:=. So maybe I could find out the width of the Access window? Is this possible?
Thanks for any advice.
View 6 Replies
View Related
May 17, 2006
Hi all, I have a main form which contains buttons to control all other window. I'd like to prevent user to work on two forms at the same time. Can anyone advise me how to disable the main window while the second window is opened?
thanks
View 3 Replies
View Related
