Search results

Many thanks for the reply. FYI The scans should all be of the same product set by the operator, the image which causes the lag in responce when loading does not need to re-present every time a correct scan is made ONLY when an error scan has been recorded, tat tis point I requert the sourse to...

I have a verification DB where a barcode is scanned which brings up details and an image of the item which is displayed on the screen for visual comparision by the operator. Once verified as correct item this Bar Code is then set to a check data string, my next scan check against the stored...

Many thanks to you both for your replies I will be back on site on Monday to try out thanks again Steve

I have a form which contains a count of scanned items if, OK or ERR from my TblLog. I have 2 displayed fields which show the numder of recorded errors using Dlookups Me.ScansOK = DCount("[Err_OK]", "TblLog", "[Err_OK] = 'OK'") Me.ScansERR = DCount("[Err_OK]", "TblLog", "[Err_OK] = 'ERR'") I...

OK fully understand now thanks for your patience Steve

Thanks for the reply, I have to change the values as this data is re-subimtted to another 3rd party for import into their distribution programming. I can do the If / Then replace option, but once a fields value has been changed i.e. from Yes to No, then all the values of that field will = No, so...

Could anyone offer advise in the best way to update the below: I have a 135000 line text file which I receive monthly, in the data there are 8 Yes/No fields which come across as -1 or 0. When I import the data they are the wrong way a-round my Yes are No and No are Yes this appears to be because...

Jal, Many thank for the speedy reply I have adjusted and tried to use your code as below: Dim cn As ADODB.Connection Set cn = CurrentProject.Connection Dim rsSource As New ADODB.Recordset rsSource.Open "SELECT * FROM Shipments, cn, adOpenKeyset, adLockOptimistic" Dim str As String Do While...

I have a query which uses a combinition of fields to produce a string. This string is used as a "detail field " and is currently copied across into another system which produces notes. I wish to take all the records produced from a filter and combine and update them into a single field (which is...

I have a text file import routine which work fine, but because of the file "make-up" I always get a portion of the header rejected (this is not required) and this creates an access default ImportErrors table. This routine is run several times a day which created many error tables which are just...

Is there a way that the font size in a Memo field on a report can be adjusted on the onformat event etc ? so all the data will fit into it?. I have a report which is a despatch note, the goods description field (memo) can have a few lines or many, in order to ensure I can cope with the many...

I posted this some time ago but never really got to the bottom of the issue and just "lived with it" and put in an error message telling the user to re-start but I now really need to try and resolve the issue or at least understand why I have this Email failure I have several DBs which work...

Many thanks for your reply, I think I have the idea and will have a go. thanks again Steve

I have a Report which I use as labels, each unit needs its own label there can be 1 to 26 or more units in total. Could anyone offer advise how I can make the correct number of prints according a [qty] on the query/report i.e. No.of units =[10] (10 labels required) Each label whould then have...

Ditto Peter

Rabbie, Many thanks, I was on someone elses PC and did not search the site properley I have found this answer in the seach function which really does work !! thanks for taking the time and trouble to reply though Steve

I supply data to our customer for their system, a single table listing 1.9 millon records. 1 of the 7 fields is unique but the rest in the table can contain duplicated data. My problem is caplial letters vs lower case. How can I query my table to find just the mixed and lower case versions of...

Many thanks Brian, baseing my final query on the calculating query works great Steve

I have a query which uses several IIF statements in different fields the end field being a simple compare, if one value is greater than another+5% then no="OK" yes="Check" This is the final IIF Diff: IIf([InvVal]>[EstPrice]+[EstPrice]*0.05,"Check","OK") I only want to show those records...

Filter Thanks Neil works fine you the man! Steve