ms access - Iterate through tabs in TabControl to hide tabs based on names -


i working on microsoft access database (office 2010) , have tab control on bottom of form displays equipment information based on type of equipment select. trying make dynamically display , hide tabs determined name of tabs.

to accomplish have used following naming convention tabs.

tab_static_description tab_static_comments tab_static_maintenance tab_config_computer1 tab_config_computer2 tab_config_printer1 tab_config_scanner1 tab_config_telephone1 tab_config_display1

my tabcontrol called "tabs"

i have set form execute function below(the function need with) on form load , onchange of equipment drop down menu.

to call function use following code.

displaytab

here code far. have been googling bit , have yet find doing similar me , have found myself little lost on one. appreciated.

function displaytab(equipmenttype string)     dim ctl control     each ctl in me.tabs         if ctl.name.contains("tab_static_")             me.tabs.pages.item(ctl).visible = true         elseif ctl.name.contains("tab_config_")             if ctl.name.contains("tab_congig_" & equipmenttype)                 me.tabs.pages.item(ctl).visible = true             else                 me.tabs.pages.item(ctl).visible = false             end if         else             msgbox "there unusually named tab. please contact database adminsitrator."         end if     next ctl end function

the error getting "invalid qualifier" after googling message doesn't make sense. 

if ctl.name.contains("tab_static_")

is not valid vba syntax. thinking of similar method might availabe in vb.net. in vba like

if instr(ctl.name, "tab_static_") > 0

Comments

Post a Comment

Popular posts from this blog

android - Get AccessToken using signpost OAuth without opening a browser (Two legged Oauth) -

i using signpost oauth access data magento server. have read various tutorials on same , reach point open browser user can enter credentials. however, per requirement have automate part. hence, user should not browser page. have set-up done on server side ( magento ), hit url , returned call page. same through program in android. i have tried below, consumer = new commonshttpoauthconsumer(key, secret); provider = new commonshttpoauthprovider(oauth_init_url,access_token_url, authorize_url); try { provider.retrieverequesttoken(consumer, oauth.out_of_band); log.d("tokens" , consumer.gettoken() + " -- " + consumer.gettokensecret()); } and request tokens. dont know how bypass next step. tried directly accessing accesstoken (stupid of me) provider.retrieveaccesstoken(consumer, "mycallback://callback"); no luck, ends in oauth.signpost.exception.oauthnotauthorizedexception: authorization failed (server replied 401). ...
Read more

org.mockito.exceptions.misusing.InvalidUseOfMatchersException: mockito -

getting error org.mockito.exceptions.misusing.invaliduseofmatchersexception: invalid use of argument matchers! 1 matchers expected, 2 recorded. exception may occur if matchers combined raw values: //incorrect: somemethod(anyobject(), "raw string"); when using matchers, arguments have provided matchers. example: //correct: somemethod(anyobject(), eq("string matcher")); at when( getprogramservice .callservice(any(getprogramtype.class))) .thenreturn(jaxbresponse); please explain error , possible resolution the code posted looks fine; don't see problem it. code before or above causing exception. key here: invalid use of argument matchers! 1 matchers expected, 2 recorded. any , used above, doesn't return "special kind of null" or "special kind of getprogramtype"; don't exist. instead, returns null , side effect puts matcher on stack. whe...
Read more

google shop client API returns 400 bad request error while adding an item -

i'm working on solution add items in google shopping market java application. following tutorial real mess because of missing classes of laste release, after setting 1.5-beta maven managed make base example typecheck correctly classes. still can make simple task of adding 1 item. instead of posting whole code i'm posting part creates product feed. private product createproduct(string id) { product product = new product(); product.title = "red wool sweater"; product.content = new content( "text", "comfortable , soft, sweater keep warm on " + "cold winter nights. red , blue stripes."); product.appcontrol = new appcontrol(); product.appcontrol.addrequireddestination("productads"); product.externalid = id; product.lang = "it"; product.country = "it"; product.condition = "nuovo"; product.price = new price("eu...
Read more