Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Numeric Findfirst 1

Status
Not open for further replies.
Domino2

Domino2

Technical User
Jun 8, 2008
475
GB
I and trying to locate a record by its Primary key against a value in a numeric string PK4

strCriteria = "[ID2] =" & PK4
rs2.FindFirst (strCriteria)

Can someone correct this, many thanks
 
Sort by date Sort by votes
numeric string PK4
Click to expand...

If ID2 is a numeric field and PK4 is a string variable then you need something like
strCriteria = "[ID2] =" & Clng(PK4)

If ID2 is a string field and PK4 is string or numeric
strCriteria = "[ID2] ='" & PK4 & "'
 
Upvote 0 Downvote
Many thanks MajP, I will pin that up on my wall.
Thanks again
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Pack10
  • Locked
  • Question
Findfirst fails because data item has double quotes inside quotes..... 2
Replies
8
Views
50
Pack10
Pack10
JimStrand
  • Locked
  • Question
Update Numeric field to Text in Make Table Qry 2
Replies
4
Views
64
PHV
PHV
NWildblood
  • Locked
  • Question
Access SQL String to Numeric - not returning data after decimal point, not changing data type 1
Replies
10
Views
102
NWildblood
NWildblood
jays35
  • Locked
  • Question
Creating a search query to for letter and numeric values.
Replies
2
Views
70
jays35
jays35
tamer64
  • Locked
  • Question
Convert a numeric field to Text field
Replies
2
Views
36
tamer64
tamer64

Part and Inventory Search

Sponsor

Back
Top