I am using Access 2007 AND Adodc. [Date] is a field in my table1.What is the code for getting a record on a particular date?
kaippilly
0
Newbie Poster
Recommended Answers
Jump to PostMake a select query with a WHERE clause pointing to the date. In the code below I assume your Adodc object's name is Adodc1
Adodc1.CommandType = adCmdText Adodc1.Rcourdsource = "SELECT * FROM table1 WHERE Date = #" + yourdate + "#" Adodc1.Refresh
Note that the # sign …
All 2 Replies
Reply to this topic
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.