Blank form in Access

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • oli insight
    New Member
    • Apr 2007
    • 9

    Blank form in Access

    --------------------------------------------------------------------------------

    Hi Guys,

    I've recently had a little go at access... I've learned a lot over the past few weeks but now i have a problem:
    When I create a form it only dispays the data that is already imported without allowing me to change or modify any of the info should there be some changes like a new address for example...
    I also don't know how to get a blank form up so that i can input new data into the database to create a new record...

    If anyone knows why i'm getting these problems, please help as i cannot do anything else until this is solved..... many thanks
  • MMcCarthy
    Recognized Expert MVP
    • Aug 2006
    • 14387

    #2
    Originally posted by oli insight
    Hi Guys,

    I've recently had a little go at access... I've learned a lot over the past few weeks but now i have a problem:
    When I create a form it only dispays the data that is already imported without allowing me to change or modify any of the info should there be some changes like a new address for example...
    I also don't know how to get a blank form up so that i can input new data into the database to create a new record...

    If anyone knows why i'm getting these problems, please help as i cannot do anything else until this is solved..... many thanks
    Have you built this form on a query. If so it is possible the query is not updateable and will have to be changed.

    Mary

    Comment

    • missinglinq
      Recognized Expert Specialist
      • Nov 2006
      • 3533

      #3
      In the form's Property Box on the Data tab:

      Allow Additions = Yes
      Allow Edits = Yes
      and if you want to be able to delete records
      Allow Deletions = Yes

      Comment

      • oli insight
        New Member
        • Apr 2007
        • 9

        #4
        Originally posted by missinglinq
        In the form's Property Box on the Data tab:

        Allow Additions = Yes
        Allow Edits = Yes
        and if you want to be able to delete records
        Allow Deletions = Yes
        Hi matey,


        Thanks for getting back me :)

        Yeah i know, this is really strange cause I've been playing with those property options AND the switchboard setup with "open form in edit mode" or "addin mode" and it just does not work.
        I've managed to get it working once which now means that i'm stuck with the session i'm in... Every time i try and start a new database, i can't get that same setup again... I've tried printing form properties from one database and then copying them line by line into new projects and it just doesn't work...

        Comment

        Working...