enter parameter value?

jerry28ph

jerry
Local time
Today, 06:43
Joined
Nov 16, 2008
Messages
141
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.


 

Attachments

  • parameter.JPG
    parameter.JPG
    8 KB · Views: 142
  • query.JPG
    query.JPG
    54.3 KB · Views: 127
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.
 
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.
 
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. :D
 
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.
 
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
 
Looks to me like its looking for a value for combo17 that is not there... check that.
 

Users who are viewing this thread

Back
Top Bottom