Search results

I have a string field called WCodes which can consist of 1 to 10 Codes ie "W01 , W02 , W03 , W04" ETC Trying to run an update quert through the dataset to find any that have W01 AND W04 in the string (the rules apply to a few different code mixes but just for this example) as in the case of...

Trying to get this iif function to work but keep getting wrong results ie minus or 1st part result instead of second part when applicable. There are 2 charge levels based on a consignment weight minus an allowed value Charge 1 is if a consignmet is greater than 5 kilo then [Weight]-5 gives me...

I have a large number of 4 digit codes which describe a drop which can be applied to a route, the route is made up of the combination. I am look for a way to check the codes against a table. "A001/A901/C002/V004" could be the chosen string code BUT they may be entered as "C002/V004/A901/B001"...

:eek::eek:Hoping for some good advise I have several DBs (Ak2000 .mde) running on many PCs using the Runtime2000, these have worked 100% until the recent roll out / introduction of Office 2010 / Win7 (None with Access 2010 application as part of Office). We have many pc running o/s from win...

I have various users inputting data into excel sheets which are then imported into a database. I need to prevent duplicates and for this I use a UQFld:[DateFld]&[TimeFld]&[Booking]&[OtherRef]etc at the point of importing if there are any of the fields missing the data row is not imported. Once...

I am exporting a routing table or query by the main fileld is a Postal Sector text field of 5 chr length. This field includs some with trailing spaces which must be included i.e. s=space; AAsss or AAAss or AAAAs. The reason the Space is required is that this output is imported into a...

Need some help with Date time calculations I receive orders which rules are required agianist the file Day/Time stamp ie. File Name contains the string 20110922032802 = yyyymmddhhnnss = Thurs 22/9/2011 03:28:02 The Rules are against the DAY and Time and need to function as below: if a file...

I have a table with service codes W01 Service1 W02 Service 2 etc etc When I receive orders in one of the fields OrderService will be required service codes in simple code format ie W01,W02,W03 etc I need to populate 1 Text field against each ordr with all the service requirements ie Service1...

I have a time field that has to be exported as a specific format, but I cannot find a way to match the requirements, any help in achieving this would be appreciated. The Time is stored in a field [TTime] as hh:mm:ss but needs to be output as HHMMSS AM/PM ie “23:56:23”  “115623PM” the problem is...

Im having problems getting my "simple" Dlookup to work looking for some help please ! I have a table tblEuroHol with a key fileld made up of Country Code ie IT and a date ie IT04/04/2010 In a form I have a before update event which creates a string CheckD I am trying to then lookup this field...

I think I need a second loop on a recordset to produce my output file: the rs consists of 5-600 rows of data against 6 OrderNo's and I need to start a new output when 1 field "OrderNo" changes. Below is the function I currently have but I,m not sure if or where I can put the loop to give me the...

I have a table (impoted) which has several fields from which my customer demand I produce a delimited text file exactly as the sample below, I can create the data portion no issues but I need to include 2 header lines in the output file i.e the IBO and the IBD lines as below IBO|G1234567|3.60...

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...

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...

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...

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...

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...

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...

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...