Search results

Thanks Mike! I edited the bat file to include D:\Retention\"Coverage Update".mdb and the macro now works. One final question. I tried an alternative using a button with the following command after selecting application, run application. MSACCESS.EXE D:\Retention\"Coverage Update".mdb Your...

I created a bat file called D:\Retention\opendatabase.bat by renaming an excel file with a bat extension. I input the database path D:\Retention\Coverage Update.mdb in the bat file. I created a macro that uses the RunApp action and input D:\Retention\opendatabase.bat in the command line. The...

I reviewed the thread mentioned in Rabbie's reply. I created a button, selected category = application, selected action = run application, then browsed to the following path: D:\Retention\Coverage Update.mdb. The Coverage Update database is in the D:\Retention folder. When I use the button...

I want to use a macro that simply opens another database. For example I want to run a macro from Database A to open Database B.

Export Tables in CSV Format I answered my own question by searching prior threads. I used the Transfer Text function with a transfer type of Export Delimited.

The transfer spreadsheet function only allows one to export a table from the database to an excel file format. I want to output the table to a file in csv format using a simple function. Is this possible ?

I created a new table via an append query from the local machine, which took only 1 minute to process. I then linked to this new table from the network server, which also took less than a minute. In summary, you offered the perfect solution. Thank you very kindly.

I am running from network server, I'll try running from local machine. Thank you most kindly sir.

I've consulted with a co-worker who is an expert programmer. We tested linking to the cvs file and then appending 50,000 records at a time to a new table with an estimated completion time of 20 minutes. Maybe this is the only solution. I was hoping there was an easier method.

I am trying to import a cvs file that contains up to 2 million records and 36 fields. The software can't handle this size. I can quickly link to the file, but I must then append these records into another table so I can customize the field properties such as the primary key and indexes. If I...

Thanks so much for everyones' input. The input was excellent and now I am fully equipped to appropriately utilize indexes.

Indexing fields can dramatically improve efficiency by speeding up sorts and searchs. My database tracks mail sent on various mail dates to multiple customers with insurance policies that are assigned unique policy numbers. I've indexed the policy number. Question 1: Is there value in indexing...

I want to export a MS Access table to an MS Excel file. When I run the macro using the transfer database function it overwrites the excel destination file. I want to append records to the destination file instead of overwriting the destination file. Is this possible using the transfer...

Problem solved. Thank you very much.

Mike 375, This sounds like a great solution, I'll try this.

We append records in weekly batchs. If the user appends records with data errors, having the records at the end of the table allows for easy deletion of the records. I agree with jdraws guess that there's a default order on the table. I don't know how to remove the default.

I'm using a simple append query to append records to the end of an existing table. When I run the query, the records are automatically sorted within the table. My intention is to append records so they remain at the end of the table without being automatically sorted. How can I do this.

Thanks. Problem solved.

I want to use a dlookup function in a query that retrieves the value in an unbound textbox of a dialog box. In this example, I'm trying to retrieve the value entered in the unbound textbox called "Source" which is in a form called "Enter Source Code". I get an error message saying there is the...

The file attachment below provides a view of the relevant parts of the database.