access vba - How to run function in vba using data macro? -


i new data macro in ms access 2013 , need it. lets assume have simple database 1 table of users. when change "age" field in table, want run external exe file (the reason why dosent matter). learn subject during last few days , end this: 1. build module in ms access called runminifix (minifix name of exe file want run). module uses shellexecute function , whole module looks that:

option compare database const sw_show = 1 const sw_showmaximized = 3  public declare function shellexecute lib "shell32.dll" alias "shellexecutea"    (byval hwnd long, _    byval lpoperation string, _    byval lpfile string, _    byval lpparameters string, _    byval lpdirectory string, _    optional byval nshowcmd long) long  public function runminifix()      dim retval long      on error resume next      retval = shellexecute(0, "open", "c:\program files\minifix\minifix.exe", "<arguments>", _                         "<run in folder>", sw_showmaximized) end function

now, when activating module, works fine , exe file running.

  1. in ms access, build data macro based on 'if then' statement, asking if [users]![age] > x , calls build-in runcode event action catalog calls runminifix function. now, when saving data macro, ms access pops message box saying microsoft access dosen't have ability find name "users" mentioned in phrase , recommend me right control in form. "the form"? yes, form! database not form based. have no gui designed ever. have no buttons or click event handle. asking how can trigger runminifix module when age field modify. please, important!

    thanks head,

    oron.

please use setlocalvar action list in data macro , set expression name of function sample: name "test" expression =runminifix()


-

Comments

Post a Comment

Popular posts from this blog

OpenCV OpenCL: Convert Mat to Bitmap in JNI Layer for Android -

there several posts converting mat bitmap using utils.mattobitmap() function. i'm assuming function can called in java layer after importing utils class. i want transfer data memory address pointed uint32_t* bmpcontent; in code below. jniexport void jnicall java_com_nod_nodcv_nodcvactivity_runfilter( jnienv *env, jclass clazz, jobject outbmp, jbytearray indata, jint width, jint height, jint choice, jint filter) { int outsz = width*height; int insz = outsz + outsz/2; androidbitmapinfo bmpinfo; if (androidbitmap_getinfo(env, outbmp, &bmpinfo) < 0) { throwjavaexception(env,"gaussianblur","error retrieving bitmap meta data"); return; } if (bmpinfo.format != android_bitmap_format_rgba_8888) { throwjavaexception(env,"gaussianblur","expecting rgba_8888 format"); return; } uint32_t* bmpcontent; if (androidbitmap_lockpixels(env, outbmp,(void**)&bmpcontent)...
Read more

android - org.xmlpull.v1.XmlPullParserException: expected: START_TAG {http://schemas.xmlsoap.org/soap/envelope/}Envelope -

i trying hit soap api in application login purpose , getting above mentioned error , can 1 tell me going wrong , first time soap apis. here code hit soap :- vector<object> args = new vector<object>(); hashtable<string, object> hashtable = new hashtable<string, object>(); hashtable.put("email", "mss.siddhart28@gmail.com"); hashtable.put("password", "siddharth"); args.add(hashtable); soapserializationenvelope envelope = new soapserializationenvelope( soapenvelope.ver11); envelope.dotnet = true; envelope.xsd = soapserializationenvelope.xsd; envelope.enc = soapserializationenvelope.enc; (new marshalhashtable()).register(envelope); httptransportse androidhttptransport = new httptransportse( "http://tempuri.org/", 15000); androidhttptransport.debug = true; string result = ""; try { soapobject request = new soapobject("http:...
Read more

python - How to remove the Xframe Options header in django? -

i have made page has iframe . inside iframe want show multiple different links article facebook, or news, or youtube video or other possible url. but, due xframe header, unable so. referred following link: https://docs.djangoproject.com/en/1.8/ref/clickjacking/ , django xframeoptionsmiddleware (x-frame-options) - allow iframe client ip but didn't help. my settings.py file's middleware_classes is: middleware_classes = ( 'django.contrib.sessions.middleware.sessionmiddleware', 'django.middleware.common.commonmiddleware', 'django.middleware.csrf.csrfviewmiddleware', 'django.contrib.auth.middleware.authenticationmiddleware', 'django.contrib.auth.middleware.sessionauthenticationmiddleware', 'django.contrib.messages.middleware.messagemiddleware', 'django.middleware.clickjacking.xframeoptionsmiddleware', ) from http://django-secure.readthedocs.org/en/latest/middleware.html , found using ...
Read more