Problem with Search Boxes (1 Viewer)

OK, I watched the video, and the different debugging methods make sense to me, but every time I try to put in a break and then run the code, it asks for a macro name. This doesn't make sense to me...the code is directly attached to the search box.
 
I watched the video, and the terms make sense now, but applying them to my code is different. I tried adding breaks and a stop to the code to try it out, and it keeps asking me for the name of the macro. There is no macro - the code is an Event Procedure directly from the object.

I also read your comment about the AND not working at the beginning of the code...what is the alternative then, for narrowing down the results?
 
You place a breakpoint in the code in that event procedure, then run the form as normal.
That will take you into that procedure and walk the code line by line with F8.

Place a Debug.Print of the filter string before you try and use the filter and see what it produces.
An AND is only valid for subsequent extra filter strings, NOT the first string.
 
I watched the video, and the terms make sense now, but applying them to my code is different. I tried adding breaks and a stop to the code to try it out, and it keeps asking me for the name of the macro. There is no macro - the code is an Event Procedure directly from the object.

I also read your comment about the AND not working at the beginning of the code...what is the alternative then, for narrowing down the results?
Hi @Heide. We're two pages in and it seems you still need some help. Just out of curiosity, did you see my comment in Post #13?
 
The statement that all data records are retrieved from the server and only then filtered in Access cannot be confirmed in the SQL Server by observing the XEvent Profiler.
The initial fetch brings down enough data to fill the form, the rest is fetched in the background, x rows at a time. It is possible that this wasteful behavior was altered in more recent versions of Access. Select a large number of rows, wait for the Y value to fill in in the navigation bar. Once that fills in, all the rows have been retrieved.
 

Users who are viewing this thread

Back
Top Bottom