Recent content by smith7255

Ok. Although this works turns out I can't use this. I have a text file. This was the only way I knew to open the file. I don't know how to open a text file in notepad and do a find and replace from Access. Can anyone help with that. My problem is that when I open this text file using word...

That worked! thank you very much! The word doc takes a little while to open and the find and replace begins immediately. How can I get it to wait until the entire file is opened? Or will it eventually catch up?

I found this script and it appeared to be what I needed. It is giving me any error 13. I've looked it up and don't really know what to do with it. It has to do with the data type. And again, I don't know anything about writing a script. Any ideas on what to do with it? Private Sub NewUB92()...

I found a script on a website that has a command to store the entire file as a string variable. It also shows how to do a find and replace. The only that I am not sure of is how to get a table to interact with the file. I have a list of Old values and new values to replace them with. How...

I was wondering if it is possible to have a table with two columns in it, let's call them OldValue and NewValue, find the OldValue in a text file and replace it with the NewValue. Any information on this would be helpful. If it can't be done in Access, are there any other suggestions. I use...

I would like to create a quiz in Access 2000 for end users to take a required annual test. I don't want to be the one each year entering the information so I am looking for a way for the "super user" to enter the questions in. Once an employee enters their name and department, I want the...

Oh well skip, blind or even more blind, you pointed me in the right direction. Thank you for your time and efforts.

Thanks, PH!! That did the trick.

I tried it out and it does join all the queries together but it does not keep them sorted. I need the detail records to stay under appropriate header. This mixes them up. In other words it should be sorted like this: Record01 (Record Header) Record05 (Money Batch Header) Record10 (Detail...

Ok, I will give it a shot. Thank you!

I would love to do the whole thing in Access, but I don't know how. Would I still be able to use Union query if they don't have the same number of fields?

When they are put together as one file it is a complete "batch" file that is imported into another application. It has Record01 with its information, Record05 for the money batch, Record10 for the detail money, Record06 for the stat batch, Record10 for the detail stats, Record99 for the...

No, they don't have the same number of fields. They have anywhere from 2 to 6 fields.

The field lengths are not the same size, they don't contain the same type of data and they don't have a primary key to join them. I have a Record header, batch header, detail, a different batch header, more detail and then a trailer. Will the union query still work in a case like this?

Hello, I am hoping that someone can help me. I have an Access database that exports 5 queries to an ASCII txt file. I need to append them in a certain sequence and that will need to happen everytime the application is used. Let's say I have one.txt, two.txt, three.txt, four.txt and five.txt...