Oli wrote:
SELECT * FROM tblNumbers WHERE AllocatedTo=AlternateMedia
Which is correct!
No, it is not correct. Strings need to be delimited in queries.This is
correct:
SELECT * FROM tblNumbers WHERE AllocatedTo='AlternateMedia'
Just noticed that the error is not with that
line.... Line 33 is:
rs.Open sql, cn
What does "Expected 1" mean?
That's not the whole error message. The whole message is "Too few
parameters. Expected 1."
Because you did not delimit the word AlternateMedia, Jet looked for a field
named AlternateMedia in your table. When it did not find one, it treated
AlternateMedia as a parameter. Since you did not provide a value for the
parameter, it returned the error you reported. It's "expecting" a value for
"1" parameter.
If you had copied and pasted that query from the browser window into the SQL
View of the Access Query Builder and tried to run it, you would have been
prompted for a value for AlternateMedia. (this is how you should debug your
queries)
Your code should be changed to:
sql = "SELECT * FROM tblNumbers WHERE AllocatedTo='" & _
Session("Company") & "'"
Better yet, instead of using dynamic sql, you should use a saved parameter
query. A Google search should find plenty oif examples of this.
HTH,
Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
