Open MS Access Window In A Certain Position And Size
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.
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
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?
when I open a pdf through access weather it is by hyperlink or attachment it always opens the full size of my monitor, if I open a pdf outside access then they open ok , how do I set the size that access opens the pdf the size I want.
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? :)
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?
users can opening a file (either .doc, exe or .pdf) with additional data to the record they're looking at by clicking on a icon on a form. The icon has code behind it that opens the document (Application.FollowHyperlink NameDocTo Open). That opens the doc OK, no problem, but what is a problem is that the window for this document is exactly the same size as the window of the access form from which the second doc is opened.
The size of the access window is defined. I'd like to get the word or excel or pdf to be maximized. The weird thing is that I use the same code in another database and there the 'secondary doc' opens in a new window and of large enough size. How can the same code generate 2 outcomes? And how can I fix the issue described?
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 :)
Can i set the physical dimensions of the MS Access main window from code, like when I open my first form?
My main development computer has a massive big screen, but I mainly program for 1024x768 screen. When the database appears on my screen I'd like to resize it bigger as I see fit, but have my code open it to a 1024x768 sized screen when it opens on someone else's computer.
I'm running MS Access 2003. My SQL editing window has a really small font size. How do I change this window's default font size? Is it in tools or options?
Help!!!!!!! I'm going blind!!!!!!:confused:
Thank you for taking the time to read this and for being willing to help out!!
Is there any way to force the switchboard to maintain its pop up window size? Whenever I open an item from it that is maximised and then return to the switchboard it too has maximised.
how to make my form controls change size / position as my form is resized / loaded on a computer with a different resolution. Several of the tutorials out there suggest putting code on the "on resize" property of the form. When I looked at the Northwind database to try to mimic their code however, it looks like they must be doing something different as there is no on resize code under the form properties and I was unable to find the code they do use.
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.
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-.
Hi - I have searched this board and cannot find anything that has worked. I'm hoping someone can help and maybe I've just missed it somewhere on this board. Here's the thing:
I worked for 3 months on a MDB and got it working the way I needed. I then ran it for the date range I needed and apparently hit a file size limit. I got the "invalid arguement" error and immediately stopped the query and did a "compact and repair". It looked like the compact and repair worked but then the mdb did not come back up as it usually does. I closed Access and tried to re-open the mdb. Nothing happens! No error - no nothing. It just plain will not open. I then tried to compact and repair again but that will not work even when I select it as the mdb to compact and repair. I even tried to open a new, blank mdb and link to the mdb that won't open..no go.
Does anyone have any suggestions on other things to try to get this to open again? Are the tables stored somewhere outside of the mdb that I can delete to make it smaller and open?? I'm grasping here..I know it..but i'm desperate to get this thing to open for me.
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.
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 :)
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.
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.
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".
Hi, I have been using "fSetAccessWindow (SW_HIDDEN)" in the open event of my main switchboard to hide the grey Access screen from being visible behind forms, reports, etc in this db. But when I started using a .vbs script file to launch the db, the Access window stopped being hidden. (The reason I use the script for launching is that it temporarily sets the db's security level to 1 which stops the macro security warning from coming up.) Apparently MS knows about this happening and released a technique to rectify the situation, but I don't understand their instructions. It looks like they expect one to have more understanding than I have. Could someone help me get this impliemented? Here is the article: http://support.microsoft.com/kb/167659/en-us Thanks!
I am trying to Hide or Show the Access Window by using two buttons on a Form. Running Access 2013 in Windows 7 64bit.
I have used code from the Internet as below but added the PtrSafe item to the Function Declaration as below:-
Option Compare Database 'Hide Access desktop screen and float Forms on pc desktop Private Declare PtrSafe Function IsWindowVisible Lib "user32" (ByVal hwnd As Long) As Long
Dim dwReturn As Long Const SW_HIDE = 0
[Code] ....
I then have two buttons on a form coded as below:-
Option Compare Database Private Sub cmd_Hide_dbw_Click() Call fSetAccessWindow("Minimize", False, False) DoCmd.OpenForm "frm_Test", acNormal End Sub
[Code] .....
I have attached a Test Database which demonstrates the problem I am experiencing.
Do the following sequence...............
Open the Test Database. DO NOT ENABLE CONTENT The Access 'Ribbon'Test_Database.accdb is active and usable Open frm_Test in Design View in order to inspect, all should be as shown above. Now click the Enable Content warning Switch frm_Test to Form View
Click button Hide dbw. Closes the Access Window Click button Show dbw. Opens the Access Window...HOWEVER....
Attachment 20252The Access Ribbon is locked and usable !!!
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
Back in 2004 a user (sbaxter) on this forum was offering to interrested members his utility for hiding Access window. Does anyone still have a copy of this utility handy that is willing to share? Thanks in advance. See reference post