Search results

This looks better, you need namespace in there.

You need to understand this post from the other thread you just posted in. Strname is the email address of your shared folder. http://www.access-programmers.co.uk/forums/showpost.php?p=1066289&postcount=4

Hi cruz, I assume you mean this post? Could you please post your full sub addappt() as it now is. Could you post it in code brackets (see the little button # when typing). Could you also set out you code a little better to read it. Also could you please test some things. From the Outlook...

I am sorry I do not know share point at all.

here is my test mdb. It is a brand new mdb with no added references.

I just copied my code from post 4 into a new mdb and ran it. It worked fine. IE was closed, it was the openend, navigated to the page and worked ok.

no i dont understand you. is the code working at all, sometimes or never. If you stop the code from running until you are sure the page has fully loaded, does it then work? Are the fields filled with text?

before you run your script load the first webpage and then let it sit there for 20 seconds or so. ie make sure that it has totally finished loading the page. Then do you get the error. Second - look at the HTML source and search for the above word, is it still there. Maybe the web page has...

is the document fully loaded in IE before you are running your code? does "ctl00$ContentPlaceHolder1$txtUsername" still exist or have they changed it?

Sure - I have of course 2 record sets. 1. is a simple Select with about 8 fields from one table with a where that contains varying things. (Local table) 2. is a record set of a linked table with the same select but with a where for just one record based on the primary key. The number of...

Yep that is what I am doing, but for people a long way from the server this takes some time to get to the bookmark again. But from what I can see this is the only option.

Just closing off this thread with a fail. The RecordSet object does not hold its position if you swap. But I think it has to do with the size of the recordset. It seems smaller ones might have worked, but larger ones did not.

I have never needed to add an excel object into the body of an email, but if I were to, I would follow the examples here http://www.rondebruin.nl/sendmail.htm

Thanks again. The colours i might just use.

scratch that I am wrong - you are right. I was dreaming.

Hi and thanks for responding. Actually my control source is a Date - from what I can tell so far it is acting similar to the instructions in the help files as if it was a text source. Thus the Format differentiates between (null or nil string) and if there is something. I think it is working?

I would like to show "YES" if a control is not null or a "-" if it is empty or null. From what I understand of the Format property this should be "Yes";"-"But Access removes the quotes from the second part. So how can I use a "-" in the property? Thanks guys in advance.

use the link i gave you and use that function there in case there is something different. That code definitely works, so if you cannot get it to work the problem is with your folder structure.

The getfolder function is not working. You need to step through it to see where the fault is. The fault will be because you have not put the folder structure like it is expected.

My question here was about efficiency. I really cannot answer it. To solve my problem I have split my query up into 2 queries. 1 is the base query which is saved as a query and the second which is created in code based on the users choice. This seems to be working fast enough.