Auto-submit HTML Form using VB in Access 2007 -

-

i'm @ wit's end on one.

part of project i'm working on requires interaction html form bring correct page on external web-based tool. i've managed make form accept entered variables , generated on fly using document.write, haven't been able reliably trigger 'submit' action in way not throw off error 91.

so far, i've been using simple getelementbyid.click call... here's list of few things i've tried trigger:

testloop:    pause (1)    browsercontrol.document.getelementbyid("submit").click    on error goto testloop

*(the 'error loop' tactic didn't work @ all.)

   pause (3)    browsercontrol.document.getelementbyid("submit").click

(this works best, because different pcs might have different hardware specs , open applications might slow down, works me hasn't been working tester. if make long, end adding additional delay form i'm worried being slow.)

<script type="text/javascript">     window.onload = function(){      document.getelementbyid('submit').click();;     } </script>

(embedding auto-trigger in generated html, frustratingly, works outside of embedded web browser control, not inside it.)

private sub wb_navigatecomplete2(byval pdisp object, url variant)   if me.browsercontrol.document.url= "about:blank"         browsercontrol.document.getelementbyid("submit").click  end if end sub

(for insane reason, using debug.print found it's saying navigation complete before it's complete, didn't work @ all.)

i may have missed few... i've been attacking bunch of different angles. trick have use html form interact system don't have admin priveledges on, changing how information recieved isn't option.

my last train of thought see if mimic form submission using straight vb, bypassing need 'click' event, it's been exceptionally difficult search things related html form interactions access 2007 forms. :p

any assistance appreciated!

well, after 7 months of testing , thousands of activations in time, splitting 'work' seems have done trick.

form_open: initialises browser object , sets address about:blank

form_current: calls formula 'draws' web form using document.write, enters loop...

testloop:    browsercontrol.document.getelementbyid("submit").click    on error goto testloop

Comments

Post a Comment

Popular posts from this blog

java - Run a .jar on Heroku -

-
i trying run .jar file on heroku, , can't find instructions anywhere on how this. have read wants me compile uploading heroku. possible, , if is, how this? if helps, trying run minecraft craftbukkit server, , don't have pom.xml file yet. you didn't provide details i'll try give , people reaches question way it. first of all, create heroku account , create heroku application (assumed have done that). second, need generate application jar , upload heroku. so, open terminal , install heroku cli (assuming unix terminal): $ sudo npm install -g heroku-cli you need have npm , nodejs installed, can check link: https://www.digitalocean.com/community/tutorials/how-to-install-node-js-on-ubuntu-16-04 once done that, can use npm update node version acceptable heroku-cli: $ sudo npm install -g n $ sudo n 7.10.0 and run: $ sudo npm install -g heroku-cli in order deploy jars, need install deploy plugin: $ sudo heroku plugins:install heroku-cli-deploy ...
Read more

java - Jtable duplicate Rows -

-
Image
when add new rows in jtable duplicate rows many times this method update jtable public final void tableaucomande(){ ((defaulttablemodel)tabcommande.getmodel()).getdatavector().clear(); session s=hibernateutil.getsessionfactory().opensession(); criteria cr1= s.createcriteria(commande.class); list <commande> lcs=cr1.list() ; criteria cr2= s.createcriteria(lignecommande.class); list <lignecommande> lck=cr2.list() ; if(lcs.size()!=0 && lck.size()!=0) { (commande lc:lcs) { for(lignecommande lig:lck){ ((defaulttablemodel)tabcommande.getmodel()).addrow(new object[]{ lc.getid_cmd(),lc.getnumcmd(),lc.getdate_cmd(),lc.getclient().getnomprenom(), lig.getproduit().getlib_prd(),lig.getquantite(),lig.getproduit().getid_prd() }); } } // tabcommande.setrowselectioninterval(tabcommande.getrowcount()-1,tabcommande.getrowcount()-1); } } this code add add data rows displaye...
Read more

validation - How to pass paramaters like unix into windows batch file -

-
i need pass various parameters .cmd file unix format file.cmd -configuration=value -source=value -flag but, try this: startlocal @echo off cls setlocal set cmdline=%* set configuration= set source= set badargs= set validation= goto main :splitargs echo splitargs(%*) if "%*" neq "" ( /f "tokens=1,2,* delims== " %%i in ("%*") call :assignkeyvalue %%i %%j & call :splitargs %%k ) goto :eof :assignkeyvalue echo assignkeyvalue(%1, %2) if /i %1==-configuration ( set configuration=%2 ) else if /i %1==-source ( set source=%2 ) else ( rem append unrecognised [key,value] badargs echo unknown key %1 set badargs=%badargs%[%1, %2] ) goto :eof :validate echo validating set validation=fail if defined configuration ( echo -configuration ok if defined source ( echo -source ok if not defined badargs ( set validation=success ) ) ) goto :eof :main cl...
Read more