I named a database as Report (stupid thing that I did in the beginning!!!!!) and for unobvious reasons I was getting errors while trying to use the Report in the VBA. So I made a brand new project in MSaccess and copied all the modules and class files to this new project. I also copied the forms. Now the statements that worked fine in the old project do not work in this project.
I am using the following statements
First I use:
"Dim strSQL As String
strSQL = "SELECT tblFATS.* FROM tblFATS WHERE ID1 >= 50"
CurrentDb.QueryDefs("MYTempQuery").sql = strSQL"
and I get the following error
Runtime error 3265
Item not found in this collection
I commented that statement and I proceed with the execution of the following statement
DoCmd.FindRecord strsearch, acAnywhere, False, acSearchAll, , acAll, False
I am getting the following error:
Runtime Error 2162
A macro set to one of the current fields properties failed beacuse of an error in a FindRecord action argument.