spectrolab
Registered User.
- Local time
- Tomorrow, 04:27
- Joined
- Feb 9, 2005
- Messages
- 119
Hi,
I am hoping this is a pretty easy one. Recently I have been reformatting a Db created in Access2003 in 2007 and I have found a problem with a form. All my forms are based on queries and most of them seem to work fine. However, one form will not allow me to enter data and comes up with the error "Recordet is not Updateable" all i did was change the layout, nothing underlying is changed. I can put data directly into the underlying table, but not into the query or the form. Even re-doing both the query and the form in 2003 didn't help, however, opening an old version of the db all still works fine (in 2003, not game to try it in 2007 yet).
Any ideas?
Forgot to mention, in the Vb, reference to acEdit had to be removed as it returned an error i.e.
DoCmd.OpenForm "formname" acViewNormal, acEdit
Edit:
Just looking through in a bit more detail, in the syntax above acEdit refers to a filter, not DataEntryMode as expected, why does it work in 03 and not in 07? Where might I find what acEdit refers to?
acEdit returns an error.
Could it be a reference issue?
I am hoping this is a pretty easy one. Recently I have been reformatting a Db created in Access2003 in 2007 and I have found a problem with a form. All my forms are based on queries and most of them seem to work fine. However, one form will not allow me to enter data and comes up with the error "Recordet is not Updateable" all i did was change the layout, nothing underlying is changed. I can put data directly into the underlying table, but not into the query or the form. Even re-doing both the query and the form in 2003 didn't help, however, opening an old version of the db all still works fine (in 2003, not game to try it in 2007 yet).
Any ideas?
Forgot to mention, in the Vb, reference to acEdit had to be removed as it returned an error i.e.
DoCmd.OpenForm "formname" acViewNormal, acEdit
Edit:
Just looking through in a bit more detail, in the syntax above acEdit refers to a filter, not DataEntryMode as expected, why does it work in 03 and not in 07? Where might I find what acEdit refers to?
acEdit returns an error.
Could it be a reference issue?
Last edited:
