Search results

If you add the line shown above and run the code, what gets displayed? Are there any 'E's in the value displayed?

I don't know whether this is the only issue, but look at the following str_E = Replace(str_E, "H", "") str_E = Replace(str_E, "A", "") str_E = Replace(str_E, "L", "") str_E = Replace(str_E, "S", "") str_S = Replace(str_Overall, "H", "") str_S = Replace(str_S, "A", "") str_S = Replace(str_S...

This may or may not help http://www.access-programmers.co.uk/forums/showthread.php?t=105404&highlight=updateable+query

Arwyn, just to confirm, is all now working or is there still a problem?

A) It isn't a holiday B) It's a celebration of the fact that he failed and was killed in a particularly gruesome manner. Hence effigies of him are burned.

How does that old gag go, again? "My friend stuck a firework up his, you know..." "Rectum? " "You bet it did."

Thanks to both. Setting focus to the form, then to the control didn't help, unfortunately. As is their wont, the bosses here have now shifted my priorities and I'll be working on something else for a while at least. As soon as i can get back to this issue, i'll post the stripped down mdb and...

Didn't these hunt lithotryptors? :D

Yep *sigh* you're suffering for my stupidity. :( This section is all wrong str_H = Replace(str_Overall, "H", "") str_A = Replace(str_Overall, "A", "") str_L = Replace(str_Overall, "L", "") In each of the above cases, you should be replacing the other letters with a blank (""), not the letter...

Stupid question: How do I do that (not the stripped down bit, the posting)?

Thanks for the response. Unfortunately, it's after. The full sequence is: [Forms]![frm_nbdash - ia]![cbo_Possibilities].RowSource = str_Source [Forms]![frm_nbdash - ia]![cbo_Possibilities].Requery [Forms]![frm_nbdash - ia]![cbo_Possibilities].Visible = True [Forms]![frm_nbdash -...

I have a field on a form that displays a list of people. In most cases, one record = one person, but in a few one record = one team of two or more people. Selecting a record causes the rest of the form to be populated. This works fine. What I've added is as follows: 1) User enters a name and...

It's a combination of that and the way in which serialized programmes are broadcast. Back home, a series starts with episode 1 and continues to the final episode, say 10. The only 'gap' weeks tend to be for exceptional events such as the Olympics, World Cup, Newsflashes, etc. Here, everything...

Mainly HD programmes and the difference is definitely noticeable. Canadian TV is closer in content to US than British (we get both US and Canadian where I'm living), so I watch less than I did back home. Can't pretend to understand the various technical aspects, as explained by other posters :D...

For what it's worth, I've got one of these mounted on the wall and I can't fault it. http://www.samsung.com/Products/TV/PlasmaTV/SPR4232XXAA.asp?page=size_contents The picture's excellent and, even without additional surround-sound speakers (next on my list), position your chair right and it...

I'll look out for that. Can't believe it hasn't come up before, though. Not for the first time, I'm very grateful for the forum.;)