f



Resize Form Controls and Subform Controls at the same time

In terms of resources, wondering if it makes a difference in adopting
one of the three options below for resizing controls on a form and
controls on a subform at the same time.

option a.) Put the code all in the main form and refer to the controls
on the subform in the main form's OnResize event.

option b.) Put the code for the main form controls in the main form's
OnResize event and put the code for the subform controls in the
subform's OnResize event.

option c.) Put all the code in a module and call it on the OnResize
event of the main form.

What this code is doing is positioning the controls based on the form
or subform's width:

Dim mainWid as Long, subWid as Long
mainWid = Me.InsideWidth
subWid = Me.Child.Form.InsideWidth

Me.ControlName.Left = mainWid - 500
Me.Child.Form.ControlName.Left = subWid - 200
etc.

Just wondering what advice people have to offer on this.
lq

0
11/11/2005 7:02:17 PM
comp.databases.ms-access 42670 articles. 0 followers. Post Follow

0 Replies
467 Views

Similar Articles

[PageSpeed] 11

Reply:

Similar Artilces:

Forms/Subforms in MS Access Database
Why do my Forms/Subforms in my MS Access Database not appear? All I see is the boxes where they should show?! What did I do wrong? Thanks, John zufie wrote: > Why do my Forms/Subforms in my MS Access Database not appear? > > All I see is the boxes where they should show?! > > What did I do wrong? -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Probably there isn't a name of a form in the sub-form's Source Object property. Also, the Link Child Fields and the Link Master Fields properties may be blank - you must enter the names of the link fields, they hold the field names that link the data between the forms. -- MGFoster:::mgf00 <at> earthlink <decimal-point> net Oakland, CA (USA) ** Respond only to this newsgroup. I DO NOT respond to emails ** -----BEGIN PGP SIGNATURE----- Version: PGP for Personal Privacy 5.0 Charset: noconv iQA/AwUBSSsUjoechKqOuFEgEQL+dQCfYUSwXFtPj0RRSZO+q3J8lQCD0/UAniRz JKu0h9AG0BAg8W3wC/0BC7B3 =Kvva -----END PGP SIGNATURE----- On Nov 24, 2:54=A0pm, MGFoster <m...@privacy.com> wrote: > zufie wrote: > > Why do my Forms/Subforms in my MS Access Database not appear? > > > All I see is the boxes where they should show?! > > > What did I do wrong? > > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Probably there isn't a name of a form in the sub-form's Source Object > property. =A0Also, the Link Child Fields and the Link Master Fields > properties...

Making a form control the criteria for the sql statement of another control (Access 2003)
I have two comboboxes on a form. Combobox1 uses field1 in another table as its source of data. What I want to do is to enable combobox2 to use field2 in that table, but only to show the rows of data that contain the item selected in combobox1. At the moment I can easily write a SQL statement with a WHERE clause, but I only know how to specifiy static criteria. What I want is a variable criteria, where the criteria is the data contained in combobox 1. Is this possible? thanks for any help :) Ste "SteMc" <google@jasmonio.supanet.com> wrote >I have two comboboxes on a form. Combobox1 uses field1 in another table > as its source of data. What I want to do is to enable combobox2 to use > field2 in that table, but only to show the rows of data that contain > the item selected in combobox1. > > At the moment I can easily write a SQL statement with a WHERE clause, > but I only know how to specifiy static criteria. What I want is a > variable criteria, where the criteria is the data contained in combobox > 1. In the AfterUpdate event of ComboBox1, specify the Row Source of ComboBox2 as a SELECT query. So if the first combo selects the state, then the second combo of cities is filtered by that state: Private Sub cboState_AfterUpdate() Me!cboCity.RowSource = "SELECT city_id, cty_name FROM city WHERE city_state = ' " & Me!cboState & " ' " Me!cboCity.Requery End Sub -- Darryl Kerkeslager ...

Open Form in Ms-Access from a hyperlink by using dhtml control
Hey ! I'm having a little ms-access application problem. in form A I have a dhtml control which I'm trying to assign it's documentHtml property a html string. I want that the html string will contain a hyperlink which open another form in access. Can I do that ? David ...

Making sure MS Access scrolls properly in subforms/controls
Dear forum, In my database, I have one instance where a specific collection of 7 forms are expected all at one time, so I tried to build an entry screen where the entry form for each individual form is present as a subform in a tabcontrol in one main form, to make it easier for my unit's Data Entry Officers. Unfortunately, there seems to be a problem with scrolling that I have been resolve, probably caused either by the tabcontrol or the subforms, since it does not occur when the form which was used as a basis for the subform is opened individually. This problem is that where the individual subform is longer than the screen allows, the page does not scroll down when fields below the screen are selected (so that when the field at the bottom of the screen is exited by pressing tab, or enter, or by an autotab or skip, the next field is selected without the screen scrolling down). Does anyone know how to fix this? Best regards, Patrick Not to worry - have sidestepped the issue by breaking up the content of the subforms among further tab controls (which now means that I have tab controls in subforms in a further tab control ... sigh). Patrick ...

Form layout question: How move controls in a Form to (in) a Tab Control?
Hi, I created a form with a lot of controls on it. (textboxes, pulldown's etc.) Because the form is a little full I want to move the controls to different pages on a tab control. HOW can one do this?. If I drag them the tab control is not 'activated' if the mouse pointer is above the tab control. (if one creates a new textbox and place it on the tab control this tab control page turns black to show it's activated) This does not work while dragging??! Thanks in advance, Eddie Smit Holland. (The Netherlands) >Because the form is a little full I want to move the >control...

MS Access 2002
MS Access 2002 - query form control returns funny symbols like [][] I am running an append query on a form. Access is having trouble with the calculated fields and comboboxes. Example &#8211; referring to forms!FormName!ControlName within the query should return the value of that control, correct? I am receiving symbols such as boxes [] or [][] as well as Chinese symbols. Any thoughts as to why this is happening. thanks This happens if Access does not understand the data type of the calculated controls. Typecast the calculated fields, and set the Format of unbound controls. For ...

MS Access 2000 VBA Code Shows Totally Incorrect Date from Controls on a Form
Hi, Sorry for my English. English is not my native tougue. I am working in MS Access 2000 with a SQLServer 2000 Backend database. MS Access 2000 is my GUI front end that has SQLServer linked tables in it. One of my forms has two TEXT BOX controls formated as Short Date. The form is binded to a linked table. The linked tables has about 7 records and one of the control is binded to a table field. These two controls displays the date correctly as 01/07/2006 and 31/07/2006 (I am running Windows XP, my regional setting is set to English Australia, location is set to Australia, language for non-Unicode programs is set to English Australia, and my date format is set to d/MM/YYYY) when the form is running. I have some VBA code behind the form to print out these two dates to a text file. The dates show up as 30/12/2005 and 30/01/2006. I really do not know why these dates are totally different. Here's my VBA code: Open "C:\Results.txt" For Output Access Write Lock Write As #1 Print #1, "GL run from "; Me.txtFromDate; " to "; Me.txtToDate Print #1, "" :: :: Close #1 I am hoping some one has come across with this problem. Thanks in advance, Easystart oh, so you mean you're just outputting everything to a text file? My guess is that since MS stores all it's data in US format, your have to force it into Australian format when you write it to the file. What happens if you use Format() and force it into the format you want? T...

Controlling order of processing controls on a form
I am using a RecordSet to assign each persons name from the RecordSet as the ControlSource of a TextBox. There are about 50 names and about 84 controls, so there intentionally will be blank controls. These controls are arranged as a seating plan in a dining room. All works OK except I cannot establish in which order the controls are accessed in a loop:- For Each Ctl in Me.Controls .... .... Next Ctl. I Assumed the sequence would be in TabIndex order, but it isn't. Does anyone know how order they are processed in is workrd out, or more importantly how I can force them to be processed in the required sequence? The Control names are like Place0101 ' TABLE No 1, Place 1 Place0102 ' TABLE No 1, Place 2 Place0103 ' TABLE No 1, Place 3 .... Place0327 ' TABLE No 3, Place 27 That is the order I need to assign the names Many thanks Phil "Phil Stanton" <phil@myfamilyname.co.uk> wrote in message news:f_Odnf2iR9G3-BLUnZ2dneKdnZydnZ2d@posted.plusnet... >I am using a RecordSet to assign each persons name from the RecordSet as >the ControlSource of a TextBox. There are about 50 names and about 84 >controls, so there intentionally will be blank controls. > > These controls are arranged as a seating plan in a dining room. > > All works OK except I cannot establish in which order the controls are > accessed in a loop:- > > For...

