Page 1 of 2 12 LastLast
Results 1 to 15 of 17
  1. #1
    chiaro59 is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2014
    Posts
    14

    Section (0)=visible

    Ciao a tutti, Questa e la mia prima:.:: Domanda
    Ho Una maschera di Che SI APRE con la PROPRIETÀ Corpo invisibile.
    Nella SEZIONE intestazione Ho Un Pulsante Che cliccato DEVE eseguire il codice seguente:
    SEZIONE (0) = visibile
    docmd.gotocontrol " T1 "
    Una Volta cliccato il Pulsante Il Corpo Diventa visibile, ma il Cursore non lo Trovo Nella Casella desiderata.
    Devo cliccare su Un Punto della maschera per farlo APPARIRE.
    Aiutatemi a risolvere QUESTO Problema.
    grazie a tutti.



    Mod edit for Google translation:
    Hello everyone, This is my first:. :: Application
    A mask What I OPENS with the PROPERTY body invisible.
    SECTION A button in the header I clicked What MUST execute the following code:
    SECTION (0) = visible
    docmd.gotocontrol "T1"
    Una Volta clicked the button Corps becomes visible, but the cursor did not I find the box you want.
    I have to click a point on the form to make it APPEAR.
    Help me solve this problem.
    thank you all.
    Last edited by June7; 10-15-2014 at 10:41 AM.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    English, please.

    Don't quite understand what you are trying set visible. Why is not already visible?

    Instead of GotoControl, try:

    Me.T1.SetFocus
    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
    chiaro59 is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2014
    Posts
    14
    Ok, i vrite my question in english.
    I have a form with the property detail section not visible.
    In the header section there is a control button that on click it run code:
    section (0).visible=true
    docmd.gotocontrol "T1"
    When i click the control button in header section the detail section becomes visible and becomes visible the text box "T1" too but the cursor is not here.
    Only after i click in anywhere of form the cursor becomes visible.
    I texted Me!T1.Setfocus but I get the same result !
    Help me. Thank, June.
    Last edited by chiaro59; 10-16-2014 at 04:25 AM.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    What is 'intestation' section?

    If you want to provide db for analysis, follow instructions at bottom of my post.
    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.

  5. #5
    chiaro59 is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2014
    Posts
    14
    I corrected my post.

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    I have one form where I do the same thing. Don't have the issue you describe. Here is my code:

    Private Sub btnAddProject_Click()
    Me.Detail.Visible = True
    Me.cbxName.SetFocus
    Me.cbxName.Dropdown
    End Sub
    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.

  7. #7
    chiaro59 is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2014
    Posts
    14
    Dear June, unfortunately that code does not work on my computer !
    It will be the fault of access 2007 ?
    Help me find a solution.
    Thank you

  8. #8
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    The code was originally written in Access 2007.

    Why does it not work for you? What happens - error message, wrong results, nothing? Post your code or provide db.
    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.

  9. #9
    chiaro59 is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2014
    Posts
    14
    Dear June,
    The same code works in access 2003 !!!
    I created a simple db with one form that play the problem.
    The code is:

    Option Compare Database

    Private Sub Cmd1_Click ()
    Sezione (0) .Visible = True
    DoCmd.GoToControl "T1"
    End Sub

    Private Sub Form_Open (Cancel As Integer)
    Sezione (0) .Visible = False
    DoCmd.GoToControl "CmdEsci"
    End Sub

    How i can provide db db?
    Bye

  10. #10
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    So what language version of Access are you using? In your posted code

    Code:
    Private Sub Cmd1_Click ()
      Sezione (0) .Visible = True 
      DoCmd.GoToControl "T1"
    End Sub

    everything appears to be in English except

    Sezione (0) .Visible = True

    Perhaps if you changed it to

    Section (0) .Visible = True

    it would work.

    Linq ;0)>

  11. #11
    chiaro59 is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2014
    Posts
    14
    I'am sorry,
    I posted wrong my code to blame the automatic translator.
    I write my code again:

    Option Compare Database

    Private Sub Cmd1_Click ()
    Section (0) .Visible = True
    DoCmd.GoToControl "T1"
    End Sub

    Private Sub Form_Open (Cancel As Integer)
    Section (0) .Visible = False
    DoCmd.GoToControl "CmdEsci"
    End Sub

    The problem remains !!!

  12. #12
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    To provide db, instructions are at bottom of my post.

    Click "Go Advanced" button below the Quick Reply editor.
    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.

  13. #13
    chiaro59 is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2014
    Posts
    14
    Dear June,
    I provide my simple db.
    I hope to have done it right.
    I am waiting for your response.
    Bye
    Attached Files Attached Files

  14. #14
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    The visible code works but cannot set focus to the textbox.

    I tried rebuilding form and also building a new db and form. I tried binding form and textbox to table data. Still not working

    I looked at my working db and this definitely works. As to why I cannot replicate success, I am stumped. Sorry.
    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.

  15. #15
    chiaro59 is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2014
    Posts
    14
    Dear June,
    Yes, the visible code works but cannot set focus to the textbox.
    I think that is a problem of access 2007.
    How to find a alternative solution ?
    You could force a click on section detail ?
    Please, continue to hepl me.

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

Similar Threads

  1. Replies: 30
    Last Post: 07-21-2014, 02:46 PM
  2. Visible/Not Visible based on condition VBA
    By BLFOSTER in forum Programming
    Replies: 3
    Last Post: 07-15-2014, 01:29 PM
  3. Replies: 2
    Last Post: 01-09-2014, 07:24 PM
  4. Replies: 6
    Last Post: 03-26-2013, 12:17 PM
  5. Replies: 2
    Last Post: 01-06-2011, 04:38 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