General discussion

Locked

Enter parameter value

By stergios_nik ·
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.

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Enter parameter value

by nikki96 In reply to Enter parameter value

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.

Collapse -

Enter parameter value

by stergios_nik In reply to Enter parameter value

Poster rated this answer

Collapse -

Enter parameter value

by highlander718 In reply to Enter parameter value

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.

Collapse -

Enter parameter value

by stergios_nik In reply to Enter parameter value

Poster rated this answer

Collapse -

Enter parameter value

by LeoBloom In reply to Enter parameter value

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.

Collapse -

Enter parameter value

by stergios_nik In reply to Enter parameter value

Poster rated this answer

Collapse -

Enter parameter value

by stergios_nik In reply to Enter parameter value

This question was closed by the author

Back to Software Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums