Removing a Member from Object Browser (Access 2002)

**RichA** · 2003-01-08 19:09

When I created the initial tables for my database, I (not thinking) named one of the fields DATE. While working in the form, I decided I wanted the current date to populate in one of the fields. After some head scratching, I realized that when I use the Date command in VBA, it was calling the DATE field I had in the table. I went and changed the field's name to COR_DATE, and did a find/replace to change any other locations it was listed.
Now when I type Date, it still reverts to DATE, and the code fails saying member not found. I see that DATE is still a member of the form in the object browser, is there a way to delete it as a member, or refresh the members list?

I'd appreciate any thoughts... am I missing something obvious?

Thanks,
Rich

**charlotte** · 2003-01-09 03:35

What is the name of the TextBox or other control that COR_DATE field is bound to on the form? I suspect you may have dragged the original DATE field onto the form and accepted the default name for the control. Changing the name of the underlying field won't change the name of the control--you have to do that yourself from the properties sheet for that control.

**HansV** · 2003-01-09 09:57

It can be difficult to find all occurrences of a name. Utilities like SpeedFerret or Rick Fisher's Find and Replace can help - they also search properties of database objects, controls etc.

**RichA** · 2003-01-09 11:26

The name of the TextBox is txtDate... you're right, I did drag it from the Field List to the form, but I always try and rename all the controls with a standard naming like txtDate, etc. There aren't that many controls on the form, and I've looked through all of them, not seeing anything having DATE anywhere listed. I'll go search again, but will the member disapear when the last reference to DATE has been removed, or is it something that will linger?

Thanks!
Rich

**MarkLiquorman** · 2003-01-09 12:30

One thing you might try (if you aren't already do it) is to use Date( ) instead of just Date. This should make it clear exactly to Access exactly what you are doing.

I have also noticed that references to items seem to linger in Access even after they have been deleted. I don't know how to delete them, however.

**RichA** · 2003-01-09 12:53

Yeah, I tried Date(), but it still changes it to DATE. Thanks for the thought though. I'm trying the find and replace tool that was recommended by Hans, we'll see if it comes up with anything. I'll let you know.

Rich

**RichA** · 2003-01-13 19:33

I tried using the Find/Replace tool, but it didn't come up with anything. If anyone has any additional thoughts... they would be greatly appreciated.

Thanks!
Rich

**patt** · 2003-01-13 19:55

What is the name of the date field in the table?
When you say you change the name of a field on the form to Date(), do you mean the default value or the ControlSource?
If you continue having trouble why don't you post a cutdown database converted to A2000 here (with only a couple of records in the table).
Pat <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

**HansV** · 2003-01-14 08:49

Access can be very tenacious in the capitalization of names - somehow, it seems to store the names as originally assigned, and fall back to this. This is mostly an annoyance, it's doesn't impact performance.

In some (but unfortunately not all) cases, I have been able to get rid of the "wrong" capitalization by using Rick Fisher's Find and Replace to do a "Replace without asking" on all database objects. In your case, you would replace DATE by Date.

Thread: Removing a Member from Object Browser (Access 2002)

Thread Tools