Results 1 to 15 of 15
  1. #1
    4 Star Lounger
    Join Date
    Aug 2005
    Location
    London/Kingston, Surrey, United Kingdom
    Posts
    518
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi all,

    I have created a new form in access, and added a few controls such as labels and textboxes etc, when I go to Form view those items are not visible. I checked the properties of the form and the visible option is Always on.

    Please help

    Many thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Does the form have a record source?

    If so, how have the Allow Additions and Data Entry properties of the form been set?

  3. #3
    4 Star Lounger
    Join Date
    Aug 2005
    Location
    London/Kingston, Surrey, United Kingdom
    Posts
    518
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='787464' date='04-Aug-2009 12:17']Does the form have a record source?

    If so, how have the Allow Additions and Data Entry properties of the form been set?[/quote]

    Data Entry was set to No so I set it to Yes and it worked,

    MAny thanks

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Keep in mind that setting Data Entry to Yes means that you can only add new records; you won't be able to view or edit existing records.

  5. #5
    4 Star Lounger
    Join Date
    Aug 2005
    Location
    London/Kingston, Surrey, United Kingdom
    Posts
    518
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='787467' date='04-Aug-2009 12:25']Keep in mind that setting Data Entry to Yes means that you can only add new records; you won't be able to view or edit existing records.[/quote]
    Hans I just created another form and I get the same problem. I don't know what is going on.
    Thanks

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Could you post a small zipped database that demonstrates the problem?

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    [quote name='skender' post='787477' date='04-Aug-2009 14:22']Here you go Hans,[/quote]
    Where do I go???

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    The Recordset Type property of both forms had been set to Snapshot - this means that records cannot be added or edited. You should set this property to Dynaset.

    If you want the user to be able to view/edit existing records, set the Data Entry property to No.
    If you want the user to enter new records only, set the Data Entry property to Yes.

  9. #9
    4 Star Lounger
    Join Date
    Aug 2005
    Location
    London/Kingston, Surrey, United Kingdom
    Posts
    518
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='787483' date='04-Aug-2009 13:34']The Recordset Type property of both forms had been set to Snapshot - this means that records cannot be added or edited. You should set this property to Dynaset.

    If you want the user to be able to view/edit existing records, set the Data Entry property to No.
    If you want the user to enter new records only, set the Data Entry property to Yes.[/quote]

    Hi Hans Thanks for sort it out the problem. One more thing , I want the user to be able to add editand delete records what settings do I need to set.

    Thanks again

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    To allow editing existing records: set Allow Edits to Yes.
    To allow adding new records: set Allow Additions to Yes.
    To allow deleting existing records: set Allow Deletions to Yes.

  11. #11
    4 Star Lounger
    Join Date
    Aug 2005
    Location
    London/Kingston, Surrey, United Kingdom
    Posts
    518
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='787487' date='04-Aug-2009 13:50']To allow editing existing records: set Allow Edits to Yes.
    To allow adding new records: set Allow Additions to Yes.
    To allow deleting existing records: set Allow Deletions to Yes.[/quote]

    Thanks Hans

  12. #12
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    What happened to the attachment?

  13. #13
    4 Star Lounger
    Join Date
    Aug 2005
    Location
    London/Kingston, Surrey, United Kingdom
    Posts
    518
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='787489' date='04-Aug-2009 13:56']What happened to the attachment?[/quote]

    Hi Hans I am sorry but I had to delete the attachment as I do not want others to see how my database looks like and what it contains etc etc. I hope you understand.

    Many Thanks

  14. #14
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You should never post a file with sensitive data - you can enter some dummy data to serve as an example.

    It is not fair to ask for help and not want others to see what you're working on; it violates the spirit of the Lounge, where people learn from each other.

  15. #15
    4 Star Lounger
    Join Date
    Aug 2005
    Location
    London/Kingston, Surrey, United Kingdom
    Posts
    518
    Thanks
    0
    Thanked 0 Times in 0 Posts
    For next time I know, I will use screen shots or dummy data like you said. Apologies to everyone.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •