Search results

Hey Designed by Sue, I have done something similar however in my case my source was an excel chart that I copy and paste into word. I must admit I do not understand if it is the whole report or an image you want in word but here is how I do it in Excel. 'This is take out of a with section...

Yep code added. Note there is no "Set recipient" in there and no resolve. I think if you display the task with the email addresses, then when you click send, it will do the recipient stuff at that stage which is how Outlook normally does things when you type an email address.

I want to reduce my 99% down to 80% as I see in my code I am using a trusted outlook application object. I have a hack in which I have an Outlook addin and it has a "safe" outlook object. I call that addin from access to give me that Outlook application object, everything that is built off of...

I can only see one image added to the thread which is the trust center window. It does have some restrictions that I am not familiar with but I still think that if he follows my suggestions then he will not run foul of the special security settings set by an admin or Microsoft's Outlook...

Ok. I kinda gathered that, but find that very hard to believe. As long as he does not use an Outlook.Recipients object but just adds email addresses to the Task.Recipients.Add method his Outlook exchange is not going to know about it. The thing to avoid is to call resolve on the Recipients...

Hi all, this is a pretty long thread and I may not have picked up on everything, but I am a little bit concerned about leaving it with sendkey as a solution. I hope I can improve on that for you. First I believe that if you are going to start a new instance of Outlook as you are doing in your...

Lets make my answer a little more generic then. HTML Scraping is not a good idea, for many reasons including that the owner of the site might not like it, may try to code to prevent it and every change that is made to the scraped part of the website will have to be reflected by you with changes...

that looks good. Now I have to decide if I will change over to it or not.

It is worth a try, but I am pretty sure you will not get the HTML text into the XML class.

I know this question is old. Recently I had similar questions (but I was using Vb.net so I had a few more classes at my disposal) and I came up with the answer, NO it was not possible. I was a little surprised I could not get it into some xml class. In the end once I got the HTML I just...

Hi guys, whilst scraping the HTML of a book supplier is a good answer, I think for books (especially) scraping HTML is like building a steam powered car. I would suggest you instead look at API which supply you information in XML format. For example this one...

I agree with vbaInet. It could be a security issue. Can you try going to another URL like Google and see if that works. my guess is that when you "set IE" it is set at a certain security level. But your url is changing the security level of IE and thus the IE object you set before is now gone...

Hi all, Access 2007 Front End / SQL Server Backend. I have to change a few column names in my Tables. I am looking for an easy way to check all the places where this column name is used. In VBA modules i can search for its usage, but is there a way to search if the column is used in a form...

I just had a look at the HTML behind the search page, it would be very easy I think to fully control this page. For example the text box for first name <td class="label" rowspan="1" colspan="1"><span id="lab_first_name">First/Mid Name:</span></td> <td class="textbox" rowspan="1"...

Hi mate, So the example you gave us/me I could not get to open. I dont know what format it was but my access 2007 complained so here is mine attached below. 1. I dont know much about web sites, but my guess is that when you do a search there are either tokens or .js files kept in the temp...

http://www.access-programmers.co.uk/forums/showthread.php?p=1008218#post1008218 check out this post.

If you make me an example where you get an error I will take a look at it. Something like this Private Sub wb_NewWindow2(ppDisp As Object, Cancel As Boolean) On Error GoTo Err_wb_NewWindow2 'your new form Dim frmWB As Form 'get the new form ready but keep it hidden DoCmd.OpenForm...

In my opinion there is little difference. The webbrowser control is just like a translator in languages. It simply allows your VBA to talk to IE. It is however old which means that IE might have a function which you cannot call from the control. Other than that it works identically in that...

PS if you make up a little access example and post it, I will test it for you. Access 2007 would be best for me.

Other than the error, what do you want to happen? You should not be getting the error. I have a feeling that the webbrowser control and webbrowser itself are not communicating correctly. Given that this control (wrapper for com) is very very old it is possible. One thing you could do is...