Recent content by mikeyhend

Roy, Thanks for the answer, sorry for the late reply. The problem is solved, the array was something I tried to fill a label on a form in an excel worksheet some time ago. Thanks Mike

This code works if I use "SELECT * FROM table" I have tried using recordset: Dim SQL As String SQL = "SELECT * FROM query" Dim RS As New ADODB.Recordset Call RS.Open(SQL, CurrentProject.Connection) And tried using Command:(also tried with a parameter query, therefore still the parameter...

Hi, If I try to select the data from a query using ADO, as well by using Recordset as command object, it always returns an empty recordset. What I'm I doing wrong, or can I only select data by using a sql statement on a table instead of calling a query? Best regards, Mike