Field Conflict?

[Guest]

I have a time entry form that I have a Time_In field. at one point I added a
Time field in the table in order to capture the time, big mistake. I deleted
the Time field in the table however, know when I am entering code in the Form,
Me.Time_Out = Time()
I get an error message because it is trying to find the field named Time,
which I have deleted. The field Time shows up in the drop down when I type
in Me.

I am assuming this is the problem. This code worked fine before I created
teh field named Time. Is there any way to delet the field from the code?

 

[Joseph Meehan]

I have a time entry form that I have a Time_In field. at one point I
added a Time field in the table in order to capture the time, big
mistake. I deleted the Time field in the table however, know when I
am entering code in the Form, Me.Time_Out = Time()
I get an error message because it is trying to find the field named
Time, which I have deleted. The field Time shows up in the drop down
when I type in Me.

I am assuming this is the problem. This code worked fine before I
created teh field named Time. Is there any way to delet the field
from the code?

Somehow I suspect you have tried this, but have you tried a compact and
repair?

You could start importing data and copying forms from the existing
database to a new one.

Maybe someone else will have some better ideas.

 

[Joseph Meehan]

I have a time entry form that I have a Time_In field. at one point I
added a Time field in the table in order to capture the time, big
mistake. I deleted the Time field in the table however, know when I
am entering code in the Form, Me.Time_Out = Time()
I get an error message because it is trying to find the field named
Time, which I have deleted. The field Time shows up in the drop down
when I type in Me.

I am assuming this is the problem. This code worked fine before I
created teh field named Time. Is there any way to delet the field
from the code?

I should add, that it may be helpful if you tell us what version of
Access you are using.

Also I seem to remember a very similar question that was asked in the
last few days. Maybe something there that might help.