Recent content by ajparkme

Try this: Private Sub Text45_AfterUpdate() If Me.Text45.value = "Test" Then Me.Check235.visible = true else Me.Check235.visible = false end if End Sub

Hi Andy! It is raining in Bournemouth too. Luckily I do not have a dog to walk at the moment, the weather does not seem particularly encouraging on that front. My first forum too! :-) Adam p.s. I just realised, you said wet England. Last time I checked, Bournemouth is also in England...

Yes, it is. You would just need to have the visible property of the check box set to true if the test is passed. If it is a value that you wish to store in your database, then of course the checkbox would have to be linked to a field in a table somewhere for later reference. Your example above...

Thank you, David R. George, would you like some sample code, or are you all sorted?

I reckon you could use the before update function on the field in question to test which date had been selected. It would involve some VBA coding, for sure - depends on your requirements as to how complex that would be. You could, for example, cause the date to "snap to" the nearest Sunday, if...

If you were looking for a comprehensive invoice tracking system, then possibly quite a few tables would be the way to go. However, you seem to be simply talking about raw numbers of invoices (or emails). I believe you would need one table to store the various office locations (which you would...

I cannot understand the behaviour you are describing either, I am afraid. However, would it be possible to remove the keyword "DESC" from the string you are testing like this, after the line For i = LBound(arrSortedFields) To UBound(arrSortedFields): Dim tempString as String tempString =...

I have been programming with access for many years, often search this forum for answers. About time I shared some answers here too...