Search results

Hi James Most interesting. When I clicked your link it worked - but on mine i get the %20 in the imdb search box. But ONLY on IMDB, in other search engines it works ok. My search term has spaces in it = "http://imdb.com/find?q=127 Hours" So it seems I need to get a %20 instead of the spaces...

Hi I have a button on my form which when pressed goes to imdb.com and does a search for the film name that is on the record. This used to work but now I get a %20 instead of spaces when I arrive at the imdb site. (127%20Hours instead of 127 hours) I think I have to use underscore in the film...

Sorry it wasn't clear. But all solved now, thanks for replying. I just wanted a list of unique films, with the count of how many times they appear, but i was getting several film names twice, as you can see from the images.

Oh God, stupid me, I never thought it was because of these - I sometimes have to use these groupings, but never thought they would interfere with what I was trying to do. See,s like I had already decided it was something else - serves me right. When I took them out it worked perfectly. Thanks Plog

Hi All, I don't know if you can help. I have a unique query which lists all the films that we are screening over the next 3 months. I have added a COUNT field so that I can see how many of each films we are screening. The problem is that i get duplicates of some films - and this may be...

Ah, I see. I have to force it to go into US mode, then some magic works when I run it - it turns it to UK mode. That kinda felt counter-intuitive, but it works. My line now looks like this: "#" & Format(.Fields("today").Value, "mm\/dd\/yyyy") & "#," Thanks very much, and have a great...

Thanks Paul. I couldn't really see anything on there that helped. I tried the format \ / between the dates but it didn't make any difference. At least I can't see anything, especially given the syntax I am using. Can you see something obvious that is wrong with my statement? Thanks

Hi All I have a routine which keep putting in a date in the U.S. format and I am in the UK. I have tried to research and come up with a solution but still can't get it to work. Does anyone have any clues please? Application.DoCmd.RunSQL "INSERT INTO temp_tbl_QBData([flicksfeedbackleft]...

Hi All Thanks to the forum I have managed to do 95% of what i need to do. I have a database of film events, for which i have to do posters. With the click of a button on a form, access opens word and puts all the fields in, including a field called [photo], which is the name of the image...

Hi All Has no-one any ideas for me? My button is still not working! Thanks Ian

Is this a clue? I just put a 'watch' on the value of cn. Under default database it says "Operation is not allowed when the object is closed" Now, if this is talking about the database, then it clearly isn't closed, because I am in it when I run the code! So does it mean something else? Ian

Thanks for the reply. They seems to be ok, Access, Office and Outlook 15 and ADO 2.8. Ian

Hi All, I have been using this button for years and it has always worked. The button puts info from the database into an email). But suddenly I get the error -2147467259 ODBC "Cannot open database (unknown). It may not be a database that your application recognizes or the file may be corrupt"...

No problem, always good to refresh memory¬

Hi Chris Yes you are indeed correct: Private Type SUMMARY_DATA strPromoterName As String strEmail As String dtDatefield As Date strFilmName As String strTime As String strVenue As String curAdultTP As Currency curChildTP As...

Problem Solved! I used the line: If strDVD = "False" Then When I should have used the line: arrSummaryData(intRecordCount).strDVD :banghead:

I have just been trying to find out why that is there. But I cant seem to remember, all I know is that if I take it out then I don't get the promoters name at the top of the email! I am still working on this so if I come across the reason will post again. cheers ian

I have just been trying to find out why that is there. But I cant seem to remember, all I know is that if I take it out then I don't get the promoters name at the top of the email! I am still working on this so if I come across the reason will post again. cheers ian

Hi All, I have been wrestling with what i think is probably fairly simple! I use my Events database to create an email which includes all the details of an event. One variable I have is [owndvd], which is a tick box, and therefore holds a "True" or "False". To create the email I use (there...

Re: getting a number from a string Hi all NEAR Success!! Many thanks for your replies. I am not a very confident programmer and have been trying the FUNCTION solutions. I kept running into error messages which are probably pretty basic to you guys - ones like Compile Error - Argument not...