Search results

I though that was what I you ment by "Store a concatenation of IDnumbers in that variable", at least Google though so more or less :p Anyway, thanks for the help again, problem is solved and I am a happy man :)

Thanks Minty but arnelgp's code did the trick so will just use that :) Working code if anyone one else should have the same problem. Private Sub Form_Load() Dim ctl As Control Dim IDNumber As String Dim strSQl As String Dim col1 As New Collection Dim strIdNumbers As Variant Dim arrValues()...

Ok, thanks Uncle Gizmo, I'll try to remember that for next time :)

Thanks a lot arnelgp, that worked wonderfully :)

Ok, I think I am on the right path but I can't figure out how to get the array into the SQL statement. Dim ctl As Control Dim IDNumber As String Dim strSql As String Dim col1 As New Collection Dim strIdNumbers As Variant strIdNumbers = strIdNumbers & " ID = " & IDNumber & " OR" For Each ctl...

No worries, thanks for all your help so far :) Trying to find out how to store number with the concatenation function at the moment.

Hello, I have a small problem I can't resolve and I have now search the web up and down and back again so I hope this will be my final stop, at least for this problem :) I got a Form with many TextBox's named "Date****" where **** is the record ID number. So instead of having to type all the...

Thanks JohnHBooth, that worked perfectly :)

But there is my problem, how do I set it to red if it find any fields with nulls? Right now all fields have to be null for it to be red and it turn green as soon as one of the 90 fields have a value.

Thanks for the replay but green indicates that the form is finished so can't have it start out green or is that not what you meant? I would like it to check every time someone goes in and out of that form yes.

Hello, I have a small problem I can't find the answer to, been looking and trying different things for almost two days now. I have a form with about 90 text-boxes (logging form for a test) and I am trying to make it so that when all fields are filled out then a label turn green and turn red if...