-->>Hi,I'm having an Access database (.mdb) with Members table and column Date registered just for an Example with datatype as text.
-->>Now I have an Interface that I need to use it to get all registered members within the specified range of dates by using the Datepickers (1. Is for From and 2. Is for To) datepickes and the results will be shown on the listview after clicking the Go button.
-->>So far I have the following code:
Call Load_Members("SELECT Date_Registered FROM Members WHERE Date_Registred >=#" & DPK_From.Value & "# And Date_Registered <=#" & DPK_To.Value & "#")
-->>The Call Load_Members is declared in the module
-->>But when I run the Application I get a Run time Error '-2147217904(80040e10)' No value given for one or more required parameters.
-->>On other hand I did the same thing by using ado and write the following code which did exactly what I wanted
If adoWeekly.Recordset.Fields("Date_Regitered").Value >= (txtStart_Date.Text) And adoWeekly.Recordset.Fields("Date_Regitered").Value <= (txtEndDate.Text) Then
-->>So iz it that I'm required to set the condition first or? Thanx in advance.