Enter Parameter Value

[dott]

I have a simple form which opens a report based on a query. It keeps asking me for 'Tendor No' even though it is IN the query and i am just specifing it in my docmd.openreport call.

I tried redoing the form, the report. and the query, but no matter what it prompts me for the value.

I have no idea what is going on here. Any ideas?

BTW: all the other fields work fine except this one. I can specify any other field and it filters it correctly, just not this one.

 

[dcx693]

Please post your OpenReport call so we can see if there's anything going wrong in there.

 

[dott]

code

sorry, here it is:


DoCmd.OpenReport stDocName, acViewPreview, , Mid(stlinkcriteria, 5)

(stlinkcriteria starts with " AND " so thats why i used mid)

 

[dcx693]

Nothing looks weird in there. Can you post the SQL for the query that is the source for the report?

 

[dott]

SQL

SELECT Contracts.[Tender No], Contracts.[Contract No], Contracts.[Project No], Contracts.[Contractor Name], Contracts.[Beginning Date], Contracts.[End Date], Contracts.[Security Deposit], Contracts.[WCB Valid Date], Contracts.[Insurance Valid Date], Contracts.[NSCSA Valid Date], contractors.[Phone Number]
FROM contractors INNER JOIN Contracts ON contractors.[Contractor Name] = Contracts.[Contractor Name];

 

[dcx693]

OK, the SQL doesn't appear to depend on the form or report, so does it still prompt your for that parameter if you just run the query on it's own?

 

[dott]

no it doesnt prompt by itself, only when i try to specify a paritcular tendor no

my form lets me specify any of the data then the report is opened using the where clause thing

but anything i specify filters through fine, except tendor no which it prompts for a parameter value
\

 

[dcx693]

OK, have you specified any parameter in your query? In other words, if you go to the query in design view, go to the Query menu and choose Parameters is anything listed?

 

[dott]

nope there is nothing listed there
this thing is pure evil

 

[dcx693]

LOL. Sometimes Access does some really weird sh*t and I feel the same way. I assume you've tried a repair and compact on the database? I would also try importing the tables and query into a fresh new database and then try running the query from there, seeing if it still prompts you for the parameter.

In the end though, you might be forced to do what I did when faced with a similar problem. I posted my workaround here

 

[dott]

hmm i tried everything you said including making a query based on the original, it still prompts

this doesnt make much sense to me at all, especially since specifying every other field works properly

so i guess im just out of luck here then?

 

[dcx693]

My last suggestion: post a copy of your database here so we can take a look at it. Maybe we're just missing something obvious?

 

[dott]

hmm i tried to strip it down and ist s till too big, 182 kb zipped
( i compacted + repaired)
there must be some other way?

 

[3bker]

i think i have similer problem, i have a quarry on my database where it is working well but when i open it i have 9 msg box saying enter Paramenter Value.
when i click ok 9 times it works well but i cant have reports on this way.
please help me with his as this is storring all the project.
Database is attached and the problem is when the quary called "qryLast"