Access Visual Basic Code for concatenating multiple fields (text and numbers together) -



Access Visual Basic Code for concatenating multiple fields (text and numbers together) -

i have been set task of creating microsoft access database store client feedback , generate printable study when negative feedback logged.

on feedback form users can log feedback details, trying develop code concatenate fields taken feedback table (which form's record source set to). aiming develop unique number made of next fields feedback table:

company name (this lookup field in feedback table looks company name in company table hence combo-box on form - appears drop downwards menu on form) product name 2 digits of week number 2 digits of month 2 digits of year (these 3 date items extracted field called feedback date in feedback table). a sequential number starting 1 increments if piece of feedback logged on same product same company number changes 2 , on.

basically, illustration i'm wanting replicate this: company name_product name_0712131

the output of these concatenated fields meant stored in field in feedback table called cf#.

what kind of code should writing info want concatenated gets saved database?

there many different ways add together record (currentdb.execute({sql code}), ado commands, dao commands, docmd.openquery), suspect want know how create look going add:

dim strcustomerref string 'add company name (assumes name in sec column) strcustomerref = me.cboyourcombobox.column(1) 'add product name (assumes have text box bound product) strcustomerref = strcustomerref & "_" & me.txttheproductnametextbox 'add date info (assumes have text box bound date) strcustomerref = strcustomerref & "_" & format(me.txtfeedbackdate, "wwmmyy") 'add sequence number strcustomerref = strcustomerref & "_" & dcount("customerref", "cf#", "[customerref] '" & strcustomerref & "*'") + 1 'code append record here currentdb.execute "insert [cf#] ([customerref], [moredata]) values ('" & strcustomerref & "', '" & me.txtmoredata & "')

ms-access

Comments

Post a Comment

Popular posts from this blog

web services - java.lang.NoClassDefFoundError: Could not initialize class net.sf.cglib.proxy.Enhancer -

web services - java.lang.NoClassDefFoundError: Could not initialize class net.sf.cglib.proxy.Enhancer - when trying request rest service @ time of response getting exception.. feb 21, 2013 2:34:49 pm com.sun.jersey.spi.container.containerresponse mapmappablecontainerexception severe: exception contained within mappablecontainerexception not mapped response, re-throwing http container java.lang.noclassdeffounderror: not initialize class net.sf.cglib.proxy.enhancer @ org.hibernate.proxy.pojo.cglib.cgliblazyinitializer.getproxyfactory(cgliblazyinitializer.java:117) @ org.hibernate.proxy.pojo.cglib.cglibproxyfactory.postinstantiate(cglibproxyfactory.java:43) @ org.hibernate.tuple.entity.pojoentitytuplizer.buildproxyfactory(pojoentitytuplizer.java:162) @ org.hibernate.tuple.entity.abstractentitytuplizer.<init>(abstractentitytuplizer.java:135) @ org.hibernate.tuple.entity.pojoentitytuplizer.<init>(pojoentitytuplizer.java:55) @ org.hibernate.tuple.e...
Read more

Accessing MATLAB's unicode strings from C -

Accessing MATLAB's unicode strings from C - how can access underlying unicode info of matlab strings through matlab engine or mex c interfaces? here's example. let's set unicode characters in utf-8 encoded file test.txt, read as fid=fopen('test.txt','r','l','utf-8'); s=fscanf(fid, '%s') in matlab. now if first feature('defaultcharacterset', 'utf-8') , c engevalstring(ep, "s") , output text file utf-8. proves matlab stores unicode internally. if mxarraytostring(enggetvariable(ep, "s")) , unicode2native(s, 'latin-1') give me in matlab: non-latin-1 characters replaced character code 26. need getting access underlying unicode info c string in unicode format (utf-8, utf-16, etc.), , preserving non-latin-1 characters. is possible? my platform os x, matlab r2012b. addendum: documentation explicitly states "[mxarraytostring()] supports multibyte encoded characters...
Read more

javascript - mongodb won't find my schema method in nested container -

javascript - mongodb won't find my schema method in nested container - i trying access method of schema stored within mixed container. here situation : have cases model can many different things, have schema each of these things stored in "casecontent" mixed property. var caseschema = mongoose.schema({ casecontent : {}, object : {type:string, default : "null"}, collision : {type : boolean, default : false} }); the casecontent property filled model of 1 of schemas, 1 exemple : var treeschema = new mongoose.schema({ applecount : {type : number, default : 3} }); treeschema.methods.dostuff = function (data) { console.log('hey, listen'); homecoming true; }; then, want utilize method of schema original container : caseschema.methods.dostuff = function (data) { if (this.casecontent.dostuff !== undefined) { this.casecontent.dostuff(); console.log('it worked'); } else { ...
Read more