Topics Search

Error message refers to a form that does not exist

Error message refers to a form that does not exist
Views: 136
I receive the following error message when I open a database: (see attachment).
The original table name was changed and a new form designed that functions fine. I can find no trace of the form mentioned in the error message. I thought I had deleted any old forms when I made the change. This table is linked to another database and the error form is not located there either.
The macro referred to does not show up anywhere that I can find.
After I acknowledge the error message the database works fine.
Sponsored Links:

More topics


Error2467 The Expression You Entered Refers to an object that is closed

I have an Access 2003 Data Project with SQL Server 2008 Back End. When the user selects a drop down list I am trying to assign the recordsource of a subform and I keep getting the following error:
Error 2467 "The Expression You Entered Refers to an object that is closed or Doesn't Exist"

Error: Record source specificed on this form does not exist.

I have been fighting with this error for a while now and I must come for help.
The exact error message is:

The record source '~sq_CTrainedEmployees subform~sq_cEmployeeInfoID' specified on this form or report does not exist.

The name of the recordsource may be misspelled, the recordsource was deleted or renamed, or the recordsource exists in a different database.

I am unsure of where it's pulling this ~sq_cTrainedEmployees subform~sq_cEmployeeInfoID string from. The recordsource for the form is not set as such yet this is the error that I get. EmployeeInfoID is also a valid field on the linked table.

This happens after adding a combobox to the form. I have quadruple verified that my row source query string is correct.

I figure I am overlooking something somewhere that's throwing up this message

searching for macro that doesn't exist

I am using a Microsoft dbase template called Issues. I have eliminated all the forms, reports and modified it for my use. When I open it I get the following error.

The form name 'IssueList' is misspelled or refers to a form that doesn't exist.
If the invalid name is in a macro, an Action failed dialog box will display the name and the macro's arguments after you click OK.

I have opened everything and searched within the properties for anything with the name IssueList or a macro referencing it. I can't find it. Am I missing another place to lo

Switchboard Removed but still there

I have removed the switchboard form, table and the command in AutoExec as well as the startup program. However I still get a.

"The form name "Switchboard" is misspelled or refers to a form that doesn't exist. If the invalid form name is in a Macro, an action failed dialog box will display the macro name and the macro's arguments after you click ok. Open the Macro window, and enter the correct name."

I have deleted the AutoExec and recreated it to open the MainMenu_frm that I am now working with.

Any help in getting rid of this error message is greatly appreciated.

Error 2103 with open report

I made come changes to a report that I call from a form and now I get this Error 2103 that tells me the report name I entered in either the property sheet or macro is misspelled or refers to a report that does not exist.

It is not a macro or the macro name would be displayed (or so I read) and the report exists and in fact works if I run it directly, outside of the form.

Import Excel Data Macro Error

I have designed a macro in Access 2007 that imports data from 4 excel files. Name of excel files are Form A, B, C and D. I recently installed Access 2010. Now when I click the import button, the macro pops up a message saying that "Form A" doesn't exist in the specified location - this is true. But Form B, C and D are there. I want the macro to import data from those files only that exist in a specified location.

In Access 2007, database would import existing data only. It didn't give me a message if Form A or any other form wouldn't exist in the specified location.

What can I do to make the macro behave similar to what it was doing in previous version

Error handler disregarded

I have got a bizare behaviour that I see exhibited by Access 2003. With error handling in effect, my code attempts to write a record to a table. If the INSERT INTO command of the SQL statement specifies a field that does not exist in the underlying table, execution is suppose to jump to my error handling section without triggering Acess' error message.

Therein, the errant field name is parsed from the error text and a popup form gives the user options on how to proceed.

It used to work when it was first implemented and eventually it stopped working. In practice, Access does trigger an error message despite the use of 'On Error Goto blah', and the error raised is 3127 (Reserved error), so even though execution passes to the error handlersection, the ability to get the field name from the error text is lost because the error text is not what it's suppose to be.

Create an error message from a search button

I am new to MS Access in terms of using the Macro functions. I am trying to create a search button which will return a set of forms related to a particular person which I have created a table for.

At present I have got this to work by linking a query (and its form) to the textboxes in search form and using the open form Macro on the button located on a search form. However, if I enter the details of a person who does not already exist in the person details table, the form still appears but without a related record.

What I would like is an error message to appear telling the user that they have entered their search details incorrectly instead of bring up a blank form

Dialog Box with the following:

I made changes to an existing form - formally known as Attendees.Changed the name to Clients and changed all of the coding that I could find to reflect this change however when loading the database I am getting the following message.

The form name 'Attendees" is misspelled or refers to a form that doesn't exist
If the invalid name is in a macro, an Action Failed dialog box will display the macro name and the macros arguments after you click ok. Open the macro window, and enter the correct form name.

How can I find where this is coming from. I have checked all macro files and there does not seem to be any "Attendees" stated anywhere

Create error msg box

How do I create a msg box whenever someone enter a project number that doesnt exist. Currently it just pull up the form or report with empty information.
I would prefer to have it just popup a message that says this project number doesnt exist. Try again.

I'm not sure how to create the macro or where to place it? Need