Query Opens Maximized.

Mar 5, 2007

Greetings all.
I've got a minor housekeeping issue with my db that I can't seem to crack.

The db opens to the main form, which has a boat-load of control buttons that open a variety of forms and reports and 1 query.

The problem is that when you select the button that opens the simple query, the query opens in maximized view and then when folks want to close it, they often end up closing the whole db, instead of just the query. (Using the right corner X.)

I'd like to open it about half screen or so, to avoid the accidental closing of the whole database.

I can open the query directly or from the macro and in both instances it opens up the correct window size. But when I use the button it opens maximized.

I've searched the code, can't find any reference to maximize.
Can't find anything in the button properties that would cause it.

Any idea why this is happening or how to get around it? It's probably something simple, but then, so am I. (hehehehe)

Thanks,

BeckieO

View Replies


ADVERTISEMENT

Form Opens When Database Opens

Aug 16, 2007

How can I get a form to open when the database opens?

View 5 Replies View Related

I Want Switchboard Maximized, But Having Trouble?

Oct 28, 2005

Hi All,

I want to load switchboard in maximum view only, but all other forms in a popup like format.
I have the Swithboard_On-Load, docmd.maximize, but when I select a menu item from switchboard that form opens in max-view. If I make that form Popup=Yes, it works, but then any command button [printview] will bring up a form behind the "popup" form.
How can I get just the switchboard to stay in max-view only?

I don't want to have to modify all forms and reports so that "popup"=Yes

Any suggestions.

thanks....
Enviva

View 1 Replies View Related

One Form Maximized & One A Set Size

Dec 14, 2005

Good Afternoon,

I am writting a database and i am have difficulties with forms.

What i need to do is have one form (Main) maximized and the other windows set to a standard size, the main form is always visible the others need to be opened and closed via buttons on the main form and sub forms.

I am not sure if this can be done so any help would be good.

Alastair Lane:eek:

View 3 Replies View Related

Form Always Open Maximized?

Sep 19, 2004

Hello,

Does anyone know how I can make a form always open maximized?

Thanks

View 1 Replies View Related

Maximized Form Appears To Unmaximize Itself

Mar 19, 2007

I bet this is a simple one.

I have a form with the on Load command

Docmd.Maximize

On this form I have a button to open another form, this works fine. On the second form I have a button to close the form. When I press this it closes, and the first form is still there which is what I want, but somewhere along the line it has unmaximised itself and is about half the desired size. Basically I want it to stay Maximized the whole time it is open.

The way I can think to get round this is to close and re-open the forms as I navigate through them but just wondering why this is occuring?

View 3 Replies View Related

Maximized Form Changes To Restore Mode

Sep 12, 2005

:confused:

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).

Any ideas?

Thanks...

View 6 Replies View Related

Maximized Form Coming 'unstuck'

Aug 15, 2006

Thanks if anyone can offer a suggestion, I cannot find a similar problem described on the forum.

I have a form which runs at startup maximised. Pop-up and Modal are set to 'NO', Auto Resize and Center are also set to 'NO', Border style has been set to various settings, and Moveable has also been tried at 'YES' and 'NO'.

A command button on this form opens another form with the same settings which I want to take the original form's 'place' in the application window.

This all works fine, just that when I close the second window (using DoCmd.Close), the original window is then no longer maximised underneath it. I want to make sure certain windows are maximised at all times.

I know I could hack this with a DoCmd.Maximise somewhere, (or by switiching to full Pop-up/Modal mode and hiding the Application window) but the results of these are all a bit of a hack.

Can anyone shed light on the mysteries of Access's default form maximisation behaviour?

Or does anyone do what I have described successfully?

View 4 Replies View Related

Opening A Report Instead Opens A Form (which Opens A Report)?

Jun 15, 2005

Hi,

I've been given an existing database to modify, and I'm struggling somewhat to see how the author has implemented certain functions.

On a main menu form (autoexecs on starting the database), there are various "Search By" option buttons to generate a report, ordered in various ways. The "On Click" field for each of them refers to a macro, called Buttons, and a line in that macro dependant on the type of search (e.g. OnClick = Buttons.byPerson).

The Buttons macro runs an OpenReport command, the report corresponding to the search type (e.g. Buttons.byPerson has an OpenReport command for the "Report by Person" report).

However, when I click the search buttons (or indeed run the corresponding reports) I instead get another form which allows the search criteria to be specified - this then generates the report (I would assume based on the relevant query - e.g. Person Query), but I cannot understand how this works.

Google searches have not helped much as I can't seem to find an adequate search phrase to use, and I've been staring at the thing for some hours now. Any help getting me off in the right direction would be much appreciated!

View 4 Replies View Related

Forms :: Main Menu Form Not Maximized?

Apr 25, 2014

I have a front end that I have distributed to four users. The front end sits on a shared drive and when I make design changes I just replace it and have the users copy it over to their desktops.

I set up a main menu for them to access the various forms, reports, etc. When I first open the front end on my desktop the main menu form is small and not taking up the entire screen. I put the cmd.maximize command in the on open event and still does not maximize the form when I open the database. I tried to size it and saved changes but still not working.

I just did a share session with a user and she opened the form and it was maximized on her desktop.

View 3 Replies View Related

Forms :: Restore Button Available When Form Is Maximized

Jun 6, 2013

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.

View 2 Replies View Related

Query To Return Default Set Of Values In A Subform When Main Form Opens

Apr 23, 2007

Here is my sample DBA

I'd like to solve this issue

when I open my Quotations form I'd like a set of services to be selected by default, ex: Brush and Pen. So the user only has to input the quote amount

is there anyway to have the form open with a script like:
"on open (or on load). in subform SELECT refproduct where product from tblproducts = 1 and also SELECT refproduct where product from tblproducts = 4"
Therefore when my main form opens, in the subform I have already Brush on the 1st line selected and pen on the 2nd. My user only has to type the price.

Thanks for your much appreciated help

View 2 Replies View Related

DB Opens Minimized

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

ACCESS Opens In Notepad

Jan 28, 2008

When one user opens his ACCESS file, it opens in Notepad. He uses ACCESS 2003.

Now he has to right click on that file (on windows explorer) and select open with 'MS Access' to make it to work.

Any one knows how this setting can be changed to open with MS ACCESS?

View 4 Replies View Related

Record Opens On Click

Apr 14, 2008

Hi,

Is it possible to have a query that shows only records for the current date and when you click on a specific record it opens in a form ready for editing?
The query would serve as an index of transactions for the current date.

Please help.

Piet

View 1 Replies View Related

Outlook Opens Access?

Sep 25, 2005

I have a pesudo forum running on a server which sends emails automatically to a group to indicate that there is a new posting - much like any forum...

I would like to include a link in the email (automatically) that will open the Access Forum and point directly to the relevant post...

I searched the forum but was surprised to find that this question hasn't been raised before... so I'm worried? :p

I know I will get a hundred links from the Mighty Moderators now saying I didn't look properly - as my old mother used to say :rolleyes:

Dave Eyley

View 2 Replies View Related

Close All Forms When New One Opens

Jun 10, 2006

Hi
I am trying to get access to close all open forms and open the selected form when a button is pressed.

I tried this in a macro like so:

open switchboard
open new.client
close (forms)

The switchboard is used as a back drop to the database.
the new client form will open over this (pop up is set to YES)
Any other forms will be closed at this point.

I can only get it to close one form at a time which means I have lots of close commands in each macro.

The problem is, if I add a new form then I have to go through each macro to reset it to take that form into consideration.

There must be an easy way to do this.

Alan

View 6 Replies View Related

Go To Last Record When Form Opens?

Nov 21, 2006

I would like my form to open and automatically go to the end of the records, so I don't have to navigate to the end before I start entering data.

I have seen a form do this but can't find out how.

Thanks

View 6 Replies View Related

Database Opens As READ ONLY

Oct 14, 2014

I have a FE DB that I have been opening and closing at various times without incident. Now all of a sudden it only opens as READ ONLY. I can't find anyone with a BE open that might be causing this. What will cause this? If I save a copy and then replace the original will I lose my data?

View 6 Replies View Related

Different Sub Charts Everytime Access Opens

May 4, 2005

I have a couple charts that I would like to show on my switchboard. Right now I only have one that is up everytime I open my database. Is there anyway to have it do a random Sub form show up everytime you open the database up? Thank you for your help. Without this forum I would have shot myself a long time ago!

View 1 Replies View Related

Database Opens In Exclusive Mode Over LAN

Nov 14, 2005

I have a database which seems to open many copies when it is accessed over the internet (via ASP) but If I open it on my compter over my LAN then it seems to open 'exclusive' and those on the Internet get the error message that 'file is already in use'.
Is there a way of opening the database over the LAN and allowing the Internet to see it?

View 10 Replies View Related

Show Only Form When Database Opens

Mar 8, 2005

I am sure this has come up a thousand times and I searched but could find nothing about this. I have a database with one main form and many queries. When the database is opened by users I would like for only the form to show. I do have queries in a dropdown list on the form to run. Basically, I only want the form to show when the database is open but I want to be able to get to the menu's etc when I need to.

Please help.

View 3 Replies View Related

Have Controls Null When Form Opens

Dec 14, 2005

What is the best way to have all controls in a subform empty when form opens? The form and subform are bound.


The following:

Private Sub Form_Open(Cancel As Integer)
Me.textDate = Null
End Sub

Produced error - "cant assign a value to object"

thanks in advance

View 6 Replies View Related

Form Opens To Wrong Record

Sep 21, 2006

I have a form based on a query. The query sorts records by ID number. When I open the form, it opens to a record that is not the lowest ID number. It's the same record each time that it opens to, but it's not the correct record There is no filter or sort order on the form, and it seems like starting with record 2 it is sorting correctly. any ideas? thanks.

View 1 Replies View Related

Filter A Record When The Form Opens

Jan 30, 2008

This is the first time I've used this forum so, hello everyone

My first question is about filtering a form

When a user is in the menu screen and selects a command button to view details, the next form that loads shows every record within the main table. So the user can use the navigarion buttons to go through each record.

There's search criteria on this form so the user can select which ever record they like.

Because of speed issues, I'd rather the form filtered a record (whichever one) as soon as they pressed the command button.

I've thought about how i'd do this and can't really come up with much; looked at openargs but my VBA isn't that hot yet

Does anyone have any ideas?

Thanks in advance

View 3 Replies View Related

General :: Form Always Opens On A New Record

Nov 14, 2013

I have a form that I built with the intention of creating new records. I want to convert it to use with existing records too. I can't seem to get it to look at anything but new records. I imagine it is a property setting and something very minor to a seasoned Access programmer.

View 14 Replies View Related







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