How to control access time
Hello, I am looking for a software to limit my kids access time for PC (Windows XP service pack 2). I wish a software can config my kid can login 2 hours during weekdays and 4 hours during weekends. They can login several times a day, as long total login time less than the limit will be OK. Should be 128-bit encryption. passwd for sys admin, so they can't decode my passwd. If total login time more than 2 hours or 4 hours, will auto logout for them. Then I don't need to yelling to them. If you know such software or already existed in XP. Please let me know. I need to enforce the rule...

how to access database control of many oracle10g database instances on same server
I am on Redhat Linux 9 and using Oracle 10G (10.0.1.3?). I know how to create a Oracle database instance and use EM database control to administer the database. To access database control from a browser, Oracle asks to enter a URL: http://server_name:5500/em The URL does not specify the ORACLE_SID. I however want to create several database instances on the same box. Will Oracle automatically set up a different port (e.g., 5501) for second instance. All the documentation I have found on Oracle's web site refers to a single database instance on a server. Appreciate any pointers. Thanks a lot, Prem You need to read about Grid Control. Actually when you create your database using DBCA, it should ask you whether you want to use Grid Control or DB Console. Jining Han Jining Han wrote: > You need to read about Grid Control. Actually when you create your > database using DBCA, it should ask you whether you want to use Grid > Control or DB Console. > > Jining Han I hae read about Grid Control, but I think there is still a way to access many instnaces on the same server using database control. Prem Of course you can, a DB Console for each database, and you can choose that as your preferred approach, too. But I really think it's a waste of resources and a big inconvenience. You are probably better off with the "tradictional" desktop console. Just my 2 cents. Jining Han <premmehrotra@hotmail.com> wrote in message news:...

Valve control
Hello, I am still trying to figure out a method of controlling a discharge valve for compressor testing.&nbsp; The valve is controlled by a slider, but when it hits a certain point of being closed, the compressor surges.&nbsp; At that surge point, I want the user to click a button, and then have the valve slowly open while the data is being sent to&nbsp;a file.&nbsp; This way, the data is recorded and the valve opens to prevent damage to the compressor all at the click of one button.&nbsp; I have the VI up and running, all except for the opening part of the valve.&nbsp; I have included a simple example of where I am going with the valve control.&nbsp; Any advice would be appreciated, for then I can implement that code for the valve opening into the rest of my programming. &nbsp; Thank you, &nbsp; &nbsp; Jmc Valve control.vi: http://forums.ni.com/attachments/ni/170/198874/1/Valve control.vi ...

OT: MS Access runtime wants to control all MS Office charts
Office 97, Access 97, Sagekeys scripts. In addtion of Access 97, my runtime package is installed too. This is an old application that has been running since 1998. The customer is happy with it. I have a glitch in.... Powerpoint 97. When an user double-clicks a chart, it starts my Ms Access Runtime Installer! It will do the same if he right-clicks and uses 'Edit'. If he selects 'Open', it will do it in a separate windows and it is Ok. Thius probably comes because MS Chart is shared among office apps. I would really like to have this problem even if there is a turnaround and I have the feeling that the solution should be in the registry, but I can't find where. Any help appreciated. TIA. "saintor1@hotmail.com" <saintor1@hotmail.com> wrote in news:1183816847.132126.79420@c77g2000hse.googlegroups.com: > Office 97, Access 97, Sagekeys scripts. In addtion of Access > 97, my runtime package is installed too. > > This is an old application that has been running since 1998. > The customer is happy with it. > > I have a glitch in.... Powerpoint 97. > > When an user double-clicks a chart, it starts my Ms Access > Runtime Installer! It will do the same if he right-clicks > and uses 'Edit'. If he selects 'Open', it will do it in a > separate windows and it is Ok. Thius probably comes because > MS Chart is shared among office apps. > > I would really like to have thi...

