Error when running a parameter query from access 2007 in excel vba -


i'm trying run query in access 2007 database excel 2007 vba script. access query has parameters called "year" , "month".

i'm trying following code work:

sub runmyquery()      dim cn new adodb.connection     dim rs new adodb.recordset     dim dbpath string     dim stqry string     dim stcon string     dim cmd new adodb.command     dim prmyear new adodb.parameter     dim prmmonth new adodb.parameter      dbpath = "<path_to_my_db>"      stcon = "provider=microsoft.ace.oledb.12.0;" _          & "data source=" & dbpath & ";"      cn.open (stcon)     cn.cursorlocation = aduseclient      set cmd.activeconnection = cn      set prmyear = cmd.createparameter("year", adnumeric, adparaminput, , 2011)     set prmmonth = cmd.createparameter("month", adnumeric, adparaminput, , 5)      cmd.parameters.append prmyear     cmd.parameters.append prmmonth      cmd.commandtext = "select * [month_totals]"     cmd.commandtype = adcmdtable      set rs = cmd.execute      sheets("sheet1").range("a1").copyfromrecordset rs      rs.close     set rs = nothing     cn.close     set cn = nothing  end sub

when run this, code stops on "cmd.execute" with

run-time error '-214217900 (80040e14)':

syntax error in clause.

what getting wrong?

  • the command text seems simple enough me. missing there?

  • am misusing parameters functionality of adodb.command? don't think that's problem here, because i've tried running same script non-parametrized query substituted month_totals, , gotten same error.

i believe parameters use when using saved query in access. solve problem moving parameters sql statment.

change

"select * [month_totals]"

to 

"select * [month_totals] year = 2011 , month = 5"

Comments

Post a Comment

Popular posts from this blog

c# - SharpSVN - How to get the previous revision? -

i trying find efficient way previous revision of file text comparison using sharpsvn. using (svnclient c = new svnclient()) { c.authentication.defaultcredentials = new networkcredential( configurationmanager.appsettings.get("svnserviceusername") , configurationmanager.appsettings.get("svnservicepassword") , configurationmanager.appsettings.get("svnservicedomain") ); c.authentication.sslservertrusthandlers += new eventhandler<svnsslservertrusteventargs>(authentication_sslservertrusthandlers); collection<svnfileversioneventargs> fileversioncollection = new collection<svnfileversioneventargs>(); svnrevisionrange range = new svnrevisionrange(0, this.hooks.revision); svnfileversionsargs args = new svnfileversionsargs(); args.retrieveproperties = true; args.range = range; foreach (svnchangeitem item in log.changedpaths) { string path = this.repositorypath + it...
Read more

c++ - Is it possible to compile a VST on linux? -

for class project i'm attempting write vst plugin backed cuda. current cuda workflow on linux box, i'd prefer compile , link there. according wikipedia , should possible (i couldn't find steinberg documentation relevant linux) can't find makefile or instructions on how build if aren't using xcode or visual studio. i'm vst 3 sdk doesn't support linux. when try compile plugin under linux, error: ./base/source/fatomic.cpp:39:30: fatal error: libkern/osatomic.h: no such file or directory this issue caused following code in "vst3 sdk/base/source/fatomic.cpp" #if mac #include <libkern/osatomic.h> #if mac_os_x_version_min_required > mac_os_x_version_10_4 #define native_atomic_type (volatile int32_t*) #else #define native_atomic_type (int32_t*) #endif #elif windows #include <windows.h> #endif but hope compiling under linux work vst sdk 2.4. reading. jvstwrapper seems run on lin...
Read more

url - Querystring manipulation of email Address in PHP -

i using third party application (email2http) send me emailid, body , message. unable retrieve email id due name appended on , enclosed < , >. here querystring getting. test.php?from=ajay+reddy &subject=cx&body=somebody when print variable in php returns name , not email id. $from = $_get['from']; echo $from; //output ajay reddy please suggest me how can emailid also. i dont want use post method due testing , debugging. it's working fine. forgot use htmlentities() in debugging.
Read more