Results 1 to 5 of 5

Thread: Look through all forms in Access Database and set back colour

Threaded View

  1. #1

    Thread Starter
    Fanatic Member Ggalla1779's Avatar
    Join Date
    Feb 2006
    Location
    Glasgow
    Posts
    532

    Resolved Look through all forms in Access Database and set back colour

    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:
    1. Static dbsCurrent As Database
    2.     Dim cntTemp As Container
    3.     Static intCount As Integer
    4.     Dim intCounter As Integer
    5.     Static Objects() As String
    6.     Dim varreturn As Variant
    7.     Dim prp As Property
    8.    
    9.    
    10.     Set dbsCurrent = CurrentDb()
    11.     Set cntTemp = dbsCurrent.Containers("Forms")
    12.     intCount = cntTemp.Documents.Count
    13.    
    14.     ReDim aObjects(intCount) As String
    15.    
    16.     For inCounter = 1 To inCount - 1
    17.         cObjects(intCounter) = cntTemp.Documents(intCounter).Name
    18.         cObjects(intCounter) = cntTemp.Documents(intCounter).Properties.Append     ?????? unsure how to use this
    19.  
    20.     Next intCounter
    Last edited by Ggalla1779; May 24th, 2006 at 06:44 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width