Tempvars!switchboard - 'What the duece is this error?

[kcmiuser]

I have a nice little access program I use for my safety programs to track certain types of information. It is very straight forward, not real fancy, but I need another person in another department to audit the actual data via the data entry form, basically, they read it, edit and then mark a check box on the bottom with their initials and date. Everything thing was working fine until I rolled it out to the other person. I created the project in access 2010 and then save a copy compatible with access 2000 which is what this person has on there machine. When they open it they get the following error:


I have no parameter in this application, totally confused, please advise.

[JoeM]

When Access a field reference in a query that it doesn't recognize (meaning that it does not think it is part of the table/query that the query is based on), it throws it out as Parameter. It happens quite commonly if you have a field name misspelled, or you delete a field from a table which is being used by some calculations in a query.

So what this is telling you is that whatever object that is being opened that returns this Parameter box, it sees a reference to a field called "SwitchboardID" coming your "TempVars" source, only it does not recognize any field by that name in that data source.
So do you have a table or query named "TempVars"?
Open it up. Can you find any "SwitchboardID" field in it?

[kcmiuser]

I found that field and removed it, but I have another issue, unrelated. My access install is corrupted, I'll try it after I reinstall. Thanks.

[JoeM]

My access install is corrupted, I'll try it after I reinstall. Thanks

.
Try Compacting and Repairing the database.

If that does not work, you can create a brand new blank database, and import all your objects from your old one to a new one.

[kcmiuser]

Cool idea, thanks much

[Ruegen]

My guess is somewhere in the database there is a command to make a tempvar and that is used when you open that form. Find out where it makes the tempvar because it it isn't made there is no tempvar to be put into the query.

Basically there should be a form that makes the tempvar and then when you get to that form it uses it to make the form work.

The tempVar probably stores the user ID or customer ID (or in your case the Switchboard ID) and then when you get to that form uses it to do the query. Try looking for the switchboard form.