enter parameter value?

[jerry28ph]

Got a confusing screen, i suppose to run my main form to enter criteria for my query when a strange small screen saying "Enter Parameter Value" appears. Please is there something wrong with my query?

SELECT Count(*) AS TDirect
FROM TabLogs
WHERE (((TabLogs.Party1Name)=[forms]![FrmLog]![combo17]) AND ((TabLogs.Dialled_number)=[forms]![FrmLog]![text135]) AND ((TabLogs.Direction)=[forms]![FrmLog]![text30]) AND ((TabLogs.[Call duration])<>#12/30/1899#) AND ((TabLogs.[Call start]) Between [forms]![frmLog]![text295] And [forms]![frmLog]![text297]));


I also attached a shot of my SQL Design view and a strange screen:
Please need your help.
Thanks.

 

[John Big Booty]

The "Enter Parameter Value" pop up indicates that the query you are running is looking for a criteria value that it is unable to automatically derive, so it is asking you (The User) to supply that value.

Your second screen shot does not show the full extent of your query so I am unable to be more specific.

 

[jerry28ph]

Is there a way not to show the screen asking for the criteria since i have a main form that i should enter all the criteria? This screen "Enter Parameter Value" shows before my main form (frmLog).

The "Enter Parameter Value" pop up indicates that the query you are running is looking for a criteria value that it is unable to automatically derive, so it is asking you (The User) to supply that value.

Your second screen shot does not show the full extent of your query so I am unable to be more specific.

 

[ajetrumpet]

Your second screen shot does not show the full extent of your query so I am unable to be more specific.

John,

This response of yours soooooooooo sounds like something the robot V.I.K.I. would say in that movie IRobot.

 

[John Big Booty]

Is there a way not to show the screen asking for the criteria since i have a main form that i should enter all the criteria? This screen "Enter Parameter Value" shows before my main form (frmLog).

Yes; ensure that the value the query is looking for is available.

Without seeing exactly what is happening in the DB, I'm very limited in what I can tell you.

 

[John Big Booty]

John,

This response of yours soooooooooo sounds like something the robot V.I.K.I. would say in that movie IRobot.

I would have hoped for something a little more Kryten-esque

 

[gemma-the-husky]

jerry

you need to change the query to use a parameter the programme can get from your code (possibly with some sort of default value)

then either you have to popup a criteria request form, to get a value, and use that.

or have the criteria on your form, and requery the data if you change the criteria.

----------
the trouble is access needs some programming input to get more use from it, and make the interface more user friendly

 

[CEH]

Looks to me like its looking for a value for combo17 that is not there... check that.