vba - access2010 form with a non selectable combo box -

-

i have access 2010 form combo box. when run ado query drop down list shows when try , select nothing selected , message @ bottom of screen says form 'readonly'.

i think problem using same recordset form , combo box.

you can use sql statement populate combo box using row source property , set bound column 1. 

cboassociate.rowsource =  "select distinct assignedto pc3claims assignedto not null order assignedto"  cboassociate.boundcolumn = 1

this populate combo assignedto values , can set control source assignedto field in form's recordset.


Comments

Post a Comment

Popular posts from this blog

javascript - Can Piwik report referrer in real time? -

-
i looking query piwik api in real-time stats on current visitor. example, have javascript file that'd i'd fetch piwik api json info on visitor using page contains javascript file (referrer, mobile/desktop, location etc.) as far understand piwik must have data generate analytics on per-user basis. fear might not allow querying info in way i've described above. if that's case, can obtain pw? api method better, if not i'd use same system make real-time reports 1 use generate stats on groups of users particular 1 belongs to. according api page , piwik live! widget refreshes every 5 seconds, , displays new visits. each visitor, can see: date number of actions time spent on site country browser operating system whether visitor new or returning visit the referrer used access site (search engine & keyword, campaign, or referrer website) whether visitor converted goal you can query live! api module , use live.getlastvisitsdetails method ...
Read more

asp.net - Google Drive Access: At least one client secrets (Installed or Web) should be set -

-
we have tested demo code of google drive (for console application) , went correct, after trying implement same web application @ present hosted @ localhost. application giving exception: an exception of type 'system.invalidoperationexception' occurred in google.apis.auth.dll not handled in user code additional information: @ least 1 client secrets (installed or web) should set the code trying run this: usercredential credential; googleclientsecrets s= new googleclientsecrets(); s.secrets.clientid="xxxxxxxxxx-xxxxxxxx.apps.googleusercontent.com"; s.secrets.clientsecret="yyyyyyyyyyyyyyyyyyyyy"; credential = googlewebauthorizationbroker.authorizeasync(s.secrets,scopes,"user",cancellationtoken.none,null).result; var service = new driveservice(new baseclientservice.initializer() { httpclientinitializer = credential //applicationname = applicationname, }); ...
Read more

excel vba add hyperlink to shape in group -

-
i have absolutely no idea why cannot add hyperlink shape if trigged in-cell function. when run manually immediate window, working well. don't have troubles doing manually. i have no idea how write error handling in vba this sample code. function testcase(xllabelname string) dim sht worksheet each sht in activeworkbook.sheets if shapeexist(sht, xllabelname) sht.hyperlinks.add anchor:=sht.shapes(xllabelname), address:="", subaddress:="a1" testcase = "bingo" end if next sht end function from immediate window bingo answer , in cell #arg! error , line not executed. tried ungroup shapes first using dim gshp shape dim shrng shaperange dim tmp string set gshp = sht.shapes(getparentshape(xllabelname)) tmp = gshp.name set shrng = gshp.ungroup sht.hyperlinks.add anchor:=sht.shapes(xllabelname), address:="", subaddress:="a1" shrng.regroup shrng.name = tmp but failed. , still im...
Read more