Search results

Hi I'm using the following code and it works initially when a few records in a listbox (ListFrom) are selected but then I'm greeted with 'invalid use of null' when I run it a second time. The strange thing is that when I set the Multi Select property of the listbox to 'Extended', the code...

Hi I've got the following code (following good advice on this forum) but now realise that I need to check for duplicates in the listbox where the NameofEmployee and Department are equal (other columns in the listbox with different values so the records aren't exact matches). I need the Insert...

Could someone please assist. Following code generates the run-time error '3421' Data Conversion Error at line: Set rst = qdf2.OpenRecordset("SELECT EmployeeName FROM EmployeeQuery WHERE EmployeeID=" & strWhere3). EmployeeID is an autonumber PK, I've also tried declaring strwhere3 as an integer...