Search results

Could you use something like Dim li_AI_Count as Integer li_A1_Count = DCount("*","tablename","Family = 'A1') using the name of the table from which you're fetching the Family data. Then assign this value to a field on your main form? If so, you could repeat it for A2 and C3.

Nothing immediately springs to mind. I have had something similar happen to me, when a field just would not allow me to update it. In that case there was something 'corrupt', for want of a better word, about the control itself. I was able to fix it by deleting the control from the form and...

Okay, so we know the overall string is being produced correctly. Process of elimination time: We add a few more Message Boxes and see at which point the code is going wrong. Dim str_Overall As String Dim str_H As String Dim str_A As String Dim str_L As String Dim str_E As String Dim str_S As...

You're very welcome. I do still slip up and use British terminology here, but the blank/quizzical looks are getting less frequent as their education is progressing nicely ;) .

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

Yes you do. I was an avid viewer before I left the UK. I believe SJMcAbney used to have one of the characters as his avatar. Gorwing up, I knew them as 'Hundreds and Thousands'.

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

Col, that's the joke. It's a line from 'Family Guy'.

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

You forgot to roll your eyes.

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...