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

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

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

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

I'm working with numerous tables.  I created a macro to transfer the text using TransferText command from the tables to text files.  Is there a way that I can automatically have the text file pull the same name as the table?  I know you can type it in, but I'm...

I have created a macro in order to transfer four tables on information to another database with the same four tables.&nbsp;&nbsp;I will have numerous tables to add to this database.<br>I used the transferdatabase action and it worked.&nbsp;&nbsp;How do I get it from overwriting the information...

I still need additional help.&nbsp;&nbsp;I have a large <br>quantity of databases with four tables in Access that have to be appending into one Access database containing four tables.&nbsp;&nbsp;I don't know much about programming in VBA.&nbsp;&nbsp;I know how to use append queries, but I need...

Help.&nbsp;&nbsp;I know how to create append queries in order to append one table in one mdb file to another.&nbsp;&nbsp;I have a large quantity of tables&nbsp;&nbsp;that need to be appended into one table.&nbsp;&nbsp;Is there anyway to speed this process up?&nbsp;&nbsp;Thanks for the...

I have just started using Crystal Reports.&nbsp;&nbsp;Is there a way to display the title on <br>each page of the report? If so, how?&nbsp;&nbsp;Thanks for the help.<br><br>KrazyKT<br><br>