little change was
Code:
q = "select * from customers where country='" & UserForm1.TextBox1.Text & "'"
Ronie9
Last Activity: Jun 3 '14, 08:13 AM
Joined: May 23 '14
Location:
-
thanks you very much , it works now fine
little change was -
Hello Seth , thanks a lot for the reply
yes im using excel and trying to retrieve specific data from mysql databas by giving a value in the textbox. now when i did what you wrote me i got the error msg"run-time erorr 424, object required"
I tried many things to get it work but still i cant get it to read the text from the textbox.
regardsLeave a comment:
-
Either BOF or EOF is True or the current record has been deleted
I am trying to get specific data by entering a value in a TextBox.
-----------------------------------------------------------
...Code:Sub GetData() blatt = ActiveSheet.Name zeile = 1 spalte = 1 q = "select * from customers where country='TextBox1.Text'" x = ODBCQueryDaten(q, blatt, zeile, spalte) Range("A2").Select End Sub *Last edited by Rabbit; May 23 '14, 05:13 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data.
No activity results to display
Leave a comment: