Search results

You want to be able to add more programs later, therefore the checkbox approach might be a bit tricky, since it must be stored in the database structure (yes/no for each existing program must be stored).

Completely without vba: Go to the table, where the user password is stored in design view. Select the field with the password, click on Entry format (hope that's what it shows in English Access) and then on the "...", you can actually select "Password", which does exactly what you want. Does it?

Quick&dirty: Go to design view table "Program_Contacts" Select both "ContactID" and "Program" rows and click on Primary key. This defines the combination of both fields as primary key, thus multiple entries of the same program under the same contactID are prohibited. Since this rule is...

I get a reproducible crash of Access (2002) when I use the attached form (simplified from my original problem) in the following way: - Open form "Feld", which contains a subform - Apply a form-based filter - Press refresh (F9) (vba code causes the same) Anyone a clue why this is so? If I...