|
code
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Convert Ms Access query to VBI'am looking for a tool or utility to convert a Ms Access query to a VB6
query. Does it exists ? Couldn't find any using google. Robertico if u convert to Access query to SQL u can just execute the SQL in VB
Show quoteHide quote "Robertico" <Robertico@nomail.notvalid> schreef in bericht news:dgrbg8$k5b$1@localhost.localdomain... > I'am looking for a tool or utility to convert a Ms Access query to a VB6 > query. > Does it exists ? Couldn't find any using google. > > Robertico > > > if u convert to Access query to SQL u can just execute the SQL in VB Can i paste my Access SQL query firect to VB ?Robertico Need to make a string constant/variable of it, then do an Exevute on ur
Connection Object Show quoteHide quote "Robertico" <Robertico@nomail.notvalid> schreef in bericht news:dgrepk$l47$1@localhost.localdomain... >> if u convert to Access query to SQL u can just execute the SQL in VB > > Can i paste my Access SQL query firect to VB ? > > Robertico > > Or use the SQL string as part of your OpenRecordset statement
set rs = mydb.openrecordset("select * from table1 where field1=....... Show quoteHide quote "Martin de Jong" <ML@community.nospam> wrote in message news:umNUCDrvFHA.3152@TK2MSFTNGP12.phx.gbl... > Need to make a string constant/variable of it, then do an Exevute on ur > Connection Object > > "Robertico" <Robertico@nomail.notvalid> schreef in bericht > news:dgrepk$l47$1@localhost.localdomain... >>> if u convert to Access query to SQL u can just execute the SQL in VB >> >> Can i paste my Access SQL query firect to VB ? >> >> Robertico >> >> > > "Robertico" <Robertico@nomail.notvalid> wrote in message Please note that there is no such thing as "a VB6 query." VB itself has no news:dgrbg8$k5b$1@localhost.localdomain... > I'am looking for a tool or utility to convert a Ms Access query to a VB6 > query. > Does it exists ? Couldn't find any using google. database capabilities. You use external libraries (like DAO or ADO) to execute commands against a back-end database. It's the database itself that executes the query, so the "conversion" of Access "to VB" really depends on what the back-end database is. If you provide more detail we might be able to help you further. 
Other interesting topics
Fluctuation of printer alignment
Database and report question Newbie: How to extract year from a Date object VB6 : Attach Event Handlers to Dynamically Generated Controls How can i make sure List all jpg files from folder (loop problem) Random first random number Missing File Export Template in VB.NET delete VB6 IDE VBE Object reference |
|||||||||||||||||||||||
