We are using Access 2007 (our DBs have issue when we try to open in Access 2010 or 2013).
In a DB, with VBA code, that has been working for over a year, now it is giving the following error -
(Sorry, pic didn't show as I wanted.)
It says :
Runtime error '3061'
Too few parameters. Expected 1.
The code in question is this -
strSelect = "SELECT Requestor, Create_Date, Status, ShortDescription, LongDescription, RequestType, System, AssignedTo, RCAType, Billable, ETA FROM Issues WHERE TTP_No = " & varSelectedTTP
Set rstIssues = CurrentDb.OpenRecordset(strSelect)
When I run it, the strSelect is
SELECT Requestor, [Create_Date], Status, ShortDescription, LongDescription, RequestType, System, AssignedTo, RCAType, Billable, [CBA_EST_ETA] FROM Issues WHERE TTP_No = 1845
The field names are all spelled correctly, TTP_No is defined in the DB as a Long Integer.
What parameter does it think is missing, and why did it just start showing the error today, when it has been working for the last year?