sintax error (1 Viewer)
- Thread starter irade92
- Start date
Ranman256
Well-known member
- Local time
- Today, 13:48
- Joined
- Apr 9, 2015
- Messages
- 4,337
something in the query wants a parameter filled in.
either a form reference,
or instant param field: [param enter here]
or a misspelled fieldname
if the query DOES need a param filled, then you cant use your structure,instead use a querydef and fill in the param there....
Set qdf = currentDb.QueryDefs("qsMyQuery")
qdf.Parameters(0) = "6/1/03"
qdf.Parameters(1) = "11/1/03
set rst = qdf.openrecordset
either a form reference,
or instant param field: [param enter here]
or a misspelled fieldname
if the query DOES need a param filled, then you cant use your structure,instead use a querydef and fill in the param there....
Set qdf = currentDb.QueryDefs("qsMyQuery")
qdf.Parameters(0) = "6/1/03"
qdf.Parameters(1) = "11/1/03
set rst = qdf.openrecordset
- Local time
- Today, 12:48
- Joined
- Feb 28, 2001
- Messages
- 27,175
Also, it is possible that due to substitution or other unusual syntax, you might have a function that demanded a parameter but somehow you didn't supply one even though you might have thought that you did.
My intention was to count unmatched articles, so I solved this in another way..in a table are all articles and in a form are only match so a simple math solved this ..how many unmatched articles are..Dcount in a table minus count in a form..simple isn't it
Thanks for your answer
Similar threads
Solved
Viewing Images on Forms
