Search results

I have a table with staff id #s and names and a table with 5 dates. I have a dropdown which gets populated with the dates based on the staff id. For example, employee (EE) 157 lists 5 dates, because he hasn't used any dates yet. But, EE 160 lists 4, because she has used one. I hope this...

Can someone please look at the following code and explain why it's duplicating records in my MS Access database. THANX IN ADVANCE for your help!!!! ' FOR SAVING DATA TO THE DATABASE ******************************************...

Access 2007 -- LOVE IT OR HATE IT??? I have a macro: SetValue Item: User Expression: CurrentUser SetValue Item: LastUpdated Expression: Now() The macro is called "Last Modified", and I have it set to the After_Update property. I have even tried the following: Private Sub Form_AfterUpdate()...

I have a "New Entry" form which pops up a msgbox when a duplicate name is entered. Is there a way to pull up a listbox of the potential matches? The user should be able to select the correct one, and either double-click or hit a yes button, which would take the user directly to the selected...

The highlighted line is where the problem lies. I've made sure MS DAO 3.6 object library, VB for Apps, MS Access 9.0 library, OLE automation, and MS Data ActiveX Data Objects 2.1 Library under Tools---->References are all selected. What am I missing or doing wrong? Thanx in advance for your...

First, let me say, I've searched and searched, and have been trying to make sense of all the posts, but they all seem to point to reports and not forms. What I'm trying to do is simple. On my main form, I have a checkbox called 'Inactive'. I have an Activities subform, which has a Class Date...