Access Controls in Access
How on access can you set access controls to your users? If they log in with one username and password they can just read information and if they log in with another username and password they can read and write? I have no idea how to do this, is it even possible?? Thank you Try playing with the access security tool, you can add users, groups, passwords, read/write allowances etc. to your database using that. Its under the 'Tools' menu of Access. Brian wrote: > Try playing with the access security tool, you can add users, groups, > passwords, read/write allowances etc. to your database using that. > Its under the 'Tools' menu of Access. Playing is not the proper word for it. I would never "play" with installing security without a backup copy of the System.mdw file or a backup of the application. You should also recommend the SecFaq when "playing" with security. http://www.mvps.org/access/resources/techpapers.htm. Dangerous http://www.youtube.com/watch?v=ASIVv_LiBoU Yeah i suppose playing wasn't the correct word for it. Hey Thanks for both your help. I'll try that. "Hanny J" <hannyjones@aol.com> wrote > Thanks for both your help. I'll try that. Note that a well-versed author and authority, Roger Jenkins, back in the days of Access 2.0, characterized Access' Security as "labrynthine". It has not gotten any less complex, and I caution that, while it is "doable&qu...

Loading form ---- time between Form Current event and Control Enter event
I have set up speed testing. I noticed that the majority of the time to load the login form (the form listed in my startup) is between the Form's Current event and the first control's Enter event. It's between 1 - 6 seconds between the two, which is by far the most time intesive part of the startup process. Are there any events that come between these two? I thought they were connected, and would be nearly simultaneous. I checked the control, it's first on the tab order. All my controls on the form are unbound. I even removed the images I had stored on the form --- all without a major decrease in time. Am I missing anything? Thanks -- Phil Message posted via http://www.accessmonster.com ...

[rfc-dist] RFC 5417 on Control And Provisioning of Wireless Access Points (CAPWAP) Access Controller DHCP Option
A new Request for Comments is now available in online RFC libraries. RFC 5417 Title: Control And Provisioning of Wireless Access Points (CAPWAP) Access Controller DHCP Option Author: P. Calhoun Status: Standards Track Date: March 2009 Mailbox: pcalhoun@cisco.com Pages: 6 Characters: 11551 Updates/Obsoletes/SeeAlso: None I-D Tag: draft-ietf-capwap-dhc-ac-option-02.txt URL: http://www.rfc-editor.org/rfc/rfc5417.txt The Control And Provisioning of Wireless Access Points Protocol allows a Wireless Termination Point to use DHCP to discover the Access Controllers to which it is to connect. This document describes the DHCP options to be used by the CAPWAP Protocol. [STANDARDS TRACK] This document is a product of the Control And Provisioning of Wireless Access Points Working Group of the IETF. This is now a Proposed Standard Protocol. STANDARDS TRACK: This document specifies an Internet standards track protocol for the Internet community,and requests discussion and suggestions for improvements. Please refer to the current edition of the Internet Official Protocol Standards (STD 1) for the standardization state and status of this protocol. Distribution of this memo is unlimited. This announcement is sent to the IETF-Announce and rfc-dist lists. To subscribe ...

How to access only boolean control value that is part of a cluster of controls
I have created a set of boolean controls in a cluster. Is there a way to access only one of the boolean control (i.e. "stop" button) so that I can change its states in the program, indepent of the rest of the boolean controls in the same cluster? &nbsp; Thanks! &nbsp; -NewUser2007 NewUser2007 wrote:-once I unbundle the boolean clusters and selected the stop boolean, how can I "wire a new value" to it (since it was created as a boolean control).&nbsp; I never said anything about "unbundle"! There is a 180� difference between "unbundle" and "bundle". :) You only need to unbundle if you want to know the current value, this is not needed if you want&nbsp;to write a new value regardless of what the current value is. &nbsp;<img src="http://forums.ni.com/attachments/ni/170/287328/1/clusterModify.png"> Message Edited by altenbach on 11-29-2007 08:20 AM clusterModify.png: http://forums.ni.com/attachments/ni/170/287328/1/clusterModify.png ...

