Parameter Query

  • Thread starter Thread starter Steve S
  • Start date Start date
S

Steve S

Hi:
I have an Access 2003 adp app. I want to create a parameter query based
form where the operators (eg. "like", "between", <, >, =, etc...) are
contained in a combobox on the form so they can be assigned at the form
level rather than within the parameter query. I also want to have a text
box beside the operator combobox to input criteria. Can you help me do
this?

Thanks in advance,
Steve S.
Madison, MS
 
Make the parameter in the SQL, assuming SQL Server, the syntax can be found
in Books Online. (BOL)

Code like this will assist you:

com.CommandText = "proczTempEmployeeUpdate"
com.CommandType = adCmdStoredProc
com.Parameters.Append com.CreateParameter("@AvailWorkHours", adDouble,
adParamInput, 8, dblAvailableHours)
com.Parameters.Append com.CreateParameter("@OTPercent", adDouble,
adParamInput, 8, dblOTPercent)
com.Parameters.Append com.CreateParameter("@OTAvailableHours", adDouble,
adParamInput, 8, dblOTAvailableHours)
com.Execute
 
Back
Top