devxlogo

Searching on Numerical Fields

Searching on Numerical Fields

Question:
When using the FindFirst method I seem to be able to locate only records which are defined as strings using a variable in the search pattern.

When I am searching for integer values I cannot find the correct syntax to pass the variable name at best I get a response of Type mismmatch when I pass it as a string.

If I replace the variable with a constant (eg 1 or 2) then no problems — the record is found.

All referances I have seen only refer to searching for strings

Answer:
You can just say:

RecordSet.FindFirst “integerfield = ” & val(TextBox.Text)
This will do a find of ‘integerfield = 3’, for example.

See also  Redefining Energy Management: Advanced Solutions for Modern Buildings
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist