I have created a report in Access 2000 that I have opened and printed 

several times with no problem.



Now today, when I try to open it, I get the "Enter Parameter Value" dialog 

box, with my table name and one of the field names referenced.  



Does anyone know what I should do about that? 



Thanks --

Mary Dewey

Mary,



Have you recently changed the SQL statement that feeds your report?   If so,

you may have a table/field name misspelled.



Have you recently changed the name of a table or field that is used in the

report?  That could also cause it.



Basically, that message just means your report is saying, "I can't find a

table/field that you asked me to look for, so I'm assuming it is a parameter

(a beginning/ending date, for example) that you wish to enter manually each

time...".



If you've done neither, and in conjunction with your next email about not

being able to create DAP pages, you may have corruption in your database.



You might try making a backup and then running compact/repair on your

database.





HTH,

Howard H.







----- Original Message -----

From: "Mary Dewey" <smitty@a...>

To: "Access" <access@p...>

Sent: Sunday, December 09, 2001 1:03 AM

Subject: [access] "Enter Parameter Value" Dialog Box





> I have created a report in Access 2000 that I have opened and printed

> several times with no problem.

>

> Now today, when I try to open it, I get the "Enter Parameter Value" dialog

> box, with my table name and one of the field names referenced.

>

> Does anyone know what I should do about that?

>

> Thanks --

> Mary Dewey




>

> Mary,

> 

> Have you recently changed the SQL statement that feeds your report?   If 

so,

> you may have a table/field name misspelled.

> 

> Have you recently changed the name of a table or field that is used in 

the

> report?  That could also cause it.

> 

> Basically, that message just means your report is saying, "I can't find a

> table/field that you asked me to look for, so I'm assuming it is a 

parameter

> (a beginning/ending date, for example) that you wish to enter manually 

each

> time...".

> 

> If you've done neither, and in conjunction with your next email about not

> being able to create DAP pages, you may have corruption in your database.

> 

> You might try making a backup and then running compact/repair on your

> database.

> 

> 

> HTH,

> Howard H.

> 

> 

> 

> ----- Original Message -----

> From: "Mary Dewey" <smitty@a...>

> To: "Access" <access@p...>

> Sent: Sunday, December 09, 2001 1:03 AM

> Subject: [access] "Enter Parameter Value" Dialog Box

> 

> 

> > I have created a report in Access 2000 that I have opened and printed

> > several times with no problem.

> >

> > Now today, when I try to open it, I get the "Enter Parameter Value" 

dialog

> > box, with my table name and one of the field names referenced.

> >

> > Does anyone know what I should do about that?

> >

> > Thanks --

> > Mary Dewey




> >

> 



Howard -- I just wanted to thank you for taking the time to answer my 

question -- your answer was all I needed to get the situation resolved.



Thanks!



Mary

smitty@a...

I'm having similar problems concerning reports and the 'Enter Parameter 

Value' dialog box.  I'm using a storedproc as the recordsource for my 

report, and declaring the inputparameters on the OnOpen event - 

Me.InputParameters = "@TripSched_id int = 88,@SG int = 

13"                      

Me.RecordSource = "BatchFile_ActiveRegens"



Any ideas why this would not work?