Search results

  1. S

    How to check for primary key violation

    I have a table with a primary key composed of two fields (Name and Class). I have a form that allows me to select a Name and then view all the classes they have attended. I can edit these classes or add new ones. In the Class field, if I type in a class that already exists for that name, I...
  2. S

    Record lookup and autocreate new record

    Ok, so I have a form that has a drop-down box named "Name_Select" used to select personnel listed in a table. In the After Update event I have a macro that does: SearchForRecord ="[Name_Last_First)] = " & "'" & [Screen].[ActiveControl] & "'" Basically, the drop-down box references the table...
  3. S

    Simple Form Filter

    I have a form that tracks employee training. I have one form that is used to add training records (which works fine) and another for updating/deleting records (which is causing me problems). In the form, I have the attribute "empName" located in the form header. In the detail section, I have...
  4. S

    Conditional Changes?

    I have a database that is used by half a dozen users and reviewed by one. One of the fields in most of the tables is a Yes/No control field called "New/Edited". This field is not visible in the forms that the users have access to and defaults to "Yes". This way if a new record is created, the...
Back
Top Bottom