troubleshooting Question

Date field in MS access stLinkCriteria

Avatar of subathira
subathira asked on
Programming
2 Comments1 Solution574 ViewsLast Modified:
Hi,
   In my MS access 2000 application i have a form 1. There are three fields on form 1 as Start date  end date  and Status.If status value is selected all records between the start date and end date for the corresponding status to be retrived and displayed in Form 2. If no status is selected then all the records for the date range to be displayed.
How to achieve this using stLinkCriteria. I was able to open the Form 2 for the date range. Can some one can give me the syntax of passing the text values to check the date field in stLinkCriteria.
Thanks,
suba
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros