Recent content by DMS500Tech

MoLaker, it looks like you were correct. I had tried a mass update at first calling a function but was having a problem passing the variables so I reverted to the method above because I could get it to work. I did not think about doing an .addnew and .update at the end of each record search...

MoLaker, I had tried a single update in the begining and had some issues but you have given me an idea to try.

Following is basically all of the code with the repeat of the search section removed for space. I have no idea why it goes from a base of 480Kb to over 2 gig in less than 22,000 records and then compacts to less than 19Mb after the code is stopped. Any wise programmers out there see what I...

I hope I did not come across badly, I really appreciate Tek-Tips and everyones suggestions and tips. I spent several hours last night looking at the data structure and it will not be that hard to break it down into smaller chunks of data. Let me work on it for a bit and I will get back with...

GingerR, That is a thought I can seperate them by phone type (different tables) but there is only 3 types of phones, Residential, Analog Centrex, and Digital Centrex. The whole purpose of this project is to be able to dump all this data into Access and do 2 things 1st audit phone features...

KenReay, I wrote the code to built the table because the first thing it does is delete the old table. Figured that would be the quickest way to kill 180,000 records. I have found to clean up the database there has to be a compact and repair done afterwards but that only takes a moment. As far...

so let me ask this, is the 2Gb Limit the maximum size of the database or the maximum size of a table? I cannot seem to find any specs on the limitations of Access. I was under the impression it was only limited by the size of the hard drive. If I was to break it down into several smaller tables...

I have spent a long time figuring out how to write VBA code to build a table in Access that has a column for every phone feature we use. It is about 180 columns wide. I have spent a long time writing the VBA code to search an individual phone record in a text file and extract the feature...

You guys rock! I did it just like PHV said with a twist. I set "MyPos to 0 at the begining of the loop and used another "ElseIf MyPos = 0" so I can go ahead and add a forth search. Of course the 4th one does not work (no results) yet but at least it does not error out. Thanks so much for...

I fixed the oops of variables to: LinesFromFile = Mid(NextLine, MyPos, 3)

stevexff, This is a line from a text file. These are phone features and can range from none to 5 lines. I am attempting to search each line of a text file for 3 different items and insert them into Excel. The first 2 work perfectly and were easy because they are always in the same place of every...

Thanks, That is exactly what I needed but I may be back. I am having a little trouble with the logic for the next step.

(I have serched the help files of VBA endlessly for a solution but it appears that I don't know how to ask my question) I have the following code that opens a text file searches for certain strings and it works great as long as what I am looking for is in a fixed location but it needs to be...

Here is a snippet of code that I am having a little trouble finding a compliment command or rearranging the logic to accomplish my needs. The first IF statement is straight forward and works. The ElseIF statement that needs to come next is giving me problems. r1column1 and r2column1 need to...

That did the trick. Thanks so much.