By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,344 Members | 1,139 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,344 IT Pros & Developers. It's quick & easy.

VB6 query format for comparing number value

P: n/a
hi all
i am using VB6 and Access
i was trying to select data with a particular value in a field as

Dim str1 As String
str1 = "select * from booking where psngr_id = '" & Text1.text & "'"
Adobkgview.RecordSource = str1
Adobkgview.Refresh

I am supposed to retrieve records where psngr_id is as typed in the
text box.
it worked fine for the first time. but later it rose error saying text
after text1 is not correct. options to put after text1. are count/ Item
/ Lbound / Ubound . psngr_id is a number type.
Please give the code
thanks

Nov 3 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
This is a newsgroup for Visual Basic.Net (vb2002, vb2003, vb2005) - and
not classic vb (vb1 - 6). Please find the classic vb newsgroup
(microsoft.public.vb) and search/post there.

Thanks,

Seth Rowe
prateek wrote:
hi all
i am using VB6 and Access
i was trying to select data with a particular value in a field as

Dim str1 As String
str1 = "select * from booking where psngr_id = '" & Text1.text & "'"
Adobkgview.RecordSource = str1
Adobkgview.Refresh

I am supposed to retrieve records where psngr_id is as typed in the
text box.
it worked fine for the first time. but later it rose error saying text
after text1 is not correct. options to put after text1. are count/ Item
/ Lbound / Ubound . psngr_id is a number type.
Please give the code
thanks
Nov 3 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.