Hello,
Im quite new to working with VB. Im currently fumbling about with pulling and pushing data to acces via VB.
I want to use a query string containing variables, so I can pull specific data based on an overview, without having to write out all the 'options' that are available.
So far I've managed to get a db connection and I can pull some data from my database via;
.CommandText = "SELECT * FROM [Clean_trade_Data] WHERE [Ticker_ID]='ARD'"
Yet when I change the code so that the commandtext has to work a variable;
Dim strcmtxt As String
strcmtxt = """SELECT * FROM [Clean_trade_Data] WHERE [Ticker_ID]='ARD'"""
.CommandText = strcmtxt
I get an error message saying that the operation "SELECT * FROM [Clean_trade_Data] WHERE [Ticker_ID]='ARD'" is not valid.
I can't seem to find why this doesn't work. Can anyone enlighten me?
thank you in advance!
regards!
Charunks