Search results

Hi vbaInet, Thank you very much for your response, Wow that was so simply to do and to think I've spent so long trying to work out how to programmatically change a fields datatype when there was this solution was out there just waiting for me. The text file is created from a scanning system...

Good day folks, I'm hoping someone can help me on this problem I've had for a number of years now and I believe the work around I've being using really needs to be automated. I import daily text file data into my database, which has a number of fields one of those fields is a path to where...

Hi, Create a query that excludes all the criteria you used in the 13 other queries and you should be left with only the data that did not meet the criteria of those queries. Regards John

Hi tehNellie, Taking on board you observations I've removed the part that checks to see if the file is a tif file because all the files in that particular location are tif files and will only ever be tif files. so that has increase the speed of the code significantly, thanks The files will...

Hi tehNellie, Thanks for your observations I will let you know how I get on with those. Cheers. John

Well Kiwiman, I'm all for a bit of humour, but it usually helps the audience if they know it's homour. "Howzit" didn't do it for me as I had not seen the quote you highlighted in any of my posts. So I take it you have nothing to assist with my post then John

What you talking about, Pity about what, I haven't a clue what that message is all about. Please explain John

Hi tehNellie, I said I would let you know how I got on, your assistance has been most helpful. Below is the complete code that I've come up with, however I need a little more help as the code runs really slow, in that it does what I want it to do, but it is taking a long time to copy and...

Good Day tehNellie, Thanks for your response, I'll let you know how I get on. Just some info on the Ambersand in the table name, I've been using the ambersand for a number of years as part of the the table name and so far have not experienced any problems, but I've not had to use any code to...

Hi Folks, I have a table which has a number fields in it of which there are 4 fields that I want to extract the contents from. My table is named - tblStdD&GNewBrandAdd and the fields that I want to target are: strFormCode strPlanNumber strBatchID strImagePath I've done a bit of searching...

Good afternoon folks, How do I get a field value from a table and assign that value to a variable in my code module. I want to go though all the records line by line in a table for a specific field and assign the value of that field to a variable in my code module. This is part of a bigger...

Good afternoon folks, I import fixed width text files into my database which a scanning system exports to a specific location. The scanning system also exports the images that pertain to each record within that text file to a specific location. In the text file there is a field which...

Hi Folks, Just in case anyone else outthere needs something like this, as I have now resolved my problem, with help of information from the Microsoft Help and Support web site, below is my code which works : ‘Checks to see if the rtmail.txt file exists in the B:\rtmail folder, if it does...

Good morning folks, just looking for a little help with working out code to append the contents of one fixed width text file to another fixed width text file, both files will have the exact same fixed width specifications. The reason for doing this is combine the contents of two files that...

Hi GalaxiomAtHome, Thanks for the observations, I have changed the Name field to UserName accordingly and your expression works great thanks most appreciated. John

Hi Spikepl, Thanks noted. John

Hi GaloimAtHome, Thanks for your advice, I actually worked out an expression that has given me the results that I was looking for as follows: Name: Replace(Mid([strFPath],68,InStr(10,[strFPath],"\")),"\","") This works because the strFPath is acutally onle consists of the following...

Good morning Spikepl, Thanks for the pointer most helpful indeed, worked out a game plan from that, needs a some tidying up, but keep working on it. Thanks again John

Good morning Folks, I'm looking for some help on how to build an expression that extracts some data that can be of varying lengths between two slashes please see below example data ================= File SearchFolderDateG:\01 Archiving\Instant Take Ups Cashless Batched...

Hi Gemma, Thanks for your speedy response, I had the DAO checked in my references. It was the ..... Dim db As DAO.Database Dim rst As DAO.Recordset That sorted it, amazing how something so simple can cause big problems. Yours and James help has been excellent. Thank you both. John