Hi all
Am trying to loop through all forms in database and set the back colour to a colour.
Is this possible??
I code set lead me to only active forms......other code leads me to just list form names in Access Forms Container
Any ideas???
cheers George
VB Code:
Static dbsCurrent As Database Dim cntTemp As Container Static intCount As Integer Dim intCounter As Integer Static Objects() As String Dim varreturn As Variant Dim prp As Property Set dbsCurrent = CurrentDb() Set cntTemp = dbsCurrent.Containers("Forms") intCount = cntTemp.Documents.Count ReDim aObjects(intCount) As String For inCounter = 1 To inCount - 1 cObjects(intCounter) = cntTemp.Documents(intCounter).Name cObjects(intCounter) = cntTemp.Documents(intCounter).Properties.Append ?????? unsure how to use this Next intCounter




Reply With Quote