Hello, I've been trying to get a form working for some time now...
What I'm basically doing is connecting to an excel file through jet 4.0, I can connect properly to the database, and see bound controls, so I know the connection works.
But when I try to do the following:
$sourceSet.dbconn.#command.query.commandType = "text"
$sourceSet.dbconn.#command.query.select.nodes.item(0).value = Concat("SELECT ITEM,DESCRIPCION, LINEA, PACK, UNIDAD, PRECIO, FAMILIA FROM ['sheet$'] WHERE ITEM=", Ltrim(Rtrim(CampoTexto2.rawValue)) ,"")
$sourceSet.DataConnection.open()
I get a "commandType is unknown". I'm really desperate since this cripples the whole functionality of the form. I'm wondering if this is a jet problem or something...