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 Replies
ADVERTISEMENT
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
Sep 19, 2004
Hello,
Does anyone know how I can make a form always open maximized?
Thanks
View 1 Replies
View Related
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
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
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
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
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 1 Replies
View Related
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
Nov 9, 2006
Good Afternoon,
Could some kind person please point me in the right direction as to how to
stop the 'VB code' window appearing and remaining on my task bar when I initially open up my DB. When I look at whats in the window there seems nothing untoward, but I would simply like to get rid of it as it is annoying??
Other sample db's that I open up on a regular basis are fine, so I was just wondering what could be causing it and how I could avoid it re-appearing..
Hope you can help....
Kind Regards
CarolW
View 13 Replies
View Related
Oct 8, 2007
Hi
i have set up a search from that returns email addresses for contacts based on certain criteria. the only problem is that the query will return the same email address a number of times because the query is set up to respond to a number of queries each of which a contact might posses. therefore, i need to ensure that each contact will only reappear once in a query return, they are all assigned unique ID numbers so I am guessing something can be typed in the ID criteria of the query to ensure that each ID is only returned once.
Thanks in advance.
Shapman
View 1 Replies
View Related
Oct 8, 2007
Hi
i have set up a search from that returns email addresses for contacts based on certain criteria. the only problem is that the query will return the same email address a number of times because the query is set up to respond to a number of queries each of which a contact might posses. therefore, i need to ensure that each contact will only reappear once in a query return, they are all assigned unique ID numbers so I am guessing something can be typed in the ID criteria of the query to ensure that each ID is only returned once.
Thanks in advance.
Shapman
View 1 Replies
View Related
Jan 9, 2006
I want to stop the beep sound from coming up when i open a messagebox, i did already uncheck 'Provide Feedback With Sound' in options. Any other suggestions?
View 14 Replies
View Related
Mar 9, 2013
I have a large database of names, I would like to produce a query that reveals anyone that appears in the database more than once.
For instance in the image below "Sayprasith, Nick & S Kaye S" are listed twice in the database. I would like an output showing anyone that has their name repeat two times or more within the "owner_name" column. Ideally the output would be in such a way that preserves the "account number" field as well.
Based on the above image the ideal output would be:
Account Number Owner Name
00015121 Sayprasith, Nick & S Kaye S
00015148 Sayprasith, Nick & S Kaye S
Only it would be for the whole database that consists of many thousand records.
View 1 Replies
View Related
Nov 7, 2013
I have a calculated control on a form that is summing other controls and then a subtotal on a subform. This is access 2007
The calculated control does not display the value until I enter a value other then the default in all of the source controls. If I hit the "refresh" button, the value appears in the calculated control for a moment, then disappears.
I have set the default of the source controls to be 0, so none are null.
the calc control value does not stay until I put a value in the subform and its subtotal thus has a value
View 5 Replies
View Related
Oct 18, 2013
I have a form called frmElements which has its Data Entry and Allow Additions properties set to 'No' so that only existing records can be edited, this is all good and works fine when used from the Navigation Pane.
I have created a macro which opens this form from a button on the ribbon, this is where the problem lies because it opens the form and allows new records to be added, I know this because there is an empty record with an '*' at the bottom of the form. If I change to design mode the Data Entry and Allow Additions properties are still set to 'No', when I then change back to form view the form functions as it should.
It does not seem possible to set form properties using the macro builder and it appears to override the forms property settings.
I am using access 2010 on a Windows 8 machine.
View 5 Replies
View Related
Oct 24, 2014
I have a query that gives a value in a column either "A","V","L","H","P","S" or blank.
I want to be able to count the amount of occurrences of each letter and hold that number in a column. Is it easy to do?
View 5 Replies
View Related
Mar 24, 2015
I have a form for updating contact details of customers/suppliers. Upon clicking an edit button the user can update txt boxes (as opposed to updating the table data directly and making a mistake). When they press save the below code runs:
Code:
If Not IsNull(Me.txtp_fname.Value) Then
Dim strFirstName As String
strFirstName = Me.txtp_fname
Dim FirstName As String
FirstName = Replace(strFirstName, "'", "''")
End If
[code]....
View 10 Replies
View Related
Mar 28, 2014
I have a simple dbase that shows names in a table as "Smith, John" for example. My query links two tables, and should show all names in the aforementioned table. However, certain names are missing. Here's where it get's weird - if I change the spelling of their name (Smith, J for example), suddenly they will show with the correct data. There are no common strings to the missing names, but on each, when I change the spelling, each missing name appears. I have made sure the relationship is joined to show all data in the "Names" dbase.
View 3 Replies
View Related
Mar 5, 2008
I have a spreadsheet and the only column that matters is D.
Down column D it appears as:
a
b
b
b
c
c
d
e
f
c
a
I need the result to just appear like
A - 2
B - 3
C - 3
D - 1
E - 1
F - 1
View 2 Replies
View Related
Sep 9, 2014
In attached Preview.png I can see the Dates. When I print the report (Print.png) the dates are substituted with "#Name?"
In the report the date fields are bound to
Control Source =CDate([Forms]![frmTransactionPopup]![dtmFrom])
where frmTransactionPopup is a form which is open but not visible.
View 9 Replies
View Related
May 31, 2013
I have a log in table that counts every time a user logs onto the database. Each time a user logs in it adds another entry to a table.
I have built a query to display the user name and date of log in so I could display this information in a report. The report is now getting rather long, and I am looking for a way to display each users name and have the total number of times they have logged in, not display each time they have logged in separately.
The Query has two fields "Agent Name" and "Logger Date"
The report displays the data as follows
Agent Name Logger Date
User 1 26/5/13
User 1 26/5/13
User 1 27/5/13
User 2 28/5/13
What I would like to do is have a report listing each users name, with a column showing how many times they have logged on. e.g.
User Name Login Count
User 1 3
User 2 1
View 10 Replies
View Related
Feb 26, 2014
I'm trying to generate a query that can be used for a pareto chart (Bar Chart shows the count of a defect and a line chart as a second axis counts the cumulative percentage)
I've grouped my data, and sorted the Count of each time the record appears but I cant get my head around working the cumulative percentage. My datasheet currently looks like this:
Reason Count Per Expr1
A 35 47.9 Random Numbers
B 11 15.1 "
C 10 137 "
D 9 12.3 "
E 7 9.6 "
F 1 1.4 "
Expr1: DSum("Per","Rwk_Pareto","[Per]<=" & [Per] & "")
View 6 Replies
View Related
Aug 1, 2014
I have windows 7 access 2013, I had a query made, and wanted to add fields to it, so i went into the SQL and added several fields. Only the first one i entered didn't work and on the query is called "Expr1003" when in datasheet view. Its right in layout view, and even when i tried adding the same field in layout view, it made it "Expr1004". spelling is correct, in both source table and query, i don't know why this field doesn't work especially when the others did.
View 14 Replies
View Related
Aug 6, 2013
On a data entry form bound to a single table, there is a subform displaying all the records in the source table.If the user accidentally adds a record that they didn't mean to add (or if I add a record to test the form's functionality), and then right-click and delete the record, "#Deleted" appears in all the input controls.
View 5 Replies
View Related
Aug 12, 2015
I have a form that contains a blank text box for each field in a record. Until very recently it functioned correctly for years. Lately data enterers tried to fill a ten character field with five characters (ANNNN format, example X9999). Some records require an entry in this text box, some do not, so their field is left blank. Lately when a new entry is tried in this field, only the first three characters are accepted, blocking character four through ten from being entered. It acts as if the text length for this text box has been changed to three characters, but it is still the correct length in the Properties box.
The system keeps track of clients who have attended a nutrition education class and the form involved is the location the class was taught.
View 5 Replies
View Related
