Search results

Re: Looping through data Updated? Update for anyone interested in this: I found that maintaining the lookup table with meanings of the codes was hard to do in the live system with 3-4000 orders a day so I pressed on and found my solution below, it might not be pretty but it works: Private Sub...

Ok thanks fyi. I have gone down your route, I have created a table with the ServiceReq codes as a PK with meaning in a Desc Field. As my data imports the field containing the service codes is appended to my table (only new codes are accepted due to the PK) I can see this table growing but not...

I understand what you as saying but an order arrives and is processed we current output this to a carrier in a single line of data per order so if an order arrives in and requires w01 and w03 (theses are in the field as W01,W03 ) we manually convert thes to the meanings as the end carrier driver...

Thanks again but I think you are missing my point, the data arrives in a text file which is imported into the order table, 1 of these fields contains a ServiesReq string of Wcodes which can have upto 10 Wcodes contained in it. I already have the table of available codes to look up against and I...

Thanks for the reply 1/ I have a table of available codes and descriptions the PK is Wcode 2/ The orders arrve in and 1 of the fields can have several WCodes the format is: W01,W03,W03 etc When I import the order I wish to change the WCodes to a meaningfull Text Field of the Code Descriptions...

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

Now you have made me feel a stupid !! works perfect many thanks regards Steve

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

Thanks for the speedy replies but I seem to have confused the issue I am not doing mutipule lookups I was just saying that using the simple first example ie just the ADD date it works but for all Countries. I was creating a string CheckID by combining 2 fields on my form CountryCode & ADD...

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

Thanks Dave, I discovered te methord by trial and error and it works great I tested on a 3200 line file with 35 orders and it works 100%. Im not sure if if I am doing it the "correct" way but it works, and I cannot as yet produce any errors. the full code in case your are interested is below...

Dave thanks for your suggestions I,m sure it will work if I can work ouk out where in the code it should go ! I have inserted it as below but it dosent catch the OrderNo change and insert the 2 headder lines and then the data lines for the next OrderNo Function O2Pipe() On Error Resume Next...

O2Export is a query Steve

First thanks for the reply No the data is not the same, its contained in one table imported that can have 1200+ unique records, covered by any amount of OrderNo's. Sorry for confusing but I put the sample there to show mainly the format of each output for each OrderNo I didnt change the other...

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

Many thanks for the help I have received here I have just 1 issue left with this problem, I have resolved the issue of outputting with a Pipe delimiter as below Function ExportO2Pipe() On Error GoTo Err_ExpO2Pipe Dim O2DB As DAO.Database Dim rstO2 As DAO.Recordset Dim intO2 As Integer intO2 =...

Dave many thanks for you assisitance here I have been doing a bit of research and have gotten what I need with one exception the output is commor delmited I need pipe the code I have used is as below I think it waht you were refering to Dim MyDB As DAO.Database Dim rstO2 As DAO.Recordset Dim...

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 have tried the query as below on my test version and it appears to work fine UPDATE ExportsSheet INNER JOIN Book ON ExportsSheet.[ID] = Book.[ASN] SET ExportsSheet.Vehicle = Nz([Book].[Vehicle]), ExportsSheet.Driver = Nz([Book].[Driver]), ExportsSheet.TrlNo = Nz([Book].[TrlIDout])...

OK thanks a lot I will, have a go when back in work Monday . have a good weekend Steve