Results 1 to 9 of 9
  1. #1
    Lounger
    Join Date
    Nov 2001
    Location
    Newark, New Jersey, USA
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Removing a Member from Object Browser (Access 2002)

    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

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

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

    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.
    Charlotte

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

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

    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.

  4. #4
    Lounger
    Join Date
    Nov 2001
    Location
    Newark, New Jersey, USA
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    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

  5. #5
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

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

    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.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  6. #6
    Lounger
    Join Date
    Nov 2001
    Location
    Newark, New Jersey, USA
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    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

  7. #7
    Lounger
    Join Date
    Nov 2001
    Location
    Newark, New Jersey, USA
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    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

  8. #8
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

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

    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>

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

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

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •