Recent content by Imb

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...