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 "whole" table.
But that was not so interesting, because the table has no records.
But if there were records, you could select the records on any field, on almost any condition.
The selected field is FirstName, default "beginning", but you can choose any condition from the column "Selecteer conditie".
The choices are:
beginnend = starting
gelijk = equal
bevat = contains
eindigend = ending
joker = wildcard
AND-woorden = two or more strings must be found
OR-woorden = at least one of two or more stringd must be found
tussen = between, in alfabetic order
heel_woord = string as a separated word
sound = primitive function on mostly consonants
Null
Not Null
This "Selection-form" is also used to select a recordset that is used as a substitute for comboboxes.
In your database there are only fields with Veldtype = "T" (String). You can choose any Fieldtype that is valid in Access.
But more! You can work with incomplete dates, or time-units (15 min, 5 min units) or more important: FK-fields.
These FK-fields connect al tables together, and are the basis for all Integrity control from the FE. That is, never need to go to the BE to control these things.
They also make that you can "walk" through the whole database, in one direction or the other, which makes the mainform/subform construction redundant, including all comboboxes.
Imb.
Last edited:
