Preventing Form From Resizing

Sep 7, 2005

Hi
I have a Switch Board and when I click to view a report on it the report automatically opens in maximize view, this is what I want. What I dont want is when I close the report for the Switch Board form to be maximized as well

How would I be able to prevent this??
Cheers
bikeboardsurf :rolleyes:

View Replies


ADVERTISEMENT

Forms :: Resizing Form With TabControl

Jun 5, 2014

In Access 2010 I want to resize my forms according to the user's screen resolution.I designed my forms to look fine for 1024x768 and then multiplied everything at higher resolutions.In the forms OnLoad event I inserted a procedure like the following:

Code:
Public Sub SetSize(aForm As Form)
Dim MV As Single
Dim ctrl As Control

[code]....

It works fine if the page doesn't have a TabControl; but with the Tab Control Pages it get missed up. I think because changing the TabControl size will affect immediately the contened Pages, and when the code arrives to change the size of the pages, it is no more the original size . So I tried this:

Code:
Public Sub SetSize(aForm As Form)
Dim MV As Single
Dim ctrl As Control

[code]...

Things are better, but still I found that the values of my pages and the background rectangle I inserted in each pages to make them of different colors are wrong, instead the values of TabControl are correct.

View 1 Replies View Related

Preventing Duplicates In A Form

May 28, 2007

Hi all,
I've got a database with a members table and an events table and a participation table which is like an 'intermediary table' which just has fields for MemberID_fk and EventID_fk.

The form at the moment has a combo box for Members and a combo box for events. This works well but the problem with it is that there is no safeguards to prevent a member from joining the same event many time.

Ideally i'd like for the combo box of events to be updated once the member's been selected to only include events the member has not signed up for.

If anyone's got any suggestions i'd love to hear them. The only constraint i have is that this has to be prevented when it is entered in the form.

Cheers,
Joe

View 3 Replies View Related

Resizing Subform

Sep 16, 2005

Hi,
I'm trying to resize a continuous subform automatically depending on how many records it is displaying. It needs to resize to fit all of the contents it displays, but no more. I also need to move labels and text boxes down if the subform size gets larger. This needs to be done every time the user cycles through records in the main form.
Thanks in advance. :cool:

View 3 Replies View Related

Windows Resizing

Sep 17, 2007

I have a form is set to Maximize on open
I have a drop down box on that form that allows a user to select a report and then the report runs and opens.

The problem is that when I close the report the form that I had DoCmd.Maximize is no longer maximized...

I have tried On Focus, OnOpen, OnLoad etc

I cant find the event that I can code on to get that Form to maximize when I close the report...

Any thoughts...

Can I set the Form to always be a specific size or maximized? I would prefer Maximized due to screen resolutions beign different....

THanks

View 1 Replies View Related

Preventing User From Restoring Form

Jul 11, 2006

Hi

Hoping someone can help me here. I have a form which is maximised on startup which also has the min/max and close button disabled. What i'd like to do is also prevent the user from restoring the form to ie. click the restore button which then makes the form smaller as i'd like the form to permanently remain maximised.

I'm not sure if this is possible, but if not is there a way to size the form to fit the height and width of the screen as if it was maximised regardless of the screen resolution the user is using.

Any help would be appreciated.

View 3 Replies View Related

Hiding And Resizing Columns

Jul 11, 2005

What I have: I have a main form with 3 subforms viewed as datasheets.

I have read the post about hiding columns by using me.<object>.columnhidden = True and that kind of works. Once the user goes to resize the columns they can get the hidden columns back. This is a problem if I'm trying to hide a priority column only admins should see.

Is there a way to specify the width of a column and restrict the user from resizing it? That way the user can not resize and get hidden columns back.

If there is a better way if doing this please let me know. Ultimately, I just don’t want the user resizing or unhiding columns I have sized and hidden.

Thanks

View 1 Replies View Related

Automatically Resizing Forms

