Search results

I found some code on the internet, and its perfect to remove duplicates. however, it removes the most recent entry. I want it to remove the older entry. Been playing with it all day, and still can't seem to find a conclusion. Any ideas? Option Compare Database Option Explicit Sub...

Here is my sql: INSERT INTO qry_appendDuplicates SELECT tbl_MasterFundReview_raw.* FROM tbl_MasterFundReview_raw; The tbl_MasterFundReview_raw is the original table. This is simply the sql from the query, so not sure it will help much???

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

aah that idea sounds interesting. do you have some code I can look at?

no, this isn't what I want. I have lots of spreadsheets to upload onto the database, linking isn't a viable option. is there anything I can do with SQL?

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

Thanks Chergh, the value in a combobox is retained. Just finally, I've found something to open the file. Next error is in the syntax you gave. any ideas. Otherwise, I'm just going to redesign this whole thing. i thought it should be easy enough to pick up data, but its causing more...

so how do I open the worksheet in access, and retrieve the information. Also, wouldn't this slow down my database if I have to do about a hundred a month?

no, its shut. should it be open?

Thank you, this was exactly the type of code I was looking for. Its so obvious, I'm just not very confident in Access as I am in Excel. I've tried that line in my code, and I get "subscript out of range" error message. I've define strsql as string, so why am I getting this message?

Hi, yes, thats exactly what I'm trying to do. any ideas?

anyone have any ideas on how i can do this? I want to bring in selected combobox results from the table attached into an access database. Thanks!

Hi chergh, did you find a solution to this? I'm trying to do the same thing.

Hi, I've included an attachment of a very simple version of my spreadsheet. I have hundreds of these filled out, and I want to populate a database with these. Any ideas? I thought, since everything is labelled, and populated, I could do something like pick up comboboxXYZ.value. Just not...

I want to keep the excel spreadsheets and the database independent. Once I store all the information on access, I can delete the excel spreadsheets, because there will be a hundred new ones every month. So, my excel spreadsheet looks like a form. It is made of lots of comboboxes, textboxes...

Thanks! Thats great, and it helps with problem 2 (the loop). any ideas on problem 1? How can I pick up the data from the excel file? Thanks again

Thanks DCrake and Uncle Gizmo. DCrake, I'm comfortable with VB, so i tried your method, but it enters the Do Loop, and immediately exits without looking at the field name and path. Do I need anything specific switched on in my reference library? Thanks

Hi, I've already done this. The hidden lists are now tables in access. How do I do the loop to go through each name?

Hi, yes, all my files are in the same format. they are essentially forms with comboboxes which are populated by a hidden list.