Search results

Hi Darbid I am wondering if one of my references has become corrupt. Which Reference do you need to run this code? thanks ian

ok, i'll try and be clearer. below is the code and i got it to pause on each line and have commented on what is happening. Dim ie As Object Set ie = CreateObject("internetexplorer.application") ie.Visible = True LOADS IEXPLORER ie.navigate "http://www.artsalive.co.uk/promoter-login.aspx"...

Hi Darbid yes i get the error if i have already loaded the page - though the script open a new ie window and doesnt use that one. i noticed that the username and password fields (below) are have correctly obtained the two values from the database. 'add username...

Hi Darbid I dont quite understand the question. if you remember (as you helped me create it!) this routine loads a webpage then gets the username and password from the access database. thanks ian

hi sorry to reopen this thread, but for the last few weeks the code has stopped working! I just checked and it is just the same as before. now when i hit the "login as promoter button" i get a runtime error 424 Object required on...

wow, that worked a treat! You are awesome! Many thanks Ian

Hi Darbid Thanks for replying (again!) The link is here: http://www.artsalive.co.uk/xxxxxxxxxx.aspx i'll take a look at the link you sent me thanks. Ian

Hi All I run a small charity and we have about 100 people (promoters) who login to our website. i store all their passwords and login names on our SQL server (which feeds the website). As all this is quite new, I am finding myself logging as different promoters to check their account. I can...

i am sorry, i missed that bit of code. thanks. i am stuck a bit between to two programming styles. there is only one more problem i have, but i will make another post as i have used up your generosity. many thanks again for all your help. i am not a confident programmer. ian

Hi Darbid the problem is if i take out the line Set accessApp = CreateObject("Access.Application") i get a runtime error 7952 "you made an illegal function call" on the next line: accessApp.Run "ReceiveEmailFromOutlook", outlookMail.SenderEmailAddress i have tried googling but apart from...

Thanks Darbid. I have put back in a lot of your code as i appreciate that there were good reasons for them to be in there. I think when we worked on it, and had quite a few issues, that we stripped it bare so we could understand more easily what we were dealing with. I appreciate all your...

Hi Darbid My daughter boyfriend was round this weekend - who is a programmer. He has managed to get the project working, though there are still 2 issues remaining. I don't kniw if i should start a new post for them? But for anyone following this link, here is the code that works along with the...

Thanks for persevering. i can get as far as MsgBox "this is what you need to put next" & Dir(objDBase.Name) if i comment this statement out i get onto the If Dir(objDBase.Name) = "z:\databases\flicks database.accdb" Then now, same problem that i asked about before - this is an if...

Hi Darbid Thanks for speedy reply. I fear i have bitten off more than i can chew! I have spent hours on it so far and only make a little progress. I dont even understand some of your answer or know what to do. you said take the LEFT FUNCTION formt he line - well i have tried various ways of...

Hi I have managed to make some progress, but i have a couple of questions Firstly, Darbid you asked which part of the email i was after - i am after the email address of the person that sent it - the code at the monent gives my address. I have played around with Sender.Address but to no avail...

Yes i am running access 2007. and it is up on screen. run time error 429 activex component cant create object. I.

Hi couldn't resist looking at this when i got home! At the moment i am stumbling on this line Set appAccess = GetObject(, "Access.Application") after googling it seemd to be a Reference problem but i have tried several references and still stumble. Any ideas? cheers ian

Hi Thanks so much for this - will take a look over the weekend as i have to leave now. best wishes ian p.s. thanks for the reply on the other thread too!

Hi Darbid, that sounds fantastic - are you able to do this? Won't it take a lot of time? <<As I said your real task is to decide where an email or other outlook item belongs in access.>> i don't quite understand this question, sorry. it is the email address rather than the email body, that i...

Thanks again for replying. When i get some time i will look at a button in outlook. Although within access i am fairly confident in programming buttons i have never done so in Outlook, but perhaps it is very similar? I will perhpas look at doing a button in access that will do the trick and...