Recent content by KrazyKT

I am trying to learn how to use VB with databases. Does anyone have some good suggestions on programming books? Thanks, KT

I am trying to create a text box with a calculation format. I want to sum the field excluding the duplicate quantities. Is there a way in doing this instead of just using =Sum([Quantity]). This will give me a sum that has the duplicate quantities in it. Thanks, KT

OOps...I didn't realize that happend. Here is the code a little clearer. Thanks, void Swap (float&x, float&y) { float temp; temp = x; x = y; y = temp...

Thanks. We have started using that method. It appears that the text files are overwriting one another. How would you create a file to change with every new table? That is the problem we are having now. I will read up on the filename in help. Thanks for the help. Much appreciated. KT

Michael, Thanks for the help. I managed to get it to read the files in the directory. My question now is..Can you export the tables to text? I know it has to be within the loop. Also can I do this without having to use the fields? I'm wanting to export them to fixed width files. KT

I currently have a module that will export five tables to text. The tables have to be in the mdb I'm using. I know Dir will call all files in a directory. How do I go about either importing them into one mdb file with the same five tables or just opening them and exporting their tables...

Is it possible to use a database with mdb files in it to call from? I'm using VBA to export a large quantity of Access tables to fixed length text files. I have it working to pull one. I thought maybe it was possible to use a table to list the Access files. As my program loops it will open...

I am using multiple databases. Each contains five tables each. I've created a module to convert the Access tables to text. I need it to be able to open multiple files and run them. I've got the recordset running using code only for one file. I need to know what code to use for a table that...

Simon, I have a few questions for you. Would this differ any from VB5 to VB6? We are still using VB5. Also what kind of controls do I need? Or do I need any? Also how do you set the reference to DAO 3.51 in the project? I'm sorry for my lack of experience and the questions. It would be...

Bless you. I will try this. If I run across any problems, I'll check back in with you. Thanks. KT

Simon, I'm not really sure what I'm doing. It's been about a year and a half since I've programmed anything in Vb. And as they say, if you don't use it, you'll lose it. If you could help, I would appreciate it. This project doesn't start until the 17th. But I will need a few days to train...

Simon, Method 2 sounds wonderful. I believe that would be the most useful to us. Do you have a sample with this or some exerts from a program? Here are a few details on this job. I have a large quantity of mdb files that need to be processed in a daily turn around. The files will be named...

I have Access files with four tables each. I need a faster way to use code to pull the file in a certain directory and export the tables as text. The four tables with the Access files have same structures and names. I know this can be done, I just don't have the experience behind me to help...

I have a large quantity of Access files each with four tables in the files. I need an automated way to go into a directory and then export the Access tables as fixed width text files. I know this can be done in VB, I'm just not sure how. KT

MichaelRed, I am positive how to import the files within another file. I'm not really positive that I know how to open databases within one master. Do you do this by using querys or macros? Or do you use code? I looked up the Dir function. That will make my life much easier. I'm going to...