Not There, but it is!

[DS]

When I compile my database I keep getting a message saying that a field is
either mis named or not there. It'sthere I see it and I even deleted it and
renamed it! Still the same result.
Any help appreciated.
Thanks
DS

 

[tina]

if you're using A2000 or newer, did you turn OFF the Name Autocorrect option
in your database? if not, suggest you create a new blank database, then
immediately turn off Name Autocorrect from the menu bar under Tools |
Options | General tab. compact the db, import all the objects from your
"real" database, compile the code, and compact again.

if that doesn't solve it, post back and maybe one of us can help you figure
out what the problem is.

hth

 

[DS]

NameAutocorrecr is off so.....This happens occasionaly and knowI can't
remember how to correct it.! So any help is appreciated.
Thanks
DS

 

[Dirk Goldgar]

When I compile my database I keep getting a message saying that a
field is either mis named or not there. It'sthere I see it and I
even deleted it and renamed it! Still the same result.
Any help appreciated.

This happens when you compile the database? So then, is there a
particular line of code that is highlighted? If so, what is the line of
code? Is it talking about a field in a table, or a control on a form or
report?

 

[DS]

Me.TxtPrep = " "

Should I just move the Database to another container?
Thanks
DS

 

[Dirk Goldgar]

Me.TxtPrep = " "

Should I just move the Database to another container?

I take it that you see a control named "TxtPrep" on your form. Check
the Name property of that control (on the Other tab of its property
sheet), and make sure that it really is named exactly that. If it is,
make sure that the line of code you quoted is in the class module of
that form, and not in a subform on that form nor in a parent form of
which the control is on a subform.

If all that checks out, try changing the reference from "Me.TxtPrep" to
"Me!TxtPrep" and see if it works then.

 

[DS]

Thanks Dirk
Me!TxtPrep worked! Why I don't know but it works.
Thanks
DS