Recent content by PAH

I'll try that, but I'm posting this Even before trying. I used a list box on a form which allowed you to choose multiple items. I then used a command button to "send" it to a text box also inserting the OR in between each. I then used the text box to reference for the Criteria in the Query, but...

That article confused me to no end. Why would the query work if I used multiple user input parameters, but fail if I used the InParam() "function" in my query? I've been trying to think of several different ways to allow me to use a form for the input without having to instruct users on all the...

I am running a query that uses the InParam function described multiple times on this site to allow users to choose multiple choices from a field on my table being queried. My problem comes if I add a second user input criteria. If I add a second user input For example between[Start Date?] and...

Are you doing this through Access? I've been trying to find a way to have an e-mail created using variables. As in - if an order changes send out an e-mail saying Order#[whatever order that changed] has changed, and possibly even attach a snapshot report.

Put the following expression in your query: InParam([stud_id],[Enter ID#'s Separated by comma]) Then do the following. Copy the following Code to a module named basInPram Function GetToken(stLn, stDelim) Dim iDelim As Integer, stToken As String 'Searches for commas as a...