Search results

It can be done, but it requires a different way of "binding". A "normal form" is (in the classical way) a form where the controls are bound to the fields of the RecordSet. This makes the form very static. The RecordSet dictates only how the data will be stored, and not how the controls should...

The problem with forms is that the controls are bound to the fields in the table. But a control is much more than just to store data, it should reflect how the user wants the control to behave, e.g. with BeforeUPdate and AfterUpdate events. This makes the form very static, and not sharable...

In this case you could modify the RecordSource of the report to include the filter.

What happens if you change the order of Me.Filter and Me.FilterOn? Unfortunately I can not test it myself, because I never use Access Reports. Nevertheless, sometimes the order of instructions is important. As an example, to select a part of a the text in a control, the setting of SelStart and...

A rather strange construction: two loops interwound. You could (better?) use: Dim rs As DAO.Recordset Set rs = Me.RecordsetClone Do While (Not rs.EOF) CurrentName = rs!Name CurrentAge = rs!Age '......Do something etc. rs.MoveNext Loop

I wonder, why do you need an VBE_Extras add-in, for something that can be restored on the spot?

It is an artefact of the editor. Just type somewhere Dim strsql and all strSQL is changed to strsql. The type somewhere Dim strSQL and all is restored to strSQL.

It is very instructive to explore the generalization of underlying processes in Access. It can go beyond the borders of standard Access. In that area AI can not help. It brings me to the question: Is standard Access - the way it is developped - the ONLY way to work with? Or are there other ways...

In earlier times I worked as a chemist in the research of semiconductors. The static memories still had to be "invented". When we had a problem or wanted to learn something, we did a "literature survey". Most of the findings were not relevant, and sometimes you said: "Hm, interesting". Not that...

I believe more in generalization and re-use of code than automatic generation of "duplicate" code. Imb.

As an alternative, without classes: When "any" control is entered, I write the control's value in the form's caption.

I really understand all these frustrations, and where possible, I work hard to improve the code for a better understanding of the principle of Late Control Binding. But we have not yet reached a common thinking. I will try to explain the principle as simple and as short as I can. When I want...

@tvanstiphout, Thank you for your nice words. First, our niches will be quite different. I suppose you are working with squaremeter-screens for high-speed data entry, my customers have mostly laptop-screens, and are more interested in to find the the right person that is called Petrus, of...

@isladogs, No, no explanation. Possibly the right part of the form is some remnant of some test for positioning. It is a loop through the Containers collection, with the Name of the Container, followed by the Count of the Documents in that Container. About your next question, I still work with...

@Albert D. Kallal, Thank you for your reply. Your definition of a re-usable control is completely different from mine. Referring to my definition you use duplicates of predefined controls, on a predefind form. So your forms are always dedicated to a certain situation. I have been working on...

@GPGeorge, In the meantime there is a little demo database uploaded, so you can see HOW things happen. One project is called "Archief", that tries to relate almost anything that "has happened" in a middle sized town with about 30,000 inhabitants, including persons, activities, addresses...

@tvanstiphout, I use only TextBoxes. But here is a difference of interpretation. In your classic model you can use a listbox to select a value, or a record. In my concept I do not use that. I use the TextBox as a really dummy control, with absolutely no user-information. It is just a...

@tvanstiphout, The PersonGroup_tbl is a junction table, and its fields are FK fields. That is a different "Veldtype" then some text. If you type a character (space or any other) then a new form is opened with the (filtered) records of the underlying Item, i.e. Person of E_group. If this form...

This is not the tone in a friendly forum, it is absolutely not constructive, and only denigrating. I will have to report this. You were trying to be funny?

No, I don't use user defined classes, no form classes, no control classes. I have (the same) form, with a number of dummy controls, that on opening the form, are placed, dimensioned and and layed-out according to their further meaning, defined by a Veldtype, and they get their initial value...