Results 1 to 3 of 3
  1. #1
    dikdikdikdik is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    May 2012
    Posts
    2

    Code in Access

    Click image for larger version. 

Name:	AccessForm PictureR1.JPG 
Views:	19 
Size:	21.4 KB 
ID:	7817

    I am new student for MS Access 2010.
    As above form, How to create code programming on Access2010? Please help to advise me.



    Describe:
    When I alreadr checked on Checkbox of chk1 to chk9 then i click on Cmdbotton, will show "Complete database" in txtbox. but have some not-checked on the one of checkbox(chk1 to chk9) after click on Cmdbotton then will show "Not complete database" on Txtbox.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,633
    Review http://office.microsoft.com/en-us/ac...010341717.aspx

    Try VBA code in button Click event procedure:
    Code:
    If Me.chk1 = False Or <do same for other 7 checkboxes> Or Me.chk9 = False Then
       Me.Txtbox = "Not complete database"
    Else
       Me.Txtbox = "Compete database"
    End If
    Or
    Code:
    booFinish = True
    For i = 1 To 9
        If Me.Controls("chk" & i) = False Then
            booFinish = False
        End If
        If booFinish = False Then
            Me.Txtbox = "Not complete database"
        Else
            Me.Txtbox = "Compete database"
        End If
    Next
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    dikdikdikdik is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    May 2012
    Posts
    2
    Hello June7, Thank you very much for your kindly help ^___^

Please reply to this thread with any new information or opinions.

Similar Threads

  1. code changes from access 2003 to access 2007
    By daversb in forum Programming
    Replies: 1
    Last Post: 11-30-2010, 05:32 PM
  2. Word code in Access - How to modify my current code
    By Alexandre Cote in forum Programming
    Replies: 0
    Last Post: 11-15-2010, 08:26 AM
  3. VB Code in Access 2007
    By collen in forum Programming
    Replies: 1
    Last Post: 10-12-2010, 06:27 AM
  4. Access 2003 code vs Access 2007 Code
    By ralphjramirez in forum Access
    Replies: 5
    Last Post: 11-23-2009, 12:33 PM
  5. VB code in Access '07 trouble
    By Pauldk in forum Reports
    Replies: 2
    Last Post: 02-18-2009, 03:59 PM

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