Is there a 'catch all' way to select only the controls found within a specific section of the form... say I wanted to perform an operation on all the controls in the detail section of the form but not those found in the header or footer?
Any quick way (collection) to this solution?
Many thanks,
~Chad
well...mr. client man has decided that upon a click of a button, a job needs to be rendered "read-only". obviously, in order to acheive this illusion, i need to simply either lock or disable all controls on the form when that record shows up (when jobclosed = true or job cancelled = true). the problem is that there are around 500 controls. i know that there's some way to access the controls collection (Me.Controls(0), etc.) using the for each...next, but i've tried it and haven't been successful probably because i can't figure out the right way to do it. all i want to do is render each control as disabled (except for my subforms, i just want to lock them) when a button is clicked. does anyone know how to do this?
View 2 Replies View RelatedHi, I am quite confused with what actually is a "Collection" in MS Access. I am using Access 2002 by the way...
Thanks
I try to use collection of a ADODB.recordset eg rsTarget,Essentially I want to assign the fields (columns) in this rsTarget with respective data. I tried to use of
two sets. (fld as adodb.field)
Set fld = rsTarget.Fields.Item(count)
Set fld = rsTarget.Fields.Item(Column(count))
Then I try to use following to assign
RsTarget!fld.name = Data1
It failed stating that there is no fld.name. Using column set, it state that there is no column function. How to do it right?
I'm running a query that has a field where I need two criteria show up (regular collections and special collections). Another field I have selects for the date (10/1/2014). The last field is the sum of collections. My problem is that the query is generating regular collections and special collections with each date and a sum of collections. I need the total sum of both collections for the date which would be 4.
AGENCY_CODELINE_ITEMPCA_DATESumOfCOLLECTIONS/ACCOUNTSxxxRegular Collections10/1/20142xxxxspecial collections10/1/20142
Any way to make objects to support adjusting continuous form controls making them unique in a sense to be able to change info like captions or whatever.
I've been working with collections for a while now tapping into event handlers such as the mouse inputs and or sizing of objects real time using collections but I can't seem to nail down any un-documented way to serialize controls on a continuos form.
I have tried when the new user creates the record adding another control to the collections class tying it to the id of the record but still this does not seem to be enough.
I do not know if there is a paint method or something of the sort I can override to get the desired results and most people without even trying will tell you this can't be done but how many have said that you can't move and resize objects in access but we are doing that now...