Recent content by cyb3rwolf

If I'm understanding what you're trying to do correctly, i would go a different direction altogether. I would create a query, and output that instead. If you're using user-defined filter conditions specified on the form; you can simply tie those filter definitions to the query definition.

Thanks; i had actually already figured it out shortly after posting this thread. I'll paste the link where I found the solution for anybody trying to accomplish the same thing; this is exactly what i needed...

Hey everyone, I want to have an outlook mailbox/folder selector embedded in an Access 2003 Form. I'm guessing a Microsoft Treeview Control would be the best way to go. I do not, however know how to go aobut populating the control with all the mailboxes and folders (including subfolders) from...

Unless i'm misuderstanding what you're trying to do, you can insert a Calendar ActiveX Control.

Bump again.

Bump. I should also add that what I have doesn't actually give an error, it just doesnt work. I made a test outlook folder with 10 unread emails with attachments. When I just run it on the default inbox, it saves all 10 attachments, and displays the message box indicating 10 emails were saved...

No problem whatsoever. :)

So, what i think you need is this: [Current_ADSL_Up] = ie.Document.getElementById("ctl00_ctl00_ContentPla ceholderColumnTwo_ctl02_lblSpeedEstimate").InnerText

I think if you use .innerText instead of .value you should be good to go. Try that and see if it works. .value is an attribute; meaning that the html tag would have to have value="(something here)" to retrieve it using that property.

You are welcome. Sorry, i realized the entire time i was accidentally pasting from something before i had edited it, so that was probably pretty confusing.

Here, here's my coded i did on a spreasheet i grabbed. modify this to what you need and you are golden.

Yep, that is the problem you're having and i just noticed that as well. I tried it and it worked perfectly. Change that line to this: DoCmd.TransferSpreadsheet acImport, , "MyNewTable", "G:\DataFolder\DataFile1.xls", False, objSht.Name & "!c2:q17281"

Hmm... I'm assuming the .Name property is the same as anything else i've worked with, should return the name of the worksheet. Let me try it and i'll get back to you shortly.

Yep, i made a mistake in that particular post; i didn't add "objSht.Name" to the range argument. try that full code i posted in my last reply. Basically, the sheet name has to be referenced in the range, or else it's going to look at only the first sheet in the workbook... Try the below full...

What that should do is repeat the procedure with each sheet in your workbook. And, each time it does, objSht.Name should (i think) return the sheet name, so each time it runs the procedure with each sheet, the sheet name will be included in the range it's trying to import. Editing post with...