Software

Ask something
Discussion Locked

Enter parameter value

0 helpful
6 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.

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.

What causes this problem? Is it BIOS settings or Access 2000 settings?

Thanks in advance.

6 replies

by nise_k

Hi,

This problem is due to some mismatch between the Database field names and the names in ur Query. You have to chk the query properly.

As far as the Query executing correctly in other PCs, the reason could be that
1. the query in those PCs would be different (i.e they may be correct ones).

or

2. The table structure in those PCs is correct and in this PC, smth is missing.

Creat a new query using Query Designer if u r not able to find out the error urself. Then modify the SQL that appears.

Nise

by dklippert

Make sure that all the machines have the latest service releases. Also look at the Date field in the Query and make sure that its formatting matches any other dates that are being computed.

by timfox

It sounds like a PC error, but...
What is the actual difference between the PCs? Do the PCs that work OK get the parameter value query? What happens to the report when you enter a value here? What date are you expecting in the date field - today's date, date entered? What impact does the value entered have on the resulting recordset?

With no other info - Answer 2 and 3 should lead to finding your answer.

The reason why #Name? appears in a form or report is the datasource for the field isincorrect. Use your MS Access help pages.

This discussion is closed to new replies.