extract data from combo box n use it in SQL

[benj]

not sure if i got the right forum

I have a form created by VBA, and on the form I have a combo box where
the user can specify the month and year. I need to retrieve data from a
database using SQL but i require the input from the combo box to be part
of my condition in my SQL statement to retrieve the data. so any idea
wat is the syntax for writing a SQL statement with the consideration of
the input from the combo box?

right now i have 2 combo box. 1 holding the months, the other holding
the year

SELECT b.OrgID, a.OrgName,eventDate, FROM tblossevent AS b, tbOrg AS a
WHERE eventdate BETWEEN convert(varchar,getdate()-30, 106) AND
convert(varchar,getdate(), 106)

this is wat i have initially
but i wan the eventdate to be obtained from the input of the combo box.
how shd i change my sql coding?

 

[Oliver Ferns via OfficeKB.com]

Hi,
I would hardcode the SQL Statements (Select, From, Where, Between) in to
Global variables as such....

Private Const sqlSelect As String = "SELECT b.OrgID, a.OrgName, "
Private Const sqlFrom as String = " FROM tblossevent AS b, tbOrg AS a"
Private Const sqlWhere as String = " WHERE "
Private Const sqlBetween as String = " BETWEEN convert(varchar, _
getdate()-30, 106) AND convert(varchar,getdate(), 106)"

You can then construct your SQL statement fairly easily with the following
syntax:

Let strSQL = sqlSelect & sqlFrom & sqlWhere & YourVariable & sqlBetween

Then you can use strSQL as your SQL string!
Does this help?

Oli

 

[Jamie Collins]

SELECT b.OrgID, a.OrgName,eventDate, FROM tblossevent AS b, tbOrg AS a
WHERE eventdate BETWEEN convert(varchar,getdate()-30, 106) AND
convert(varchar,getdate(), 106)

What data type is your eventdate column? You seem to be converting your
parameter date values to text. Perhaps this is the source of your
confusion.

Jamie.

--