Feb 20, 2006

Hi,

I'm doing a database with several pop-up forms, but however small i make them ,they always resize to give a fairly large border around the controls onthe far right and bottom. Everytime i try and shrink it, in code with the Form.Width property, and in the design view, they always resize back again.

Any help would be great.

Tony

View 3 Replies View Related

Preventing Opening A Form Unless Data Is Entered? And Some Other Q's.

Oct 29, 2006

Hello again,

I have three questions this time 'round:

1. I'm in need of some way of preventing a user from opening form B unless he has entered information in form A.

Right now it is possible to open form B without entering data in form A (form A being the date/time info and form B being the case technical info) due to which a record is created for clientnr 0 (which should be a non existing client). Querying for clientnr 0 from time to time and deleting those records is easy enough, but who knows what kind of relevant data could be stored accidentally in a record that doesn't belong there.

This happens by the way, even though referential integrity is enforced throughout the dbase. Maybe I should say, because of that. I want to keep it that way of course to prevent orphans roaming around. But having orphans for clientnr. 0 is also not a good idea.


2. What is the wiser thing to do: keep all information concerning one case for one client (date/time info per case, techinfo per case, maybe even products sold info per case, payment info per case) in one table and have the data needed for each thing entered in seperate forms, or have all data split up into seperate tables like I have now. One for clients, one for dates and times, one for the technical info for that case etc.... ?

It is starting to seem a bit ehrm... useless to have all that data for one case floating around seperate tables. I don't know... it seems so much more complex (having to create multiple relations, multiple PK's per table etc.).

Where do I draw the line? For example the image attached (relationship2.jpg): now I have one PK in the table holding the clients (clientnr), two PK's in the table holding the case date/time info (clientnr and casenumberdatetimeinfo), three PK's in the table holding the techinfo (clientnr, casenumberdatetimeinfo and casetechinfonr). And what's next? Four PK's in the table holding the sold productsinfo? Five PK's in the table holding the invoice info? And what about the relations between those tables? Right now I can still comprehend.... but when I start thinking ahead, I'm starting to get dizzy. So some advice on this would really be highly appreciated.

3. Which build up of the relations between the tables in the dbase is better? The one in relationship.jpg or the one in relationship2.jpg?

View 8 Replies View Related

Preventing A Form Close /save If Not Valid

Jan 26, 2008

I have validation logic that runs to test whether certain fields are inputted properly etc on my form. I call these methods in the Before_Update of each form. But How do i actually STOP the update from happening? OR how do i stop the form from being closed?
Right now, I just give all these warnings but the save still happens!

View 5 Replies View Related

General :: Preventing Changes And Additions Except Through Appropriate Form / Table?

Nov 9, 2012

While I was trying to test one of my forms (which was NOT working and I had to totally redesign it), I somehow created a bunch of stores in my Store Information table...some with no names, some with the first letter of an existing store, and there was even a duplicate of the store which is creating a problem now because some products exist in Store 1A and others exist in Store 1B.

I've created a query to identify the wayward products and am changing those. I'll delete that store then.

My issue is...can I set it so that the ONLY place a new store can be created is in the Store Information Input form? That if someone makes a typo when entering products, it doesn't create a new store?

Access 2010

View 2 Replies View Related

Modules & VBA :: Preventing Undo Changes To Data In A Form

Mar 10, 2014

I'm using the following code to ask the user whether to save changes to the data, don't save changes or Cancel the close and continue editing. I'm closing the form using the 'X' only.

Code:

Private Sub Form_BeforeUpdate(Cancel As Integer)
Dim UserResp As Integer
UserResp = MsgBox("Record(s) have been added or changed." & vbCrLf & "Save the changes?", vbYesNoCancel)
Select Case UserResp

[Code] ....

The problem I'm having is when I press the 'Cancel' button in the message box. When I press 'Cancel' the form remains open (bPreventClose=True) which is what I want. But the changes to the data get undone even though I don't have Me.Undo in that case.

