Search results

  1. A

    Choosing bottom 3 for multiple entries

    I have a database with information on carriers, lanes, and prices. I need to choose the cheapest 3 carriers for each lane. The lanes are either 3-digit zip code to 3-digit zip code or state to state (410-300 or CA-GA, etc.) So for each of these lanes, I need to find the 3 cheapest carriers...
  2. A

    TransferSpreadsheet not Updating Table

    I have a TransferSpreadsheet macro that's supposed to overwrite an excel file with new data each time it is run (the access table is updated each time in a query). However, the data isn't being rewritten. I've checked the table and file names, and the query is correct. Any ideas?
  3. A

    Pre-existing form auto-opening

    There is already a form in the database I'm using that opens automatically when the database is opened. I do not want this form to auto open, but I want a different form that I have made to auto open. How do I turn this on/off?
  4. A

    Trouble importing external data - Access limit?

    I'm trying to import about 18 excel spreadsheets into one database in Access. I've been using "get external data" to import the spreadsheets as tables, and the first 8 of them worked fine, but now I cannot import any more excel files. The only error message I'm getting is "An error occurred...
  5. A

    Add new autonumber column to table

    How do I add a new column to an existing table, and fill it with number (starting at 1) so I can use that column as the PK? Step-by-step instructions would be great, I'm having a lot of trouble with this!
  6. A

    Import multiple excel sheets to Access DB

    I've been trying to load data from multiple excel worksheets in multiple workbooks into one table in Access. The first one loads fine, but after that I get errors and can't load anything else. All of the sheets are in the same format, so that shouldn't be the problem. Every solution I've...
  7. A

    Export table to specific excel tab

    How do I export a table from Access into an already existing Excel workbook on a specific tab, without erasing what it written on the other tabs?
  8. A

    Parameter query - allow user to select all

    I want to be able to have multiple parameter queries, but the user needs to have the option of entering a parameter or not limiting the output at all. How do I let the user choose "all", or what do they type in so that nothing is excluded?
  9. A

    Command Button to open 2 .CSV's in multiple tabs in excel workbook

    I want to use command buttons to open two separate .csv files in the same excel workbook on different tabs. Is this possible?
  10. A

    User input from textbox on form to table

    I want to put a textbox on a form that will take user input (a zip code) and put it into a table. I'm not sure how to do this. Is it even possible, and if so, any suggestions?
  11. A

    User input from textbox to table

    I want to put a textbox on a form that will take user input (a postal code) and put it into a table. I'm not sure how to do this. Is it even possible, and if so, any suggestions?
Back
Top Bottom