Page 2 of 2 FirstFirst 12
Results 16 to 20 of 20
  1. #16
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272

    Okay, just tested. You need to change this:
    Code:
     
    For i = Forms.Count To 0 Step -1
    to this:
    Code:
     
    For i = Forms.Count - 1 To 0 Step -1

  2. #17
    accessnewb is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Location
    New York, NY
    Posts
    116
    works! Thanks again!

  3. #18
    accessnewb is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Location
    New York, NY
    Posts
    116
    just out of curiosity, what was wrong with the 1st code?

  4. #19
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    Quote Originally Posted by accessnewb View Post
    just out of curiosity, what was wrong with the 1st code?
    The form's collection is zero-based so I forgot and was using the wrong number as we had to subtract one from the count.

  5. #20
    accessnewb is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Location
    New York, NY
    Posts
    116
    Hmmm, makes sense. Thanks! You've been a great help.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Security Help
    By Cheshire101 in forum Security
    Replies: 4
    Last Post: 03-30-2011, 02:43 PM
  2. Access Security
    By Clinton in forum Access
    Replies: 5
    Last Post: 01-06-2011, 08:55 AM
  3. access2007 security?
    By asadi in forum Security
    Replies: 5
    Last Post: 12-21-2010, 04:56 AM
  4. Security..Is there another way?
    By marianne in forum Security
    Replies: 0
    Last Post: 07-19-2009, 07:18 PM
  5. Security Warning
    By mojo53777 in forum Security
    Replies: 0
    Last Post: 11-16-2007, 06:23 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
  •  
Other Forums: Microsoft Office Forums