Search results

Re: getting a number from a string Hi Thanks Both for your answers - i'll given them a go and see what i can do. Is this code best put into Outlook VBA i.e. before the value gets passed to Access, or doesn't it really matter? I'll give them a go now. cheers ian

Hi All I get an email from our website, with the subject heading: Promoter feedback - 23232, Bosbury Parish Hall I want to get the number and pass it over to Access to find that particular record. First stage is to 'capture' the number. With help from others I have this so far: out_eventid...

Hi Spikepl, thanks for your response. Much appreciated. Having looked at the Nz and the getrows features, these would have been a much better way to start, though i havent used them before. The arrays - i think my mistake was (not being a proficient programme at all) was that i borrowed the...

Hi Thanks for your reponse. I appreciate that i am using some reserved field names. These were inherited and now form the basis on hundreds of reports AND run the website, and it gets expensive to get our WEB guys to make changes - so i am having to live with it. However up till now it hasn't...

Thats really kind of you, thanks. Only prob is that i am working on a front end access, connected to SQL server, so you won't get any data. Though having said that i could import some data into a copy of the dbase i am working on? are you really up for that? :-)

ok thanks will do some searching on QueryDefs. cheers, appreciated. Have been working on it all day now and nothing i try works! And i fooloshly promised the admin assistant i would have this button done for her by the 4th... Ian

Hi All I have spent the morning trying to work out where i am going wrong, and to try and understand what i am doing, but have failed. I have googled some of the error messages i have received and though i have solved them. Because i am not much of a programmer, i think i must be missing some...

Yup, I can see now. And at last it all seems to work ok! That's a major new time saver for us. (not me it took many nights to create this little routine, but good fun) - simply clicking a button to send an email with info from the database in it - by way of a contract. I am a happy chappy...

Ah, so here it looks like there is an & _ at the end of each line so that i dont have to do the SQL= SQL & bit? and a final ; in quotes. It seems a much neater solution, thanks. Hope I didn't miss anything? :-)

thanks for pointing that out, and sorry again. Ian

Thanks Guys, sorry about not posting full code. As it was only the last line than was giving the error i thought it not necessary but i have now learnt different. It was indeed a rouge semi colon on the penultimate line - as soon as i removed this the code worked. Sometimes you look so hard...

Hi I have been trying to solve this for over an hour, and i'll bet it is something stupid. I have four line of SQL = statements. Two to select the fields, one as a from and one as a WHERE. The most important one, and the one that is giving me trouble. (i know this because if i REM it out the...

Spot on Paul! Many thanks. I did indeed have one missing. Really appreciate your help. Ian

Hi I hope someone can help. I am on Access 2010 I have a line that says Call DoRemote (strEmail, arrSummaryData(i).strPromoterName, arrSummaryData(i).dtDatefield, arrSummaryData(i).strFilmName, arrSummaryData(i).strVenue, arrSummaryData(i).curAdultTP, arrSummaryData(i).curChildTP...

Ah, thanks VbaInet. Both were in a Public Function which i should have moved over too. Silly me. thanks for replying. Ian

Hi All I am using Access 2010 I have two similar databases for tracking LIve events and Film Events. They both reside on my computer. I have some code that works in one, but i recently copies it into the other and received error messages. I check the References and both were exactly the...

Some while ago I tried to get this routine working (thanks to Darbid on this forum). I feel like I was close and this morning I have tried again. This is what I want to achieve - having highlighted an email address in Outlook, I click a button (macro) and it filters a form i have open to the...

Hi Spikepl Thanks for responding. Looks an interesting article and i am sure the answer is in there. My programming skills are not great however, and even when i use # around the dates it still doesnt work or i get type mismatch - e.g. dtTodaysDate = Format(dtTodaysDate, "#dd/mm/yyyy#") might...

Hi I have an access front end, and an sql server for data. Dates seem to be stored in sql in this format 2011-10-04 00:00:00.000 but thankfully they appear in our database in the UK format 4/10/2011. The problem is when i run VBA code from our front end i get mixed results. For instance...

Hi Darbid thanks again for your perseverance. that code comes up with exactly the same error run time error 424 - object required. so it isn't the code - it must be on the website.... hooorrrrayyyy. nothing has changed on the website, the code has always used the two controls on the site...