To register for an Internet.com membership to receive newsletters and white papers, use the Register button ABOVE.
To participate in the message forums BELOW, click here
I am trying to use a select statement in the vb6 dataenvironment. I am trying to use a between statement to retrieve records between two dates inputed into text boxes.
ex: select *
from expenses
where [date]between '"txtdate1.text'" and '"txtdate2.text'"
This will not work, and I have tried different ways to express the text boxes with no results. ANY answers??
Please note that the .text property is set to NULL when the focus is not on the specified control. When the focus has been moved from a textbox the .value property is set.