Search results

I think perhaps we ought to have a poll on that! ;)

Keep on chooglin' my man. By the way I've just had details of a website called http://www.rock-til-you-drop.com/. It's for old buggers like us and Col who just won't lie down. Cheers.:D

So as long as I believe something - it exists? Sorry Tim but it seems to me that you have as much idea of how many beans make five existentially as I do, which is not saying a lot.....

Naturally you'd be one of the notable exceptions ;):D

This may appear obscure to you but I think if you have to ask why, you rather prove the point I was making. Thankyou for your answer but my question was actually rhetorical, not literal and was heavily ironic. I appreciate that with the exception of a few notable posters on this forum irony can...

Well after reading through that lot and coming to this last sentence I'm sure we're all glad that you're feeling the wiser.... Tell me - you don't work in a strategy and communications department do you?

Only in my darkest nightmare, the one with George Formby and the Big Ben Banjo band.:eek: My sig is a protest against all those bedroom bass players on YouTube with 6 and 7 string basses who should take up the guitar and leave a perfectly good instrument alone......

Bang on that appears to be it. Brian has a theory that the spacing prevented concatenation. Many hands eh Rabbie?

Cheers Brian, they do say the devil is in the detail......:)

Solved :D Here it is people strSubject = "New feedback from a customer at " & DLookup("[ShopMail]", "tblShops", "[ShopID]= " & Me.txtShopID) compare strSubject = "New feedback from a customer at " & DLookup("[Shop]", "tblShops", "[ShopID]= " & Me.txtShopID) Works strSubject = "New...

Re: strSubject and DLookup in email - Solved! I stopped chewing the ceiling and came up with a solution (workaround). I created an extra field in tblShops called "ShopMail" and wrote in the full message for each shop record i.e. "New Customer Feedback from CCC No 1" and called that with the...

Brian I've deleted the rogue post! The bloody post stuck first time around when I was uploading and did not appear when I went back to look for it! :eek:

No the space made no difference. If I remove the part “New feedback from a customer at ", the mail fires and places the text field "Shop" in the subject line as needed. I could probably live with this as the shop is identified but it would be nicer to completely idiot proof it with the...

Hi Brian Both these get the end of statement error strSubject = “New feedback from a customer at" & DLookup("[Shop]", "tblShops", "[ShopID]= Me.txtShopID") strSubject = “New feedback from a customer at" & DLookup("[Shop]", "tblShops", "[ShopID]= " & Me.txtShopID)

Hi rabbie Afraid it reds out and in the dbug window I get expected end of statement

Hi missinglinq No - it's a number type in the table pulled through into a hidden text box on the form.

An email is sent on close of my form. We have three shops (CCCs) and I’m trying to eliminate a line of hard code so the email selects the correct shop name depending on the value of field txtShopID. The hard code line below works fine and the email is sent using: strSubject = “New feedback...

If only I had a plan!;)

Bob I searched high and low for code to do this, on this site and others. I got loads of stuff that was complicated and failed miserably on test and you had this all the time! I can't believe how elegantly simple it turns out to be. Many thanks to you and all who contributed to this thread...

I went on so I could stay in touch with a mate who left for Australia in a marked manner. Was it something I said? For that it's quite useful. The problem is friends who are really into the whole Facebook culture (if it can be so-called) end up sending all sorts of invitations to participate...