Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    atai is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2019
    Posts
    22

    How to hide the name of the form

    Hello,

    maybe it's a stupid question but I can't find a way to hide the name of the form when I open the form.
    I have an header where I have the title of the form but I see on the top left also the name of the form (from the form label)
    It's possible to hide this and keep only the text inside the header?
    Thanks

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    you can put any name in the form property: Caption
    this will 'hide' the name.

  3. #3
    atai is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2019
    Posts
    22
    I tried and this works for a form (I put a dot) but not in another one.
    I also checked one by one the difference between the 2 forms but I can't see any

  4. #4
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Use a space rather than a dot. Make sure you're not looking at a label that an Access wizard automatically added to your form. It shouldn't matter if your option is to open forms in tab view or overlapping windows, but it might help to know more about what you're looking at. Post a pic if this response doesn't help.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  5. #5
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    If you are using overlapping windows option instead of the default tabbed documents, you can set the form border style to none.
    That results in no form title bar.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  6. #6
    atai is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2019
    Posts
    22
    Quote Originally Posted by isladogs View Post
    If you are using overlapping windows option instead of the default tabbed documents, you can set the form border style to none.
    That results in no form title bar.
    I can't because I am using a subform inside this form

  7. #7
    atai is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2019
    Posts
    22
    Quote Originally Posted by Micron View Post
    Use a space rather than a dot. Make sure you're not looking at a label that an Access wizard automatically added to your form. It shouldn't matter if your option is to open forms in tab view or overlapping windows, but it might help to know more about what you're looking at. Post a pic if this response doesn't help.
    Yes, with the space it's works but I have a white row and this is not good for me because I have an header green
    Click image for larger version. 

Name:	form.jpg 
Views:	27 
Size:	123.6 KB 
ID:	40160

  8. #8
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    I suggested setting the border style to None

    Quote Originally Posted by atai View Post
    I can't because I am using a subform inside this form
    So what? You can still have a borderless form containing a subform. For example:

    Click image for larger version. 

Name:	BorderlessFormWithSubform.PNG 
Views:	26 
Size:	61.8 KB 
ID:	40161
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  9. #9
    atai is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2019
    Posts
    22
    yes, sorry it's true; I missunderstood.
    I tried but doesn't change anything

  10. #10
    atai is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2019
    Posts
    22
    OK, I solved removing the green color from the header so it looks like an integration of the header.
    another question:
    How I can remove the possibility to close the access database?
    You can see on the image that on the top of the screen there is the possibility to close the access database but I would prefer to close only from the button created (Chiudi).
    Click image for larger version. 

Name:	form.jpg 
Views:	24 
Size:	72.2 KB 
ID:	40162

  11. #11
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Quote Originally Posted by atai View Post
    yes, sorry it's true; I missunderstood.
    I tried but doesn't change anything
    Sorry. No idea what that means.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  12. #12
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Quote Originally Posted by atai View Post
    How I can remove the possibility to close the access database?
    You can see on the image that on the top of the screen there is the possibility to close the access database but I would prefer to close only from the button created (Chiudi).
    A simple way of doing this is to remove the application window so you have a 'free floating' form
    See this example application for more details http://www.mendipdatasystems.co.uk/c...ace/4594365418
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  13. #13
    atai is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2019
    Posts
    22
    Thanks, it works!
    Now I have another question
    I would like to save the data of my form when I close the form.
    I means if I press the "save" button there are some activities done and then I delete the tables but if I press the "Close" button I would like when I reopen to find what I have inserted before.
    This works for the rows but it doesn't works for the header information.
    I don't know why when I open the form only the rows information appear and I loose the header data.
    The subform works with a specific table named PO and the form use another table named PO_H.
    Why when I reopen the form the data inside PO_H do not appear?
    Thanks

    P.S.: I realize that if I run the form when I am in the database structure it works but when I run with the autoexec that hide everything and show only the form it doesn't works.

  14. #14
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Sorry but I don't understand your issue.
    Can you upload the relevant parts of your app so someone can look at it.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  15. #15
    atai is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2019
    Posts
    22
    Quote Originally Posted by isladogs View Post
    A simple way of doing this is to remove the application window so you have a 'free floating' form
    See this example application for more details http://www.mendipdatasystems.co.uk/c...ace/4594365418
    To create this type of view (a form access without the microsoft access background) I have used this code

    Global Const SW_HIDE = 0
    Global Const SW_SHOWNORMAL = 1
    Global Const SW_SHOWMINIMIZED = 2
    Global Const SW_SHOWMAXIMIZED = 3
    Private Declare PtrSafe Function apiShowWindow Lib "user32" Alias "ShowWindow" (ByVal hwnd As Long, ByVal nCmdShow As Long) As Long






    Function SixHatHideWindow(nCmdShow As Long)
    Dim loX As Long
    Dim loForm As Form
    On Error Resume Next
    Set loForm = Screen.ActiveForm


    If Err <> 0 Then
    loX = apiShowWindow(hWndAccessApp, nCmdShow)
    Err.Clear
    End If


    If nCmdShow = SW_SHOWMINIMIZED And loForm.Modal = True Then
    MsgBox "Cannot minimize Access with " _
    & (loForm.Caption + " ") _
    & "form on screen"
    ElseIf nCmdShow = SW_HIDE And loForm.PopUp <> True Then
    MsgBox "Cannot hide Access with " _
    & (loForm.Caption + " ") _
    & "form on screen"
    Else
    loX = apiShowWindow(hWndAccessApp, nCmdShow)
    End If
    SixHatHideWindow = (loX <> 0)
    End Function

    When I open my start form I run this function and everything works fine.
    But I realize now that if I swith to another application and then I go back on my Access form I loose this type view.
    Can somebody explain me why?
    Thanks

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

Similar Threads

  1. Hide Value in Form Interface
    By Haleakala17 in forum Access
    Replies: 1
    Last Post: 12-06-2012, 07:43 PM
  2. Hide Form Name Tab
    By ruthib4 in forum Programming
    Replies: 4
    Last Post: 06-26-2012, 12:13 PM
  3. Replies: 3
    Last Post: 05-02-2012, 10:13 AM
  4. Hide form
    By jgelpi16 in forum Programming
    Replies: 2
    Last Post: 06-29-2011, 08:06 AM
  5. Show/Hide Form
    By sparlaman in forum Forms
    Replies: 5
    Last Post: 05-16-2011, 11:48 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