How to convert Text values in Text Boxes to Integers and use them as parameters?

[lookingforK]

Hi,



I am using Query Design with MS Access 2007 to create a query for selecting/extracting a data set.

I make 2 text boxes named "Week From" & "Week To" on a form so that when I enter 2 numbers (but with Text type) in the text boxes and click a button running the query, I would get a selected data set for the specific period.

For example, when I enter "1" in "Week From" and 8 in "Week To", I should get the data set about the period from Week 1 to Week 8.

The problem is:
The data type of the corresponding fields in the table for "Week From" & "Week To" is Integer. So, I need to convert the 2 text boxes from Text to Integer or Number.

I try to use the function Cint (please see below) in the query, but get error message.
* <=CInt([Forms]![Extract Data]![Week To])
* >=CInt([Forms]![Extract Data]![Week From])

Why? How to convert the Text values in Text Boxes and use them as parameters in the query?


Thank you in advance.

[June7]

What is the error message? Why do you show * in the examples?

Conversion with functions should not be needed. Because the fields are number type the code should do an implicit conversion of the entries and as long as no alpha characters are encountered, should run just fine. Same goes for entering a date into a textbox as criteria for a date field.

[lookingforK]

Thank you.

I even tried Forms]![Extract Data]![Week From].[text] or Forms]![Extract Data]![Week From].[value]... Can't work too.

Looks like only the parameters from combo boxes can work.

[June7]

I don't like to use parameterized queries but I did a test prior to my previous post and input from textbox worked just fine.

If you want to provide db for analysis, follow instructions at bottom of my post.

[lookingforK]

Thank you. Still testing ...

[lookingforK]

I found the cause.

It works when using the values in Text Boxes as parameters for the query under 1 condition: after I input the values into the 2 Text Boxes, I should left-click the mouse on whatever other place except the 2 Text Boxes.

I think it is more convenient to use the Combo Boxes ...