Search results

Sorry for taking so long - we just had massive layoffs (which I survived...) Anyway, all the (updated) code is below. After re-examining the code outside the function, I've had to comment out two lines which are pointed out in Command0_click(), due to it causing the code to error out "Object...

I've uploaded the problem excel spreadsheet that I'm trying to import in Access 2010, as an example as it's not a typical .xls file. These spreadsheets come to us with an .xls extension however the format they're sending is actually HTML. The code I have is able to import it after I give the...

Thank you however I'm not sure how to implement it.:( I inserted a new module, pasted your code, named it CheckerOff, but can't figure out how to execute it. ;-( I assume it should run just before the DoCmd.TransferSpreadsheet Can you enlighten me pls?!

The Access import routine I'm using won't complete the import till that box is acknowledged. It stops every time during the import (as noted in my second reply to another response below.)

Thanks for the reply, it's appreciated even tho I've already tried those suggestions w/o success. Someone helped out tremendously with some code that will at least import it once I click on that box to never check for compatibility (his code also renames the file which doesn't help as Excel...

First off, I'm a complete novice with VBA. I'm using Access 2010. I have a database that during the import of Excel data, it brings up a dialog box, "Minor loss of Fidelity." I've searched high and low but have found nothing to dismiss that box using VBA. Reg hacks have been tried...

I have some code to send an email from Access however in the .HTMLbody, I would like to have part of the .HTMLbody set to a variable because at the beginning of every month, there is a URL within the body that changes. Can anyone help me on setting a variable for the URL as well as how to...

.xlsb is a binary Excel extension however you're partly correct as I really am not looking for binary excel files so I will change that. Thanks for reply!

I have the following code which successfully opens the dialog box with filters however when I add a function to help with an Excel import, the filters do not work at all (no files are shown even though they exist in the directory that's opened within the dialog box). If I manually type in the...

Thanks so much for your assistance! Still trying to figure things out but I'm a whole lot closer :D

I am a complete novice at scripting so please bear with me... ;-) I have a query that randomly selects records from my table: SELECT TOP 6 * FROM SM_Import ORDER BY rnd(INT(NOW*id)-NOW*id); I would like to loop through those results, and create emails I can get one email formed (displayed)...

I placed your code in a new module "RandNumber" however I'm not sure how to use it quite frankly.... :(

I need some help with VBA code to first generate a random number between 1-4. Then I would like to use that number to pull that many records out of the database; the records pulled can be random, or whatever. For example, we have 4 people and my goal is to choose a random # of records to pull...

I have HTML files that end in with the extension .xls They do not have field names in the first row. When you attempt to open one in Excel, it coughs a bit with an error and then opens them (since they're HTML). I can then save the spreadsheet, then import w/o issue into Access. But I don't...

Sounds good, but unfortuantely, I don't know how to write a query like that.... Any examples would be greatly appreciated. Thanks!

I should have clarified a bit more. Each time the data is pulled into table 2, I need to copy only the records from table 2 to table one if the records don't already exist in table1. So, each time the query or vba code would run, it would be continuing to grow table 1. As an example, it's data...

I have table1 in my (Access 2010) database that has exising records. I have another table2 that after I run a query, it first deletes the data in table 2, then imports new records into that table. I run the import into table 2 on a semi regular basis but have yet to copy those records into table...

Thanks much! I will give it a try.:)

Microsoft has a Desktop Student Database template (Access 2010) that does exactly what I'm trying to do: open the Outlook Contacts dialog box, select a contact from the GAL, and then programmatically save it to a record in one of my tables. I've tried simulating the button/coding on my data...

Thanks, that did the trick! :D