Software

Ask something
Discussion Locked

Enter parameter value

0 helpful
7 replies

by stergios_nik

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello,

I have a problem with my queries in a Access 2000 database.

The problem was found on some pcs with Win 95 and Win98 installations.

The database is stored in a File Server and 6 users are accessing the database from Win95/98 clientPCs.

During query running process a message box appears with the message:

"Enter parameter value (Format)" and If I click ok without input I get the next dialog box:

"Enter parameter value (Date)" and if I click on without input then the query loads BUT IT DOES NOT DISPLAY the date in my REPORT.

It displays : #Name?

This problem happens to some PCs while in others works fine without problems.

What causes this problem? Is it BIOS settings or Access 2000 settings in the local PC.

What causes the query to be interpretted correctly in one PC while in another causes this problem.

The PCs are configured with FULL OFFICE 2000 installation except Outlook 2000.

Thanks in advance.

7 replies

by nikki96

It is their environment most likely. From a help document...

When Access encounters a variable (i. e., something that is not a literal string) during execution, it attempts to bind the variable to some value. To do
this, it performs the following tests:
1. First, Access checks whether the variable is the name of a field or a calculated field in the query. If it is, the variable is bound to the current value of the field. For example, if the parameter is named [DeptCode] , Access replaces it with the current value of the DeptCode field. Since X is not the name of a field or a calculated field in this particular query, this test fails.
2. Second, Access attempts to resolve the parameter as a reference to something within the current environment (e. g., the value on an open form). Since there is nothing called X in the current environment, this test fails.
3. As a last resort, Access asks the user for the
value of the parameter via the ?Enter Parameter
Value? dialog box.

by highlander718

Is the application based on one single .mdb that resides on the server ? Are there any external (linked) data sources (excel sheets, databases, text files) in that .mdb ? If the answer is NO I would classify this as just another "X-file". If YES, you have to check if those PC's have also access (mapped drives,access rights) to the external resources.

by leobloom

Anytime there is a problem with dates in different PC's using the same Access DB I check that the date formats in the PC's Control Panal\Regional Settings are the same as the settings of PC that is working.

This discussion is closed to new replies.