Using VB6 and Access 97.
I want to send a date range across to a query that I have already created in access, but I am having no luck. Here is the code I've got so far.


adoCommand.ActiveConnection = dBase
adoCommand.CommandType = adCmdTable
adoCommand.CommandText = "qryNotSeen6MonthP1"
Set adoParam(1) = adoCommand.CreateParameter
adoParam(1).name = "VALUE"
adoParam(1).Type = adDate
adoParam(1).Value = "02/09/99"
adoCommand.Parameters.Append adoParam(1)
Set adoRecord = adoCommand.Execute
MsgBox adoRecord.RecordCount

This is only trying to send the first part of the date across and even this doens't work.


------------------
Thanks in advance for any help provided.