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

Android : Making Listview full screen -

-
<linearlayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:tools="http://schemas.android.com/tools" android:layout_width="match_parent" android:layout_height="match_parent" android:orientation="vertical" tools:context=".mainactivity"> <edittext android:layout_margintop="5dp" android:layout_width="match_parent" android:layout_height="50dp" android:background="@drawable/location_edittext" android:id="@+id/locationeditext" android:textsize="15sp" android:textcolor="#999" android:paddingleft="15dp" /> <com.example.ravi_gupta.slider.viewpagercustomduration android:layout_width="wrap_content" android:layout_height="0dp" android:id="@+id/viewpager" android:scrollbarstyle="outsideoverlay" android:layout_weight="0.5&quo
Read more

javascript - Parse JSON from the body of the POST -

-
i'm using cameratag.com record video on website. service can send json response server can save data database. don't know how proceed here: the documentation states please note json repsonse passed in body of post , not form parameters. here example of how parse response in ruby: data = json.parse(request.raw_post) video_uuid = data["uuid"] but don't know how data on javascript. i'm not experienced in js please bare me :) post sample: { "uuid": "00012710-4b65-0131-ffe6-22000a499ea4", "camera_uuid": "98373a20-79ee-0130-3e42-1231390fcc11", "created_at": "2013-12-20t05:25:02.000z", "percent_complete": 100, "short_code": "kktb4q", "metadata": { }, "state": "published", "recorded_from": "http://singwho.com", "publish_type": null, "formats": [ { "name&qu
Read more

javascript - Chrome Extension: Interacting with iframe embedded within popup -

-
i writing chrome extension needs interact urls user not have open. therefore using hidden iframes embedded within popup, , attempting click button within iframe. however, receiving same origin policy error. know possible extension interact iframes of different domain via content scripts when iframe on tab user has open, not sure if possible use content scripts interact iframes directly in popup. here code: manifest.json "content_scripts": [ { "js": [ "bin/jquery.min.js", "interaction.js" ], "all_frames": true, "run_at": "document_start", "matches": [ "http://*/*", "https://*/*" ] }], "permissions": [ "activetab", "tabs", "http://*/", "https://*/" ], interaction.js $(document).ready(function() { $('div#iframes').append("<iframe id='shop' src=
Read more