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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL query doesnt works probably bcz i dont know how to associate str's

Status
Not open for further replies.
Weendigo

Weendigo

Technical User
Jul 3, 2002
6
BR

'rsta is a SQL query that returns (i check by myself using msgboxes)
'rstb also returns (i also check it by myself using msgboxes)
'this .findnext only works when i type the text returned by <rsta!LINHA> by myself, but i need to put it on a variable !

Could you help me ?
The code is this:

Dim LINHAATUAL As String
LINHAATUAL = 0

LINHAATUAL = rsta!LINHA
rstb.FindNext (&quot;CodLinha = 'LINHAATUAL'&quot;)

Thank you in advance.
 
Status
Not open for further replies.

Similar threads

K
  • Locked
  • Question
How to resolve define worksheets array
Replies
1
Views
511
combo
combo
Andrzejek
  • Locked
  • Question
Copy data between SQL and Oracle 1
Replies
8
Views
735
remeng
remeng
sxschech
  • Locked
  • Question
For Each Loop works once then gives error 91 2
Replies
19
Views
558
sxschech
sxschech
Kymenglish
  • Locked
  • Question
Automated data entry code in MS Excel VB - Edge code how to hit enter to remove popups
Replies
3
Views
306
strongm
strongm
kapok1
  • Locked
  • Question
how to use vba to forbid &quot;Worksheet Menu Bar&quot; being selected
Replies
6
Views
343
kapok1
kapok1

Part and Inventory Search

Sponsor

Back
Top