Search results

I used the backup/compact sample from Roger's Access Library as the base of a backup system for my database. The problem is, the database I'm working with is passworded. The following code works perfectly when the password is removed: Public Function cmdCompact() On Error GoTo Err_cmdCompact...

I'm trying to implement multi-field search of a single table. Here is what I have now: Private Sub cmdSearch_Click() Dim strFind As String, strWhere As String If Len(Me.entryidsearch & vbNullString) > 0 Then strWhere = strWhere & "tblEntry.entryid=" & Me.entryidsearch End If...

I have a multi-select list box for selecting which faculty members apply to a project. The faculty table and project table are linked in a many-to-many relationship. I have the following code which should create entries in the link table: Private Sub Command5_Click() Dim varItm As Variant...

I have an inspection checklist with drop down selection boxes, each of which has an incorrect response. If the response is incorrect, the field is highlighted and the user inputs an explanation in a memo field. I need to be able to either print out a list of all the problems and their...