-->>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 wantedIf 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.
Bile
10
Newbie Poster
Recommended Answers
Jump to PostYou 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
BitBlt
452
Practically a Master Poster
Featured Poster
Bile
10
Newbie Poster
QVeen72
104
Posting Shark
Bile
10
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.