Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Visual Basic
Expertise: Beginner
Oct 1, 1996

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.
DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date