Recent content by WesParkinson

Hi All, I need some help again bit time! The end result I require is to export my table "Emboss" as a .txt file while formatting my "Counter" fields to "000000". Normally I create a query and do Format("counter","0000000") then export it. However this method will not work with the new...

Hi All, I have a report which i require help on. The Purpose of this report is to show the first and last record from the orginal text file and compare it against the first and last record of the new text file. This is for checking purposes as we manipulate data and use this to ensure...

Hi JDraw, I didnt use the code below, however you kick started my brain cells and I have managed to do it. I used your idea of importing into the one field and wrote the code to directly place all text into one column. I then used a LEFT function to find the first character and if it began...

I have attached a sample file, please note that I have had to create this as I cannot send client data due to DPA regs. However you will get the drift of what I mean. The number of rows used can vary from customer to customer, so what I need is for the process to select the first and last...

Thanks, I really appreciate your suggestion. When selecting the orginal data from the text file, it has to come from the .txt file, I cant take it once imported. The reason being that the format of the orginal file has to be displayed on the report, so if it is : or ; delimited it has to show...

Thanks, unfortunately I really do need to rely on the user as the text file sent by a company can be set up differently. The first row isnt always the data but can be a set up instruction etc. Example Lycamobile Sweden 15k pin split 343 343445645,56780001 387329437,56780002 and so on so...

Hi All, I hope someone can help me out with this. I have an access database that imports a text file into a table, updates the data accordingly and spits out a new text file in the format we require for our machines. Part of this process is to check that the first and last records match...

oh yeah, sorry I needed to state that the filed is called serial and the recordset I am looking up is called tbl_emboss.

Hi All I have put together a form that allows the user to highlight parts of a Value and state which parts are a prefix, which is a batch and which is a serial. (These are my companies terms for it) They can also state how each part incremements. See attachment. I wrote a few queries to...