ms access - Browse to a file location and add hyperlink to the recordset -

-

i found code allows me browse file location, select it, , add file path string text box on form. add file path string table in database.

can show me how that, please? in advance!

dim fdg object dim vrtselecteditem variant dim strselectedfile string  set fdg = application.filedialog(3) 'set fdg = application.filedialog(msofiledialogfilepicker)  fdg     .allowmultiselect = false     '.initialview = msofiledialogviewdetails         if .show = -1             each vrtselecteditem in .selecteditems 'only 1                     strselectedfile = vrtselecteditem                 next vrtselecteditem             me![txtselectedfile] = strselectedfile          else 'the user pressed cancel.     end if end  set fdg = nothing

thanks response, paul. left out important detail in original question. file path needed added continuous subform because each record may have several files need linked. figured out. code used posted below: 

dim fdg object dim vrtselecteditem variant dim strselectedfile string  set fdg = application.filedialog(3) 'set fdg = application.filedialog(msofiledialogfilepicker)  fdg     .allowmultiselect = false         if .show = -1             each vrtselecteditem in .selecteditems 'only 1                     strselectedfile = vrtselecteditem                 next vrtselecteditem                 me.child57                 .form.[imr_hyprlnk].setfocus                     runcommand accmdrecordsgotonew                 me.child57.form.[imr_hyprlnk] = strselectedfile             end         else 'the user pressed cancel.     end if end  set fdg = nothing

Comments

Post a Comment

Popular posts from this blog

node.js - Mongoose: Cast to ObjectId failed for value on newly created object after setting the value -

-
this question has answer here: what's mongoose error cast objectid failed value xxx @ path “_id”? 7 answers even though has been asked many times because entity has no valid objectid field. i came across situation objectid set value can casted objectid still error. the schema: var serviceschema = parammongoose.schema({ servicename:{ type: parammongoose.schema.types.objectid , ref: 'servicenames',required:true } }); pseudo code: servicefromdb=new service({servicename:'some name'}); servicefromdb.servicename='000000000000000000000001'; servicefromdb.save(function(paramerror,paramdata){ if(paramerror){ console.log('but but...',servicefromdb,paramerror) } }); the output of code is: but but... { servicename: 000000000000000000000001, _id: 55079a90286f49280364f78b } { [casterror: cast objectid faile...
Read more

gradle error "Cannot convert the provided notation to a File or URI" -

-
i have defined 2 system properties in gradle.properties: systemprop.builddir=build systemprop.cfgdir=build\\cfg and have following task defined in build.gradle: task clean(group:'clean',description:'clean project') << { ant.sequential { delete(dir: system.properties.builddir) mkdir(dir: system.properties.builddir) delete(dir: system.properties.cfgdir) mkdir(dir: system.properties.cfgdir) } } this generates following error: execution failed task ':clean'. > cannot convert provided notation file or uri: {dir=build}. following types/formats supported: - string or charsequence path, e.g 'src/main/java' or '/usr/include' - string or charsequence uri, e.g 'file:/usr/include' - file instance. - uri or url instance. but equivalent block of code not generate error , works expected: task clean(group:'clean',description:'clean project') << { ...
Read more

python - NameError: name 'subprocess' is not defined -

-
i'm trying make rng website: http://jamesdotcom.com/?p=417 . when run following code: captureimage = subprocess.popen( [ "fswebcam", "-r", "356x292", "-d", "/dev/video0", "static.jpg", "--skip", "10" ], stdout=devnull, stderr=devnull) captureimage.communicate() i following error message: nameerror: name 'subprocess' not defined what should do? thanks have imported first? import subprocess captureimage = subprocess.popen(["fswebcam", ...) subprocess included in python standard library since python 2.4. should not necessary install it.
Read more