vba - Filter Subform, Starts With, Multiple criteria -

-

i filter subform based on data put text box. code below show record if student id typed perfectly. want have filter show records in student id, first name or last name starts me.sort.text

private sub sort_change() if isnull(me.sort.text) or me.sort.text = ""     me.students_subform.form.filteron = false else     me.students_subform.form.filteron = true     me.students_subform.form.filter = "[student id] ='" & me.sort.text & "'" end if end sub

it sounds me need filter expression 3 like conditions or'd together.

for example if me.sort.text contains text "foo", build filter expression string such ...

 "[student id] 'foo*' or [first name] 'foo*' or [last name] 'foo*'"

i tested code in access 2010 , filters subform think want ...

private sub sort_change()     dim strfilter string      me.sort         if len(.text & vbnullstring) > 0             strfilter = "[student id] '" & .text & _                 "*' or [first name] '" & .text & _                 "*' or [last name] '" & .text & "*'"         end if     end     debug.print "strfilter: " & strfilter '<- inspect in immediate window                                           ' ctrl+g take there     me.students_subform.form         if len(strfilter) = 0             .filteron = false         else             .filter = strfilter             .filteron = true         end if     end end sub

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