Accessing form control elements
Assuming you have a typical form built in this manner: <form action="..."> <p><input id="idInputText" name="nameInputText" type="text" size="20"></p> <p><input id="idCheckbox" name="nameCheckbox">optional</p> <p><input id="idRadio1" name="nameRadio">yes<input id="idRadio2" name="nameRadio">no</p> <p><select id="idSelect" name="nameSelect"><option value="a">a</option&...

Check box controls subform control source formula
I have a subform for listing parts. It has fields including: ClaimID, ITEM, NET PRICE, LIST PRICE, Quantity, Supplier, and a calculated field called Part Total. The subform is based on a query. The Part Total field is calculated as (=[tblParts].[NET PRICE]*[tblPartPerClaim].[Quantity]). Then there is a hidden text box on my subform that calculates the sum of all the Part Totals for each claim. There is another field on my main form set equal to this field on the subform. My question is: Can I have a check box on my main form that, if checked, would apply a formula to use the LIST P...

Set form.control equal to subfrm.control before update
Here is what i have: (access 2000) tblOne: SampleNumber,LinkNumber,LinkSchedule (and other misc) tblTwo: EmpID,LinkNumber,LinkSchedule (and other misc) frmOne recordsource = tblOne subfrmTwo recordsource = tblTwo When i enter a LinkNumber in frmOne, it filters all of the records in subfrmTwo with the matching LinkNumber. LinkSchedules will be different, so there will be multiple entries with the same LinkNumber in tblTwo. After i enter a LinkSchedule in subfrmTwo, i would like it to update tblOne.LinkSchedule. Any thoughts or suggestions? ...

Control positioning on form resize
Hi I'm writing the code so that when one resizes or maximises the main application form at runtime, the various controls reposition and/or resize accordingly. This is working fine except for one thing: On the form I have a frame and inside the frame a vertical scrollbar located at the right-hand side. Resizing the form means that the frame width & height has to change, and therefore the scrollbar's left position and height also need to be changed. This works fine if one resizes the form by dragging the corner, however if you hit the maximise button the frame size adjusts c...

