Search results for query: *

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...

Sorry I haven't got back to you sooner. There will be a total of 11,000 Access files that we will receive over a three week period. We will get 1,000 roughly a day to process. The Access files that we have tested so far are varying from 250 kb to 1500 kb. The record count within the four...

Well I suggested Append Queries. The boss man doesn't believe they are fast enough. Possibly this is because I originally didn't know how to pull more than one database file at a time. I figure they would work wonderfully if I learned how to pull from the multiple tables from the directory...

kathryn and MichaelRed, Altogether about 11,000 plus database files. If we could append about 15 to 25 files at a time, that would be great. On some trial test of just normally importing 8 databases into the four destination tables, there was about 5,000 records in one table. I understand...

I have a large amount of access databases with four tables that need to be imported into one database with the same four tables. Is there a way using a module to import all the files in a directory into one access database? Append queries will not make this process quick enough. I am...

I have numerous Access files with four tables each needing to be imported into one Access file with the same table structures. The four tables each have the same structure per database. I need a very fast procedure to do this. Append queries will be too slow. Is there a way using VBA to call...