Search results

thanks dc for the help the ENC is incorrect in the code, sorry it should have been CNE the code works to copy the folder if i add in "UR152W" as in the following example, but how do I add the folder name form the record in the Query to the end of the stPath and stUpdate and loop to the next...

this is what I have so far to copy the folders but it's not working I also have to call a shell and run a script here somewhere as will but first what am i doing wrong to copy the folders? Private Sub updates_Click() Dim rs As ADODB.Recordset Dim oFileSyS As FileSystemObject Dim stFile As...

I have a query that compares the contains of two folders on my C: drive and list the differences such as the following; ( the following is a list of folders ) UR152W UR158W UR458W UR653X UR874X what i need to do is copy each folder to a new location and run a external script on the files in the...

OK everthing is working great, but if I may ask one additional question If I wanted to run the code on a different text file and append to the same table, what do I need to do? thanks murlen

Hi Wayne That works great! Thank you so much for the help Murlen

Hi Wayne, You may have misunderstood me on the last post, sorry each record is contained on a single line, but as in the example below if "CATKIM" is not listed for the record it creates an error. If there is no "CATKIM" I need it entered into the field as NULL or even bitter left blank. here...

This is exactly what I'm looking for, Thanks Wayne! but I have another little problem, If I want to add the the value for 'SIPPER' to the 'SIPPER' field I would add the code, ptr1 = Instr(1, Mystring, "SIPPER =") ptr2 = Instr(ptr1, Mystring, ",") rst!SIPPER = Mid(Mystring, ptr1 + 10, ptr2 -...

Hi all! this is my first time playing with code and I need a little help I'm importing from a text file into a table the structure of the text file looks like this; 3031,Obecid = QrABAik, type = P, Obec Label = LIIITS, COLOUR = 255, LITCRR = 9, QBNAM = LA, SIPRIP = (1), SIPPER = 2.5...

how can I easly Place all the fileds starting with MYR in the one column? also there are going to be over 100 fields all of which have to be in there own column. murlen

Hi all! I'm trying to import a text file using comma delimited into a table the text file is structured as such; SOR = azjfg, OBJ = TTRE, MYR = ERDDD, ADD = T17yg, WES = 7gg SOR = sd89, OBJ = REW, ADD = Y76dt, WES = e77, TRR = dufhf SOR = dsfss, OBJ = DSS, QTT = ast6, MYR = ERRDS, ADD = T7yy...

morning everyone:o I'm entering orders into a subform much the same as the Inventory Control sample database supply with Access 97. after I enter all the Items for an order I would like to enter Serial numbers for the order by means of a command button. the problem is how do I relate the...

Thanks for the help everyone! I appreciate it. Murlen:)

the file as about 5000 lines or more and it changes all the time. I need to import it over time, meaning I need to import it once now and again ever couple of months or so. the records are always changing, much like this this week, USER: tom CODE: qwe next week, USER: tom CODE: xr4

I hope someone can help me with this, I have a text file that is formatted in the following way. USER: Tom LOCATION: T2 CODE: qwe VALUE: 754 STRING: deerii reree rerer 3ejij98 ed33 djie3 USER: Jane LOCATION: Q4 CODE: xr8 VALUE...

thanks, I'll give it a try

I'll try to explain this as best as i can for what I need I have two tables, lets call them 'objects' and 'values' in the objects table we have; peter paul mary in the values table we have; car bike truck horse dog cat beaver What i would like to do is, in a form have two combo boxes one...

It's most likely been asked before but I need to now. Is there a way to save a long report to one html page? Thanks, Merlin