Search results

what i am trying to do is get the account that my sent email is in ( great when its the "default" ) but when its another account the following doesn't work so I looked at various options to call the alterntive account to be the default "sent folder" what i had in mind was if X = true...

digesting .. (thanks) - blinking interents gone wonky...

Access 2010 .. ok guys when I type the following 4it spanners out on top line on Application.sessions.accounts (its the sessions - its not seeing - ) what/where have I goofed ? (the intention is to set the getdefaultfolder to the account I need as I have two accounts and this looks...

Not quite what I had in mind front form - has a timer event on it nad this dispperas once I go beyond form A Front Form - Form A - and back Front form visible Front Form -Form A - Form B and then back Form B form A and then it should be front form - - this is not visible

Hello everybody.. I have what is probably gong to be very simple .. on my start up form "Welcome" a timer event (interval 1000) If (Time() >= "04:20" And Time() <= "04:22") Then Quit acQuitSaveAll End If - all well and good and does the job I want (to kick all users out at x time )...

OK stupid me - Query 1 - fine and dandy Query 2 - I "coded" it to put the "sortorderno" I needed - so I tihnk that element might of been text... sometimes taking it slowly to see where the issue is - is the easiest way .. thanks

Whoooo hold your horses .. - when I just do the second one - I think it works ..

convert to double ..

whats the cdbl for ?

no number..double standard

testunion sortorderno 0 10 110 120 130 140 150 150.1 151 151.1 152 160 170 180 190 2 200 210 220 230 240 250 260 270 280 380 390 9

Hello people I am sure that I am just missing the plot on this one ok - 2 queries excatly same field names (keep it simple) I get all the data I want - great - but cannot get it to sort (Numerically ) the first field is numeric and is numbered 1-999 (with gaps ) 1-199 is x and...

Dim olAcc As outlook.Account Set OlAccSess = outlook.Session.Accounts.item(2) -two being the alternative and then I cna play with an if statement

*Thanks for that (typo) this is the thing I either need to reset the default or change olkns .getdefaultfolder(olfoldersentmail) to olkns .Account.Session.item2 (olfoldersentmail) and put an if statement in there if false then .... I tried this and it does not like it

thats for this - thats the bit that throws me - how do I reference with olkns. xxxxxxxx(old=olfolderasentmail) to see the right profile? thats the bit that throws me - (which is why I suggested changing the default profile as an easier option) the trigger would be if me. eu = false -...

Hi Guys I have had a stab at this and i seem to fall over .. Is there a way (VBA) to change the default outlook profile from 1 (default) to 2 - I can send an email and get Access 2010 to know which account to send from but after I have sent an email the D/b then checks sent items...

OK I found this and I presume that I can edit Inputfolder refernce the sentfolder? Dim olNS As NameSpace Dim InputFolder As Outlook.MAPIFolder Set olNS = Outlook.Application.GetNamespace("MAPI") ' Get reference to folder in users Mailbox for Input Set InputFolder =...

Hmm - this one has me stumped## thought it would be easy just to set the reference but ..

would this not work ? Set OlkSess = Application.session(2) ???

Hi Guys I am sure this is a quickie I am passing through from access to outlook ( I can get it to send from default and also send from an alterntive account (2) but the filing system looks at the default "get Default" how do I get it to look at the sent account (2) profile ?? Dim olkns...