Unanswered: error 2001 you cancelled the previous operation
New client has just upsized tables to sql
It seem everywhere they are using any domain aggregrate function
(dlookup,dcount,dsum) they are getting this error
dim mycount as integer
mycount = Nz(DCount("[MenuNumber]", "qryModifiers"), 0)
btw this works
Dim mycount As Integer
Dim mytable As String
mytable = "tblpos_data_hold"
mycount = DCount("[line]", mytable)
is the error (and not the real error I may add) because they referenced a query object?
do I need to use a reference for the recordset as in the example?