Recent content by Imb

That is why I use underscores for objectnames: for display purposes replace the underscore by a space.

I wonder why you want to do that. If the user-defined properties are used for selection, it is as loosing a search key. For (filtered) selection you have to process ALL files to find a matching property.

Hi BlueSpruce, At first sight of your diagram I thought that that all six related tables had the same structure, and thus ould be handled in the way of the Music sheets. But then I saw it was only a mockup diagram, and all related tables have a different structure. I agree, it is quite...

Are you seeking something like this? I have worked on an application with some 10,000 documents as Music sheets. Filenames and filepaths are stored in a Sheet_tbl. There is a 1:m relation to a Feature_tbl. The Feature_tbl contains all kind of features regarding the Music sheet, like componist...

@Edgar_ I only use unbound forms, and to be specific, only two for all applications. Binding is necessary for the control to know where to get its information, or where to store it. In my applications I use a "dynamic" bonding, that is, in the Enter event of any control the whole binding and...

This is the way I build my applications, completely event driven. I don't use Classes, but just "THE" Control. During the load of the form a reference is made to a metadata table, that holds the description of how the control should behave, including the corresponding table and field, to get...

The way I work with my dynamical forms is I think in line with class module code, but without the formal declarations. On of my first attempts, some 20 years ago, was a calender form, and is still actual. It is still based on a predefined form, with the controls "on their place". It is activated...

I usualy do it in the Open event of the (sub)form, after all controls are defined. Then I do a Resize of the form, and depending of the number of records (continuous) or controls (unbound), the Scrollbars are defined. Imb.

I have no problems with Scrollbars. In a main form I use: HB_form.Scrollbars = 2. in a sub form I use: HB_sub.Form.Scrollbars = 2. Imb.

Hi Edgar_, Yes, about the English/Dutch mix, it needs still some upgrading, but as far as I can see that is not a big problem. The end form is perhaps a little misleading. The left part shows the "menu" with Items, the only one being Contacts. In the right part you would see the contents of the...

Hi Edgar_, It wouldn't suprise you that I have a "Database of Databases", which contains all my applications. It is a.o. used for contact information towards the user(s). But this application also has tools to analyze all applications. Since application specific information is only stored in...

Hi Edgar_, In general you are heading in the right direction, in detail it is a little different. It is now late here, and it will take me too long to explain my way of working, but tomorrow I will come back. Imb.

Let me try to describe in short how the dynamical forms work. Some parts I will skip on the moment, because it will disturb all the readers too much, I suppose. I have a table "A_Veld_tbl" with all the fields from all tables in the application. See before. I have also a dynamical form with only...

No, the form is already build, only filled on the fly. And that in any way that is handy for the current problem. I like Access the same way as you do, but if you manage many, many applications, maintenance becomes a problem, because each application is in a far extent independant of the other...

Hi Mark_, Yes, I know, but that is not the point. The point is when you start your 4th, or 5th ..., application that needs a postal database, and moreover the current systematics "must" be extended, then you have quite a lot of copy/paste work. Better is to have one shared system. When...