Search results

Hi, I a table in access. Sometimes when I do a mass upload, I can return some duplicate entries to what was already in the database. I know about append query to remove duplicates using primary keys. My problem is, this append query will delete the newly uploaded data and keep the old...

Hi, My database has some queries and reports which I want retrieved by selecting a button on a form. I want the user to select a query, and a form will pop up to request which date they would like (this form contains comboboxes and listboxes to ensure valid entries). The user can select...

Hi, I want to import a very basic excel spreadsheet into access, and I'm interested to know if there is an alternative to doCmd.transferspreadsheet acimport? I know this method is simple, and I've used it many times, but is there an alternative. If so, can someone send me the code, or give...

Hi, Aim: I am building a database that picks up the results of a table in excel. (The table in excel is created by combo boxes and list boxes). I have about 100 of these excel tables in different files. Problem 1: I want to go into each file, and pick up data, and populate a master table in...