Error 3799 Field name not found

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DRMOB - 18 Jun 2007 17:04 GMT

I had put a field name (FUPDate) in Table 1 but decided that this field need
to be put in Table 2; so I deleted from T1 and put in T2. I never referenced
this field anyway but everytime I open T1 to make a design change and click
on Save I get an error msg "Could not find field name FUPDate" and when I
click OK I get another error msg "Errors were encountered while doing save
operation." (If I were to click on the help button instead of OK it reads
error 3799). If I put this field back into T1 and try to save, everything is
fine? This is a new database still in test mode so I deleted all info from
all tables (except those that are lookup tbls), but this did not work. Do
you have any suggestions?

Reply to this Message

Allen Browne - 18 Jun 2007 17:34 GMT

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I had put a field name (FUPDate) in Table 1 but decided that this field
>need
[quoted text clipped - 10 lines]
> all tables (except those that are lookup tbls), but this did not work. Do
> you have any suggestions?

Reply to this Message

DRMOB - 19 Jun 2007 15:18 GMT

That feature is turned off. Just to be clear, I actually deleted the field
from Tbl1 and added the same field name to Tbl2. I cannot make any changes to
Tbl1 and save without getting the error re field name not found? Any other
suggestions?

> If you have not yet turned off Name AutoCorrect, you might try that.
>
[quoted text clipped - 19 lines]
> > all tables (except those that are lookup tbls), but this did not work. Do
> > you have any suggestions?

Reply to this Message

DRMOB - 19 Jun 2007 15:40 GMT

I found the problem. For the field in Tbl1 I had put a validation rule, I
thought by deleting the field it would have deleted the rule but it did not.
I clicked on properties of the deleted field in Tbl1 and found the VR.
Problem Solved. Thanks for the help.

> That feature is turned off. Just to be clear, I actually deleted the field
> from Tbl1 and added the same field name to Tbl2. I cannot make any changes to
[quoted text clipped - 24 lines]
> > > all tables (except those that are lookup tbls), but this did not work. Do
> > > you have any suggestions?

Reply to this Message