Recent content by SubMatrix

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

Ok, well it took me trying roughly 20 variations of "" and [] but I got it to work: If IsNull(DLookup("Name_Last_First", "table2", "[Name_Last_First] = [Forms]![Form1]![Name1]")) Then Hope that at least this will help someone else in the future.

Possibly to save some time, I found out how to place the code in vba, I just need a way to see if the record exists or not. Here's what I have so far: Private Sub Name1_AfterUpdate() Dim SaveName As String SaveName = Name1.Value If the value of Name1 does not exist in table2 then...

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

Is there a way to do it without a subform? For one, the attachment field doesn't seem to work correctly in a subform, it breaks it down into like five different parts. Secondly, the little bit I did get working displays all the records in a visually traditional form view which while...

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

The field was never added to the form as the field was added after the form was created. The form is based off of a query which is used as a source for other forms and reports. When I went to add the field to the form it said that it would have to create a new query and no longer use the old...

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