First, what's causing the undo?
Second, how do I prevent the data from undoing when I press 'Cancel.'

I went to add a record earlier and selected 'Cancel' because I wanted to change one small item. I lost all the data I had put in and had to start over.

View 2 Replies View Related

Auto-resizing Fields On Focus

Apr 15, 2005

Hi everyone,

Problem I'm running into is I need certian fields to auto-resize when they're hovered over (or have focus) so that all the information is viewable, but then resize back to normal afterwards. The forms contain a large amount of information, so the fields have to be smallish most of the time, but certain fields, such as email addresses for example, are hard to work with because you can't see most of the entry.

Any help would be greatly appreciated. Almost done with this Access project, and it's just little details at this point.

-Walter

View 6 Replies View Related

Custom Save Button On Form Preventing Subform

Jun 21, 2005

I have a main form and a sub form. Tbhidden and tbpropersave are the text boxes that govern the update procedure. The main form has two text box that i use to prevent the user from modifying the information on the main form without clicking my custom save button. the problem is that the subform should be completed after the information on the main form has been filled in. The Update code i have refuses to allow me to complete the subform without first clicking the save button on the main form. Here is the code. I wana be able to fill in info in the main form, then the sub form then click save. The sub form is a table which relates to the main form table Many to One.

Private Sub Form_BeforeUpdate(Cancel As Integer)
On Error GoTo Err_Form_BeforeUpdate

Me.tbhidden.SetFocus

If Me.tbPropersave.Value = "No" Then
Beep
MsgBox "Please Save This Record!" & vbCrLf & vbLf & "You can not advance to another record until you either 'Save' the changes made to this record or 'Undo' your changes.", vbExclamation, "Save Required"
DoCmd.CancelEvent
Exit Sub
End If

Exit_Form_BeforeUpdate:
Exit Sub

Err_Form_BeforeUpdate:
If Err = 3020 Then 'Update or CancelUpdate without AddNew or Edit
Exit Sub
Else
MsgBox Err.Number, Err.Description
Resume Exit_Form_BeforeUpdate
End If



Please HELP


End Sub

View 1 Replies View Related

General :: Booking Form - Preventing Double Records

Dec 2, 2012

I am new to Access and have made a database for a shuttle company that keeps track of their bookings. I need to prevent from the same booking being entered twice. I have a "Booking Form" that was made from a table "Master List". I was wondering if there was a way to compare three of the fields and if they match then a error would pop up.

I think if the "client's name", "booking date", and "pick up time" matched then a "booking already exists"... and also there are four different people can enter data and they have a log in form how can I get their "username" to be put into a field on the "Master List" automatically...

View 1 Replies View Related

Forms :: Preventing Duplicate Entry In Unbound Form

Aug 13, 2014

What is the code for displaying warning message when enterenig duplicate information in unbound form in BeforeUpdate event procedure.

View 1 Replies View Related

Forms :: Preventing Decimals From Rounding In Form Display

Mar 26, 2013

I have created an Access 2007 database that uses a form for data entry. While the data is stored on the table exactly as entered, the data entry form rounds up and only displays the whole number.

In the properties of that form field, I have the format as fixed, with decimal places as set to 1 and is visible. However, the number still rounds. What do I need to do differently to make the number display as entered on my data entry form?

View 1 Replies View Related

Resizing Bound Object Frames - Inserting Word Docs

Feb 17, 2005

I have created a table with ole object types and linked word documents. I am now trying to create a report with the word documents showing up. The problem is that the size of the word document varies, some are half a page some are several pages. When I create the report with the object frame, I can't seem to find a control property to 'can grow'. Is there some way, possibly using VB, to create that feature. I'm thinking the VB way might be to access the embedded file and find out it's size and then size the object frame accordingly. I don't want to make the frame set to the largest document because then there will be blank pages that I don't want in the smaller documents.

Thanks for any help

View 2 Replies View Related

Forms :: Preventing Double Booking Of Room In Form Based On Multiple Criteria

Aug 13, 2015

I have Table for rooms called Rooms, and the data in the table is roomNumber which is in the format Letter and two Digit number, so A01 would be dorm building A and room building 1, and I then have a seperate row named roomType that is either VIP or Semi Private.

Now I am creating a form where a worker will put in there scheduledCheckin date and scheduledCheckout date and it will be written to the Bookings table. I would like this form however to take the dates they have put in, as well as room type (Semi-Private or VIP, and assign them an available room that isn't booked at all in that range) or list all available rooms for that range of time and they could then just select the room. I would rather it automatically assigns an available room based on room type though because this check in system is going to have about 500 rooms.

I've attached a link for what I have so far. I know how to make a query to list anyone who has booked rooms over that date, but need one for just preventing booking the same room.

[URL] .....

View 3 Replies View Related

Forms :: Dynamically Resizing Forms And Controls

Oct 31, 2013

I am making a database that will be used by multiple people on a network, and they have different resoloutions on their own computers. when the database is loaded on their respective computers, the form controls are all off.

On the computer i designed them on, the forms fit perfectly on screen, as do the controls, i would like to know if there is some vba code i could incorporate into the form open event, or module code that i can use in order to dynamically re-seize the forms and all of the controls to suit different resoloutions?

View 6 Replies View Related

Preventing Duplicates

Jun 27, 2005

Hi,

I have a form and within that form there is two combo boxes and one text box. When one choses a value from one combo box, and then chooses a value for the other combo box and then enters the value into the textbox I don't want the user to be able to enter the same arrangement. That is I want to prevent duplicates on that combination. Also if they do this I want a Message Box to appear saying that that this combination already exists

I was thinking of using a multiple field index to prevent the duplicates, but I don't know if this is a wise thing to do. Can someone give me some help to see how I can prevent duplicates or offer another solution to prevent duplicates on the combination of the values.

Thanks
Greg

View 2 Replies View Related

Preventing Duplicates

Jun 13, 2007

Hi, How do you normally prevent duplicates being inputted into you forms.My Idea is thisThe input text box doubles up as a dropdownlist of current values held in the database for that field.So when you access the organisation form and go to the first text box as you enter the 'I' for IBM All the orgs with 'I' appear. When you see that the organisation your inputting already exists you will stop and move on to the next form.I dont know how to do this, so currently I have set the field OrgName as Indexed: Yes (No duplicates) but this isnt really any good as the user enters all the other details and clicks submit before the error message comes up.I have attached my file for you to understand this better.

View 2 Replies View Related

Preventing Certain Rows From Being Deleted

Sep 7, 2005

Hi
I would like to prevent the first 24 rows in a table from being deleted by the user, after these 24 rows they can be deleted. Is there anyway of protecting them etc without putting them in a separate table?

View 3 Replies View Related

Preventing Data Deletion

Dec 5, 2007

I have developed a database in Access which has user permissions implemented. These are set so that only Full Data Users have permission to delete information.

However, it has come to my attention that users can get around this by creating a query and then deleting records displayed in its results. I can't understand why this is possible, because the permissions should prevent this.

Can anyone help?

Thanks,

Gary

View 1 Replies View Related

Preventing A Record From Being Deleted

Jan 31, 2005

I have a table with a blank record at the begining and populated records thereafter. I used the cmd button wizard to create a delete button for that table. Is there a way to prevent the blank record (record 1) from being deleted by the command button but still allow all other records to be deleted?

View 9 Replies View Related

Preventing Duplicate Entries.

Nov 26, 2006

Hi again, thanks to all for the help given so far.

Is there anyway (other than making that field a primary key) to prevent the same value being entered into a different record?

E.g.

If under 'Name' Radion has already been written, I want an error message coming up saying there is already a record with radion.

View 3 Replies View Related







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