Search results

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...

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 don't know what you mean. Not one of those terms is familiar to me...sorry.

Hi, Pat. I'm using the code suggested here and, after a few false starts, I'm not getting any errors. However, I'm also not getting any results. The data has 624 records, and no matter which criteria I enter, still shows 624 records. I'll post the exact code I'm using below. I've only done...

I think I get it...I'll go to code posted in #6, and start over with the search boxes. One more question, the code I'm using is attached to the OnKeyUp property. Would it be better in OnGotFocus property? Thank you sincerely for all your help.

Thank you. I must admit to feeling a little (a lot) lost here. I am not a programmer, but need to do things in Access that require programming, so please have patience if my questions seem really basic. At this point, would I be better off to remove all the VBA for the search boxes, and start...

I think it's SQL server...standard MS Access install. I can't find the post you mention above from arnelgp...would a link to it be possible? Thanks!

Thank you for the help! I'm trying to implement your suggestions, and running into an error message when I try to test the search box. It seems to think that the object name (txt_search_box) exists more than once, which it doesn't. In your example, do you not name the search box objects?

Thank you. I'll try to be clear about what is happening vs what I would like to have happen.

In the original code, it did concatenate several fields, but they were all in one box, so didn't work well (same basic problem...when it found results, they listed, then when more criteria were entered, the records reset). I think I understand the concept of what you are suggesting, and it...

Thanks, Paul. So far, this seems like an awesome group!

I am working on a database currently, and have set up search boxes in a form. There may be three or four or five of these boxes, depending on the form and the underlying data. While the boxes are working, they reset the recordset when I go from one box to the next. In other words, the first box...

Thank you!

Hi! I'm Heide, from Canada. I am very good with Access as a program, but have never learned to program. I now find myself working with projects that do need programming and have a LOT to learn. I hope to be able to post my questions here, and receive good answers. If I post something and it's...