Search results

Hi Got it working! once I had turned on the views so that the menu appeared on the left! Got the code working too, so a test button appears on the contacts - need to have a good long think about code that might do what i want now! thanks for you helps ian

HI I have never work in vba in outlook and the instructions on the link are not great. Can you tell me how to get to the correct place to try the code? I have tried tools: macros: visual basic editor it may be that 2007 looks different - the instructions says: 'To use this example, copy and...

Hi Thanks for reply. We are on a mix of 2007 and 2010. Though we could all be on 2010. I did wonder about trying to put an EventID number in it, but felt it would work - ans some people just start new emails to us. The email address they are using though will be stored on our database, it...

Hi I dont know if the following is possible, or if anyone might point me in the right direction for more help? We organise over 700 events a year - each event is a record - and most of our emails received are to do with one of the those records. We spend a lot of time receiving an email, going...

Thanks Bob, appreciate your time. Ian

Hi Bob Thanks for replying. No wonder that i couldn't get it to work as it wasnt simple! Perhaps I'll just change it to a yes or no field. I just wanted it to stand out more as it was a crucial piece of info. Is there at least a way of making the field value bold? my emails are HTML anyway...

Hi All I have a button on my form which produces an email to a person with all their event bookings on it:- Dear xxxxx, Below are your requested bookings. Please check all the details and read to the end of this email: Date: 20/11/2010 Film: The Disappearance of Alice Creed Time: 7.30pm...

Hi Not sure I can help as I am quite a novice. Where is the problem exactly? When you are asked for the box # - what do you type in? I am assuming you type in for example 0011 and not 11? ian

Hi All, I was just wondering if my question wasn't clear enough or whether what i was after was too difficult and no-one knew the answer! Thanks Ian

have you tried looking at the northwind database - the sample that comes with access? They use this (i think ) on the orders form. You'll be able to work it from this. If you dont have it it is available for download, just google it. Ian

Hi All I have a continous form with over 600 film events on it. for each record a combo box drops down with all the available films in it - and the id of that film is stored in the events table. The combo box itself, has several columns of course, the aforementioned ID, also the film name, run...

Hi Thanks for that I will give it a go - not that i understand it too much but i am sure all will become clear! Ian

I think you need to take a step back on this first ...] ah. am i after something difficult? i was hoping that it would make things much easier to operate. [When a new film (copy) is needed I would perhaps have a button called "add" next to the drop-down list that would call up another FORM...

Hi I have a continuous form that lists dates of film screenings, date time and which film is being screened. a combo box list all the films (this isn't quite true but see later!) we have on our database. When the user types in a new film that isnt on the list, a box comes up saying...

Thanks Both, you led me int he right direction. The tricky bit was getting the correct string for the search bit of the website. here is my code which works well Dim play Dim searchterm play = "http://www.amazon.co.uk/s/ref=nb_ss?url=search-alias%3Daps&field-keywords=" searchterm = play &...

Hi I would like to be able to type the name of a film into my films database, push a button that will then go and search a website (e.g. play.com) for that film name and bring it up in a browser. Is this possible in access? Thanks for any tips! Ian

i tried it another way. I copied the ComboBox (with the columns, one of which i wanted to show in a text box). Pasted it onto the form. I then made most of the columns 0cm length leaving it to only show the column I originally wanted. And locked it so users couldnt change the entry. And it...

Thanks for your replies. As predicted the onexit or afterupdate didnt work, as Galaxiom says. i then tried to put the field i was referring to in the text box as part of the underlying query, and this threw up a whole host of errors including 3156 timeout issues, and other bizarre ones. Too...

Hi I am trying to do something simple.... ha. On a continous form i want a textbox to show me the value of the 3rd column in a combobox on the form. so i add a text box and give it the control source =[filmCopyID].[column](2). It works well, and i see the data i need to see. however if i...

thanks for the push David. can i beg your indulgence further? I have been trying some things since i got your message. I should say i am only a beginner! i added a textbox called search, then used an update event, but got a bit stuck. i created a "stringwhat" expression which equal whatever...