Search results

The attached jpg shows a view of Access Query Designer that I can not seem to duplicate. I am trying to use the Access GUI to build ranking queries but it appears that I first need to get into this view before I can do so. I am using Access 2k3 SP3 so it can't be a function of the version of...

I have a number of spreadsheets that I would like to: open Spreadsheet #1, run a macro, close, then open Spreadsheet #2, etc. None of the code samples I try work. Typically, the spreadsheet opens, but in some cases the macro does not execute, in other the macro fails. Is there a recommended...

I know this has been asked and answered, but I can't figure out the answers to meet my requirements so hopefully someone can help me. I have a database which consists of several stock tickers sorted on "Date" and and calculated value ("ABS"). What I require is to be able to generate a "Ranking...

I am currently importing data using the the "TransferText" method in Visual Basic; e.g., expression.TransferText(TransferType, SpecificationName, TableName, FileName, HasFieldNames, HTMLTableName, CodePage) Per the above description, I can either include the first line as a field name, or as...

I am importing a large number of large text files (>10,000) into a single table. This part works fine but I am finding that VB is painfully slow (approx 2 hours) for this kind of thing. What I would like to be able to do is to is to limit the import to the last n records in each file...

I am currently using this Query to delete all records in Table x: Delete * From x; Then repeating similar for Table y, then Table z, etc I would like to delete all records from multiple Tables in a single step, e.g.: DELETE x.*, y.*, z* FROM x, y, z; I get an error message "could not delete...

Don't even know where to begin with looking for a solution, so here goes with the explanation of the problem... Daily, I receive 3 lists of data (Item, Item1, and Item2) which imported into 3 Access Tables • Item Table is a complete (Master) list against which the other lists are compared •...

I am trying to run an Append Query with Primary Keys (so as to eliminate duplicate records). Problem is that I would like to automate this in a macro but keep getting a "...can't append all records..." warning message, which requires I press a button to continue. BAH!! I have tried...

Somewhere I seem to remember having seen that it is possible to add to the list of recognized file extentions to the DoCmd.TransferText (so long as the files being imported are true ASCII type). Can anyone help me find the instructions? As always, many thanks in advance. k

I am using the ===CODE=== at the bottom of this message (lifted from somewhere) to import >5000 CSV formated datafiles into one table. No problem with this part. I have been struggling with the code to append the file name (minus extention to each record. I believe that I can use the follow...