Search results

Paul/SOS thanks for the replies, but to be honest I dont understand where the SET FieldName = Nz(Table1.FieldName, Table2.FieldName) is used (appoligies for being thick)

I've search about in various forums but I haven’t found any answers to this specific question. I have 2 tables Joined by an id field. Table 1 has 4 fields that MAY require updating. Each field in table 1 is updated from table2 but only if the equivalent field is Null in table 1. I can update...

thanks but I have the sum there but it will still count box 63 twice as this box number is in the imported data twice. I want the count to count distinct numbers ie 63 only once . regards Steve

I have a report which groups together various data, ContainerID; Order No; BoxCount; Part. and Units etc Each BoxNo should be unique BUT when 2 different units are assembelled in the same box I will get a repeated BoxNo in the data I import ie Pallet ID Order # Part # Product Description EAN...

the object was to extract from a single string composed of x number of codes the descreption of each code. I was stuck but I have been able now to successfully do it using my instr function as explained eairler. Many thanks for you offers of help though appriciated. regards Steve

Sorry my exanmple wasent clear there are only 4 codes in the string the additional one you can see is from the services table along with the description 111111 ,W10,WA8,W65,W31 W31 PALLETISED DELIVERY. 111111 ,W10,WA8,W65,W31 W10 EURO PALLET. 111111 ,W10,WA8,W65,W31...

Yes the order ie 111111 would have several different service codes agaiinst it the way the file is delivered to us these are in a single field string with seperated by a commer. I have managed to resolve this using an instr function Expr1: InStr([DELPLUSCODES],[WCode])which gives me a 0 if the...

The command just flashes up and goes off I have even had to remove the "bye" from the FTP text file to debug the process. regrads Steve

Just in case anyone still wants this, this is how I ftp from access: Create two files 1 a text file with your specific data in it: 1 create txt file ie ftpfile.txt as below with your specific details =========================================== open "your server" "your server logon" "your server...

I have the following Codes in a single string, “ ,WB3,W10,W01,W65,W31 “ each seperate code is stored in another table with its meaning i.e. WB3 = Re-Box etc. What is the best way to pull these meanings in from the assioiated table. I can do this for a single code but I am struggleing...

I have a problem where not all records in my tables will updated with an update query, I cannot seen to locate any reason why? I have a table of 1.8 millon records which has 60-70, 000 records added each quarter. The new records have some missing text data which is added via an update query...

David, Many thanks for your reply, I will ensure the cascade delete is off when I am back in work. Just so others who may be reading this post are aware I think I have now managed to resolve this present issue. I tried to sync from a laptop which has 2007, and yes it reported the conflicts BUT...

I have a Access2k database where the backend data file is Replicated, all was working fine with synchronizing until a couple of records were deleted. Now I get the "Synchronization was completed successfully" message after running but then I get "This member of the replica set has conflicts from...

Magic works great thank for all your help Steve

Many thanks for taking the time to help here, I have re-checked nad both my formas are "normal" type, still cannot get focus to move back to the original form on-opening the Error Warning form. Steve

My warning form was set to dialog but I have changed it to thin, still no luck though. I have tried this on a dummy DB just to see if I can get focus to change from one form on opening to one that is already open but cannot ? Steve

Thanks for the reply I have tried that but the focus does not move away from my Error form (on this form there are no Tab Stop set on any controls) ? Steve

I have a validation program running on scanned barcodes, when an error or a missed scan is returned I have an error trap which opens a form (or report) which displays the errors. The operator then acknowledges the errors and the form closes and scanning continues. All works fine, however the...

Thanks Mike, I will take a look and see if I can amend to suit my needs regards steve

I have a file delivered to us daily which has a "services" field with string contents like i.e. ,W07,W31,W63,W85,W88 Each of these W codes are proceeded by a "," I am trying to match each code in the string and create a text field with the meanings from my table of Codes and Descriptions...