MS Access Stock Control
Hi Guys, I am doing a stock list of Printer tonors, with the following tables Printer_tonor_Stock Tonors Printers ----------------------------- ------------- -------------- RecordID TonorID PrinterID PrinterID Tonor Printer Name TonorID Colour Serial Number Date Stock Model DepartmentID I have done a form with th Printer_Tonor_Stock Table, basically what I want is, when I fill out a record (combo box of TonorID), i want a query (or 2) to say if the Printer_tonor_Stock.tonorID = Tonors.TonorID, then Tonors.Stock should = Tonors.Stock-1. How can I put this into a query pleeease Help!! (the results will be shown at the bottom of the Printer_Tonor_Stock form). Also please excuse my bad database design as I am just a lowly Helpdesk guy :o( Thanks in advance Phreake I would change your database design slightly Phreake, You should not be storing stock as a number. It should be a calculated field. Try the following site for example data-models: http://www.databaseanswers.org/data_models/index.htm They don't have an exact match but any stock control model should suffice. Failing that try butchering the Tradewinds example database which ships with access. HTH John. "Phreake" <phreake@hotmail.co.uk> wrote in message news:1143714918.673460.293590@e56g2000cwe.googlegroups.com... > Hi Guys, > > I am do...

Wish to display in an unbound control when focus moves from control-to-control
Short of inserting code similar to that shown below in the OnGotFocus event property for each and every control on the form, is there a form-level event I could monitor firing similar code. I don't want to sprinkle code all over the form if I can do what I want in a single place. Dim ctlCurrentControl As Control Dim strControlName As String Set ctlCurrentControl = Screen.ActiveControl strControlName = ctlCurrentControl.Name Me!ctlWhereIsFocus = ctlCurrentControl Hi MLH, To investigate this yourself all that you is put code behind each of the form events that says which event is running. Then see if there is one that fires when each field is updated. Good luck, Nick MLH wrote: > Short of inserting code similar to that shown below > in the OnGotFocus event property for each and > every control on the form, is there a form-level > event I could monitor firing similar code. I don't > want to sprinkle code all over the form if I can > do what I want in a single place. > > Dim ctlCurrentControl As Control > Dim strControlName As String > Set ctlCurrentControl = Screen.ActiveControl > strControlName = ctlCurrentControl.Name > Me!ctlWhereIsFocus = ctlCurrentControl Have a look how I accomplished this here: http://www.lebans.com/conformscurcontrol.htm ContinuousFormsCurrentRow.zip is a class that allows you to programmatically access the contents of a bound control, as the user moves their Mouse, but the control does not have the f...

user control in Access database file ?
Hello!!! Can i add a user control in Access database file (mdb)? I want to make o form in an mdb file and i want to add my button. Hope You can help me. Thanks ...

Jump from a Form to a control (filed) in a SubForm
Dear reader, How can I jump from a field in the master Form to a field in the sub Form. I have tread DoCmd.GoToControl (Forms!MasterFormName!SubFormName!Form.FieldName) But it doesn't work. Thanks for any help to fix this. Kind regards, Simon van Beek Simon: In my experience, you first must go to the subform control, then to the field within that control. Try this, instead: DoCmd.GoToControl "SubFormName" DoCmd.GoToControl "FieldName" The GoToControl action has an inherent reference to the current active form, which is why you cannot reference outside of the active form's control collection. For more details, search the VB help file for GoToControl Action. From the Access 97 VB help file: "Tip: You can use the GoToControl action to move to a subform, which is a type of control. <snip> You can also move to a control on a subform by using the GoToControl action to move first to the subform and then to the control on the subform." If you are not starting your jump from the MasterForm (i.e., your active form is a form other than the MasterForm), you'll need to first set the focus to the subform control on the MasterForm, and THEN go to the desired control, like this: Forms!MasterFormName!SubformName.SetFocus DoCmd.GoToControl "FieldName" HTH, Jana ...

Web resources about - Resize Form Controls and Subform Controls at the same time - comp.databases.ms-access

Control - Wikipedia, the free encyclopedia
Text is available under the Creative Commons Attribution-ShareAlike License ;additional terms may apply. By using this site, you agree to the ...

From Armenia to Australia, how the mob controls the trafficking of ice into Australia
In America, they are called the "Five Families". The term refers to the five major New York organised crime families of the Mafia, with a history ...

From Armenia to Australia, how the mob controls the trafficking of ice into Australia
In America, they are called the "Five Families". The term refers to the five major New York organised crime families of the Mafia, with a history ...

From Armenia to Australia, how the mob controls the trafficking of ice into Australia
In America, they are called the &quot;Five Families&quot;. &nbsp;The term refers to the five major New York organised crime families of the Mafia, ...

How-To: Reduce iPhone screen brightness beyond what’s possible in Control Center or Display & Brightness ...
... about sharing in the past, involves reducing iPhone screen brightness beyond levels that are possible with the standard brightness slider controls. ...

Stagefright-based ‘Metaphor’ exploit can take control of your phone in just 15 seconds
The old Android malware beastie is at it again, with researchers uncovering a new Stagefright-based exploit that can be used to take control ...

Creative Control explores the dark side of augmented reality—with humor
... Here's what the future looks like: collecting data on people while wearing AR glasses. 7 more images in gallery In the film Creative Control ...

4 Ways to Control Your Mind and Lose Weight
... after a week of eating the same things. I have found that almost anytime I have plateaued, a cheat meal has broken the plateau. Gain Control ...

The Latest: Officers regain control of Alabama prison dorm
MONTGOMERY, Ala. (AP) — The Latest on the disturbances at a prison in Alabama where inmates have stabbed each other and prison authorities and ...

MIT, Harvard researchers push new way for users to control access to personal data
Cryptography researchers at MIT and Harvard have developed software called Sieve that is designed to help users keep track of encrypted personal ...

Resources last updated: 3/21/2016 6:48:18 AM