-->>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.
Jump to Post
You need to supply more information. Such as:
What is the actual subroutine/function declaration?
What is the actual statement that gets the error?
What are the actual control names?
What are the actual column names ("Date_Registered" <> "Date_Registred" <> "Date_Regitered")?
You can't seriously expect help if you don't supply real …
All 4 Replies
We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.