Access 2019 Information Message: Miceosoft Access cannot find the object ***

Hi Everyone,

Just wanted to say I got it working, not quite like before the error, but it's working error free, so far. I took a little advice from all of you and I appreciate that advice and help very much. I still don't know what the problem is, still working on that, but I do know it's a problem with the continuous subform. I split all my forms into individual forms and opened and closed each one of them. I got the error message on the continuous form, which is the song information form. I created a new form, copied all the controls to the new form, and I could open it error free. I'm adding code a little bit at a time and testing to see what actually caused the problem in the first place. I tend to think it's what GroverParkGeorge said, a space hidden in a control, and I'm determined to find it. But, it is working without the missing object error so far. Thanks again, everyone, for giving me ideas on how to find the problem and a starting point as well, Very Much Appreciated!

Gordon

Abdal and Scottgem,

Thank you for your advice and help with my problem. So far I'm going through some of the steps that Abdal suggested and I've already checked every spelling and searched through the project with all the control names to see if I could flag one spelled wrong, but so far no good. Scottgem you're right, the information message doesn't tell me the name of the object, that's one of the reasons I reached out for help. I found a few references to my problem online, but in each case they were given the name of the object. I even tried creating a complete new Db and imported data from the problem db, but looks like all I managed to do was import the problem as well. I might be forced to start over again, but I'll keep trying to figure it out and let everyone know what, if anything I come up with. Thanks again to you both. It is much appreciated (And I'm still learning too!)

Gordon

As Scott suggested, it's apparently in code that runs when the form opens. Set a break point in the code and step through it line by line until you reach the line which errors out.

It also sounds like there is little or no error handling. Perhaps that's an enhancement worth investing some time in.

The error message doesn't give the name of the object?

If not, then what you need to do is look at the code that runs when you open the form to see what object is causing the crash. It could be as simple as a misspelling.

Hello

I am Abdal and I would be glad to help you with your question.

The error message you're encountering in Microsoft Access typically occurs when Access is unable to locate an object referenced in your database. It seems that in your case, the object name is not specified in the error message, which makes it challenging to pinpoint the exact cause of the problem. However, based on the information you provided, it appears that the issue might be related to one of the subforms or controls within your main form.

Here are a few steps you can take to troubleshoot and resolve the issue:

1. Verify that all the subform controls on your main form are correctly referencing the subform objects.
2. Examine any controls within your subforms that may be referencing objects, such as buttons or macros. Make sure these references are valid and properly specified.
3. If you have any VBA code associated with your form, carefully review it for any potential errors. Look for any references to objects that might be causing the issue. Pay close attention to the "On Current" event of your continuous subform, as you mentioned the error appears after that event. Make sure the code within that event is functioning correctly and not causing any issues.
4. Perform a compact and repair operation on your Access database to fix any potential database corruption issues. Sometimes, this can help resolve errors that seem to have no apparent cause.
5. Create a copy of your database and remove all the CD and song data from the tables. Test the modified database to see if the error still occurs. If the error goes away, gradually add the data back in to identify any specific records or entries causing the problem.
6. If none of the above steps resolve the issue, you might consider rebuilding your main form from scratch. Create a new form and copy over the controls, subforms, and their associated properties one by one. This can help eliminate any potential hidden issues within the form design.

By following these troubleshooting steps, you should be able to identify and resolve the "Microsoft Access cannot find the object" error you are experiencing.

I hope this information helps.

Regards,

Abdal

Give back to the community. Help the next person with this problem by indicating whether this answer solved your problem. Click Yes or No at the bottom.