Forms :: Set Where In The Window A New Form Will Appear

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 Replies


ADVERTISEMENT

Forms Are Opening In Same Window / How To Open Forms In Different Window

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

Forms :: Opening Image In Form And Pop Up In Window?

Jun 7, 2013

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 sizes. I would like to know if there is a a way 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 thinking that it could be something in the on click event.

View 7 Replies View Related

Forms :: Form Opening Inside Access Window In Background

Apr 8, 2015

I have three forms:

Form_A (main form for the application - should always be open)
Form_B (always open, but sometimes has visibility set to false)
Form_C (opens from button on Form_B)

When I press the button on Form_B, the only code behind it is DoCmd.OpenForm "Form_C". This seems to hide Form_B, and open Form_C behind Form_A (which is the main form of the application) inside of an Access window.

I would like Form_C to open in front of Form_B. I suspect that I set up the form incorrectly or something when I created it, and it is therefore opening inside an Access window.

View 1 Replies View Related

Forms :: Set Form Property To Window In Database Set To Use Tabbed Documents

Oct 16, 2013

I'm using access 2010.

How to set a single form's property to act as it's own "overlapping window" in a database that is set to use tabbed documents. I want most windows to have the tabbed layout but there are a few that I would like to have pop out and be their own windows.

I noticed that the Northwind database did this somehow. if you click on one of the products from the home screen a form pops up in its own window. I tried reverse engineering it, but no luck so far.

View 2 Replies View Related

Forms :: Disable Or Hide Minimize / Restore And Close Window Buttons On A Form

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

Forms :: Access Style And Window's Style Form Border?

Nov 15, 2014

In my current database there seems to be two different types of borders in my pop-up forms! The best way to explain it is that some forms will have the Access style border while others have the glass style border that you see in windows. I can't seem to find any settings that will change this or even determine what causes it.

View 4 Replies View Related

Help: Pass Argument From Child Window To Parent Window?

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

Problem With The Window Sizes On Forms?

Mar 31, 2005

After much work and help from a lot of competent ppl on this forum i have finally been able to get my dB together. Now i have a problem though which i can't solve.
Problem is this:
I open a form, lets call it MENU. From this you open a second form called NewEmployee.
In this new form you insert new data about the employee(s) and then insert them in the dB.
So far so good, but when you do a print about the employee, the procedure is this:
A special form is opened (PrintOutForm), its fields are filled with data from the NewEmployee, it is printed and then closed.
Problem with this is that the MENU form is now not-maximized :) Which it was when you opened the dB.

Is this something any of you guys have encountered before?

View 3 Replies View Related

Forms :: Button Opening In New Window?

Apr 30, 2014

I am using Access 2010 and creating a front-end for a customer database.

Take a look at the screen capture I added to this post.

What I want to happen is on that "Supplier" button. When I click on it, it opens a new window with the "Supplier" form and on the specific supplier for this product. There is an attached image of what that macro looks like.

The problem I am having is that I do not want the Supplier form to open in a new window, I want it to open within the Navigation Form, replacing the what is currently on the screen.

View 4 Replies View Related

Forms :: Move Subform To Tab Window

Dec 21, 2014

I have a main form that has 2 sub forms on it - one below the other.

Because I did not like this layout I created a tabbed form on the bottom of the main form (2 tabs) and would now like to move each sub form onto each of the tabbed forms.

View 1 Replies View Related

Window Can't Be Moved Containing All Forms And Tables

Dec 20, 2011

Suddenly my database started to act wierd. Look at the attached image. I can't move the window containing all the forms and tables. And I need to point out that I didn't place it there myself...

How to move it? I tried everything I could come up with, i.e. remove the toolbars, changing size of tha window and the programs window, restarting, re-saving, etc.

View 1 Replies View Related

Forms :: Display Some Information From Query In Pop Up Window

Jun 18, 2015

I've created a query called "JobHistoryQuery" and a form called "JobHistoryMultiForm", this displays all Jobs related to an Asset and all the information about that job. There are some fields (BilledMonth, BilledYear, BilledValue, Parts Required, PartsUsed), however, that I would only like to see if I need to see them (as there is quite a lot of information on the form and ideally, I'd like to be able to see the key information from each job from that asset with ease). What I would like is to create a button that says "Billing" and "Parts" for each job and it brings up a pop up window displaying that information.

View 11 Replies View Related

Forms :: Getting Forms To Show In A Window Instead Of A Tab

Oct 11, 2013

The picture i have attached shows how i want a form to show, WITHIN its own window basically.

At the moment on my new database i am making, it will only show in tabs along the top, no matter what i try i cannot seem to get it into its own window if that makes sense.

No matter what i do when i view the form it just fills the screen regardless of the size in the design view, i am about to throw my computer out the window over something so simple!?!?

The picture attached i think i created that database is Access 2010, this new one is in 2013, and i dont know how to do this simple thing!

View 3 Replies View Related

Height Of Window For Form?

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

Move Form To Top Window

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

Keeping Form Window On Top

Apr 5, 2006

How do I keep a form window always on top? Thanks..

View 3 Replies View Related

Forms :: Command Button - Stop Window From Popping Up

Sep 9, 2014

I created a command button from using the wizard so when I click to delete the record the button is for, a window pops up asking if I am sure I want to delete the record. Is there a way to not have the button pop up?

Here is the code:

Private Sub cmdCompleted_Click()
On Error GoTo Err_cmdCompleted_Click
DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdDeleteRecord

Exit_cmdCompleted_Click:
Exit Sub

Err_cmdCompleted_Click:
MsgBox Err.Description
Resume Exit_cmdCompleted_Click

End Sub

View 3 Replies View Related

Forms :: Popup Window To Save File At Any Location

Feb 23, 2014

I find the following CODE online (Print to PDF). Which work perfectly for me, the only issue and/or modification I am looking for "Popup Window to save the file at any location", instead at fixed location.

Option Compare Database
Option Explicit
Function PrintToPDF(SrcFile As String)
On Error GoTo PrintToPDF_Err
'Function can be called from any report with this: "PrintToPDF(Screen.ActiveForm.Name)"

[Code] ....

View 1 Replies View Related

Forms :: Context Menus Don't Work When Access Window Is Minimized

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

Main Access Window/form

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

Moving Form To Top Right Of Access Window

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

How To Disable Form Window While The Second One Is Being Opened?

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

Form/Window Resize To Specified Dimensions?

Jul 5, 2006

Hey guys,
I know how to maximize a form when it opens, but I was wondering if there isn't a way to actually shrink down the Access app window to specified dimensions when it opens the form? I'm trying to write a dimension-specific app, so there is no distortion what-so-ever. thanks!

View 4 Replies View Related

Autofill A Form Window From A Table?

Sep 25, 2006

Hi all,Sorry if this has been asked before, but I've used the Search function and can't find exactly what I'm trying to achieve.The Current SetupI have a database that I'm now trying to expand upon by adding extra features. One of these features I'd like to add is the ability to, firstly, know how many records in the entire datasheet have not been officially closed (i.e. have their 'rmaclosed' column empty), and, secondly, to have a list autogenerated that shows all of these records and allows the user to double click an item from the list and have that record open.Now, to make life easier, I should point out that I already have a successfully working search function in my database. Clicking a button from the switchboard opens up a form that allows the user to enter full or partial text into a box, then, at the click of another button, the main window of the form will automatically fill out with a list of all those records which match the entered text. The user can then double click anything from this generated list and the appropriate record will be opened.Working on the assumption that the code for what I want to achieve would be near-identical to this search function code, I have replicated both the form and code, and am now trying to adapt it; it is this adaption I'm having trouble with.The Current SituationTake a look at the attached image. That is how my form looks to the user when opened.Now what I really, really want to achieve is for that central window to be automatically filled out with the listed column headings of any record stored in the table maindata that has a Null value in the column rmaclosed when the form is opened. However, I don't see any option for 'OnLoad', so I'm willing to compromise and just have the user click a button.You'll see the button there for 'List RMAs'. When clicked, that should populate the main window with the records that have not had their 'rmaclosed' column filled out. The code behind the button - which is where I'm having the problem - is as follows:Private Sub cmdSearch_Click()Dim strSQL As String, strOrder As String, strWhere As StringDim dbNm As DatabaseDim qryDef As QueryDefSet dbNm = CurrentDb()strSQL = "SELECT maindata.ID, maindata.rmanumber, maindata.company, maindata.rmalogged, maindata.initials " & _"FROM maindata"strWhere = "WHERE"strOrder = "ORDER BY maindata.ID;"'THIS IS THE BIT I'M HAVING TROUBLE WITHIf IsNull(maindata.rmaclosed) ThenstrWhere = strWhere & " (maindata.rmaclosed) Like '*" & maindata.rmaclosed & "*' AND"End IfstrWhere = Mid(strWhere, 1, Len(strWhere) - 5)Me.lstCustInfo.RowSource = strSQL & " " & strWhere & "" & strOrderEnd SubThis code has been adapted from that which - successfully - runs my filtered search engine. The problem is that my search engine runs a query based on text entered onto the search form by the user, whilst the form I'm trying to write should simply list every record in the main table, filtered according to the state of the 'rmaclosed' column.As I said in the opening paragraph, although it's not essential it would be really nice to have a counter somewhere on the form that would show the total numebr of records in the filtered list.

View 10 Replies View Related

Open A Form In A Small Window

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







Copyrights 2005-15 www.BigResource.com, All rights reserved