Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Apr 2002
    Location
    Boise, Idaho, USA
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Microsoft Access Class Objects (Access 2002)

    I have a database that has worked perfectly for the last 4 years. This year I need to add some fields. I have modified the table to include the new fields. I am trying to create a new data entry form to capture the new data. My current form has all fields unbound and the user clicks a save button to invoke the code that saves the record.

    This still works fine on my original version - even if I am using the modified table with the new record fields -

    I have a copy of the database to change the data entry form. I have a form created to add the records. I am trying to add the records exactly like before - The only change is that I added the new fields.

    Now, however, when I open the database and make any attempt to test the data entry form or change any part of it I am getting messages that I don't understand. I get an error message that tells me that the form "logon" doesn't exist. (the name of the form I have for logging in is named "fLogon" the name of the form I'm trying to modify is "fDataEntry") I'll click okay and the same message is repeated a number of times, then I'm told I can't save it (which I wasn't trying to do anyway). If I look at the visual basic window I now have something called "f_logon" (not "logon" as in the error message) under the Microsoft Class Objects. The icon next to it is a different color and looks like a report icon (I think). All the other items on that list start with "form_" ... or "report_"... this one is just "f_logon".
    I've done a search and neither "f_logon" or "logon" exist any where in my database. I've deleted and recreated the form a number of times. I've deleted the database and re-copied the old database multiple times. I can do that and it works fine until I try to add this new form - then I get the same message... If I compact and repair it does not go away. If I compact and repair into a new database it does not go away. If I use explore and make a copy of the database it does not go away. The only way I can not have this item is when I use the original version to create a new database. This thing shows up as soon as I try to modify the database.
    <img src=/S/confused.gif border=0 alt=confused width=15 height=20>
    I'm not well versed in code enough to even explain what this item is - how it looks in my Visual Basic window - so I hope I've explained enough that someone can help me.

    Is there something I can do to find and eliminate whatever is causing this?

    I'd appreciate any help.

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

    Re: Microsoft Access Class Objects (Access 2002)

    1. Make a backup copy, just to be on the safe side.
    2. Create a new blank database.
    3. Import all database objects from the problem database, but if possible, avoid importing f_Logon.
    4. With the new database open, activate the Visual Basic Editor.
    5. If necessary, set references to non-standard object libraries used in your database.
    6. Select Debug | Compile <project name>.
    7. Switch back to Access and do a Compile and Repair.

    Does f_Logon appear in the new database? If so, can you open the module in the VB Editor, and what are its contents?

  3. #3
    Star Lounger
    Join Date
    Apr 2002
    Location
    Boise, Idaho, USA
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Microsoft Access Class Objects (Access 2002)

    Hans
    I've done what you said - I couldn't import f_logon because there is no such animal.
    I'm not sure how to set references to non-standard object libraries used in your database. (I'm not that familiar with libraries)

    I've also tried to open this item in visual basic - it gives me an error message saying the module name 'Logon' is misspelled or refers to a module that doesn't exist.....

    If I import everything then I still have that f_logon icon....

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

    Re: Microsoft Access Class Objects (Access 2002)

    If you make a copy of the database, and remove all database objects (tables, queries, forms, reports, macros, modules) except for f_logon, does f_logon disappear, or does it remain?

    If it's still present in an otherwise empty database, could you compact the database, then zip it and attach it to a reply?

  5. #5
    Star Lounger
    Join Date
    Apr 2002
    Location
    Boise, Idaho, USA
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Microsoft Access Class Objects (Access 2002)

    Hans
    I should have written last week!!!
    Just like everything else, it is now working fine and I can't get it to duplicate the error.

    I guess I just needed some attention...
    <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35>

    If it happens again I'll re-activate this thread....

Posting Permissions

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