Recent content by Techworks

ok figured out why not working. Obviously most of the examples out there are not real world solutions that work as they have flawed code. I finally managed to find one example that was different and it works. The rst.GetRows line need to specify how many rows to return, so should look like...

I have the following code to populate a listbox in Outlook from an MS Access database table ------------------------ Dim db As DAO.Database Dim rs As DAO.Recordset Dim strSQL As String Dim rsArray As Variant strSQL = "SELECT tbl_PJ_Project.PJ_Name...