Results 1 to 4 of 4
  1. #1
    Onsmak is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2014
    Posts
    2

    How to unshow emty(new) record in form


    How to unshow empty(new) record in form access 2010?

    Let's say I have table of employees and form where is in table arrangement list of these employees. I have independent field (list of choices of towns) in heading for filtering records. How to manipulate with this form to open it by button, show records and have access to field in head for fill it and filtring employees by choice in this field? When I open this form by button where macro Open_Form has property mode "edits" then I have access to field in head but in list of records there are at last the empty(new) record… I need unshow this last record.

    thank you for any help
    Onsmak
    Last edited by June7; 12-14-2014 at 04:52 PM. Reason: typos

  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,622
    If you don't want the new record row available then set the form AllowAdditions property to No. This can be done statically in the form setup or programmatically when the form opens.
    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
    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
    If the Form is being opened from another Form, as is being done here, it has to be done programmatically:

    Code:
    Private Sub Form_Load()
     Me.AllowAdditions = False
    End Sub

    When opening a Form in the Edit Mode, Access will ignore how the AllowAdditions Property is set, if this is done in the Properties Pane.

    Linq ;0)>

  4. #4
    Onsmak is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2014
    Posts
    2
    Wow, thank you so much for help and quickly replies! So I found solution with you. Yes, when I have Edit mode for opening this form then all properities like additions and others was ignored, I tried it before. Yea, Solution is simply just omit Data mode argument to open form and in properities of form set up AllowEdits — Yes. Now I can use field in top and others I locked. Thank you.

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

Similar Threads

  1. Replies: 3
    Last Post: 03-09-2013, 10:39 AM
  2. Replies: 3
    Last Post: 02-06-2013, 07:23 PM
  3. Replies: 3
    Last Post: 08-26-2012, 10:04 PM
  4. Replies: 2
    Last Post: 07-30-2012, 09:18 AM
  5. Show/Unshow Columns in Query
    By simmurray in forum Queries
    Replies: 0
    Last Post: 03-28-2009, 10:03 AM

Tags for this Thread

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