vba - creating a loop around my select Case -

-

at present, have functioning select case states if textbox blank highlighted red, seems highlighting 1 of textboxes. instance, if 2 textboxes left blank, highlights first on comes across.

select case true     case me.custname = ""     me.custname.backcolor = &h8080ff     case me.regaddress = ""     me.regaddress.backcolor = &h8080ff     case me.postinput = ""     me.postinput.backcolor = &h8080ff     case me.landline = ""     me.landline.backcolor = &h8080ff     case me.contact = ""     me.contact.backcolor = &h8080ff     case me.dobinput = ""     me.dobinput.backcolor = &h8080ff end select

being new vba, thinking create loop round current code state (loop until x,y or z <> "") can't seem figure out how this.

any advice appreciated.

select case runs code block following first matching case statement only. if need check each of conditions regardless, should write them individual if statements instead:

if me.custname   = "" me.custname.backcolor   = &h8080ff if me.regaddress = "" me.regaddress.backcolor = &h8080ff if me.postinput  = "" me.postinput.backcolor  = &h8080ff ....

Comments

Post a Comment

Popular posts from this blog

mysql - FireDac error 314 - but DLLs are in program directory -

-
i getting when trying access mysql database : [firedac][phys][mysql]-314. cannot load vendor library [libmysql.dll or libmysqlld.dll] this did not happen (unchanged) code, however, have upgraded windows 10 , had reinstall delphi xe8, system configuration matter. in order try solve problem, copied both of files c:\windows\sysytem32. when did not seem work, copied them \win32\debug, generated .exe resides. i imagine doing rather stupid, can't see what. the proper solution place driver file (eg., libmysql.dll ) in application's folder, or place installation location in fddrivers.ini file: [mysql] vendor=<folder>\libmysql.dll (recent versions of documentation seem use vendorlib instead of vendor in ini file.) see rad studio documentation topics configuring drivers (firedac) , connect mysql server (firedac) more information.
Read more

Log not being recorded for quickfix c++ Session -

-
i running fix initiator , succesfully connecting acceptor. problem is, no log being recorded. .cfg application written below. [default] connectiontype=initiator reconnectinterval=2 resetonlogon=y filestorepath=store filelogpath=logging starttime=00:00:00 endtime=00:00:00 usedatadictionary=y # standard config elements [session] # inherit connectiontype, reconnectinterval , sendercompid default beginstring=fix.4.4 sendercompid=init targetcompid=accept socketconnecthost=xxx socketconnectport=xxx heartbtint=30 datadictionary=fix44md.xml [session] beginstring=fix.4.4 sendercompid=init targetcompid=accept1 socketconnecthost=xxx socketconnectport=xxx heartbtint=30 datadictionary=fix44oms.xml the excerpt code initiates connection written below: std::string file = argv[ 1 ]; fix::sessionsettings settings( file ); application application; fix::filestorefactory storefactory( settings ); fix::screenlogfactory logfactory( settings ); fix::socketinitiator initi...
Read more

.net - Using different ADO.NET providers dynamically with Entity Framework -

-
my application can work different databases sql server, mysql, oracle, postgresql or sqlite. knows how load relevant ado.net assembly (its dll file name known) , find dbproviderfactory type in it. factory gives me need work database connection on plain ado.net level. entering entity framework. used use own o/rm want replace ef 6 code first. own o/rm generated sql , ran dbcommand class. ef seems lot more , require special configuration. can't add assembly references supported database client provider , require deploying files. need solution loads assemblies @ runtime dynamically , finds way there. then, depending on database shall used, deploy dlls required that. for doesn't work yet. error message postgresql: system.notsupportedexception: unable determine provider name provider factory of type 'npgsql.npgsqlfactory'. make sure ado.net provider installed or registered in application config. this happens when try add entity dbset . database server co...
Read more