Share via

Cannot save data in MS Assess form

Anonymous
2019-02-27T20:59:30+00:00

I designed and built a database in Access. However, one of the problems is that users cannot see the data that they have already entered and saved in the database. I can see those records in the backed database, but users cannot save the records on the form ( the fronted database). In the form property sheet, I put "No" for Data Entry, and changed "Yes" to "No" for Has Module, but it did not help. 

I am surprised this is happening because we did not have this problem a month ago and users could enter the data, save them, and when opened the form again they could see their data on the form but not anymore. What do you think cause the problem? I would appreciate if someone could help.

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

12 answers

Sort by: Most helpful
  1. Anonymous
    2019-02-28T19:36:43+00:00

    I changed it from Yes to No because there was no code associated with this form.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2019-02-28T19:35:20+00:00

    Hi Daniel,

    They could see the records in the form view, but now they only see 8 records on Grant form while there are 12 records in the Grant table. Here is  a picture of the Grant property form. 

     I tried to remove [Grantee-ID]=1 filter but it did not help either.

    Was this answer helpful?

    0 comments No comments
  3. Tom van Stiphout 40,211 Reputation points MVP Volunteer Moderator
    2019-02-28T03:04:02+00:00

    > users cannot save the records on the form

    What happens when they try? Any error messages? Please quote any error messages VERBATIM.

    How do you know if a record was attempted to be saved? I.o.w., what action does the user perform to save the record?

    How do you then check if it worked or not?

    Was this answer helpful?

    0 comments No comments
  4. Tom van Stiphout 40,211 Reputation points MVP Volunteer Moderator
    2019-02-28T03:01:24+00:00

    > changed "Yes" to "No" for Has Module

    Why? Did you look up in the Help file what this property does? Probably not, or you would have left it alone.

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2019-02-27T22:54:34+00:00

    Data entry simply set the user on a blank form to enter a new record.

    How did they previously review past entries?

    Have you checked the forms record source, check if any filters were applied somehow?

    Do you have a record lookup so they can easily retrieve a record?

    Was this answer helpful?

    0 comments No comments