Recent content by Hagridore

I have created a database that displays my issues so I can show what I'm trying to do. In my comments/questions above I referred to region and location. In this sample database I refer to department and building. The database opens with the Faculty form showing. The text boxes txtOffice and...

. The end, perhaps?

Here's a database that is different than mine but demonstrates what is going on. It opens with the form open. Clicking "New Search" button starts the filter by form process. Selecting any of the "Department" entries as criteria for the filter will bring up a subset of the Faculty records...

smells like magnolias

A very interesting video. It looks like it's doing what my original search/filter form does. Now what I need to be able to do is to select a location and have it pull up records showing the correct region (or the equivalent).

I think this is getting awfully close. :-) And maybe it's closer than I think. I'm feeling a little addle-brained just now. In the OnFilter event, I have a list box with the drop-down list of cities (lstCity) and a text box that shows up as empty (txtState). In the ApplyFilter event...

Spikepl..there's no code to show. I'm not sure what you're asking or what I'm not making clear. I described the process. It's a form. It is being used for filter by form, pulling data from a table, where, in one field, the value "All/Integrated" lives. The filter, with no code...just filter by...

That's just the point. There is NO subquery. The system appears to be reading the slash mark in the DATA...the contents of a field...as an operator. However it appears only to be doing this with the specific words All/Integrated and not as a general rule. I created an example that represents...

This was EXACTLY what I was looking for. Thank you so much. It's all working exactly how I wanted it to. I'm looking for the place to mark this as "solved" but haven't found it yet. Again, thank you!!!! :)

I originally posted this as a reply to a question posted in 2013 and didn't get a reply, So I thought maybe it was too old. In my database there is one value that requires the use of a /. (This is not as a name of anything...just a value stored in one of the fields.) I have a form which...

This is going to sound really dumb. However, they say confession is good for the soul, and in case anyone else ever runs into this situation, perhaps they can learn something from my unterbrilliance. It appears that when I copied the form for the newer year from the older year, it simply carried...

I appreciate your comments. I do hope to do the paid membership...unfortunately various health concerns have made me miss work and without PTO of any kind my checks are smaller. I think I just discovered why I've been thinking no one's responding. I put several questions in the system this...

Though the information in this reply is very interesting, and I'm likely to use it at some point, it doesn't answer my question, so let me be more specific and clear. I looked at what I wrote above and, if I didn't already know what it is I need to learn, I'm not sure I could've figured it out...

Once again proving y'all're super human, you got back to me minutes after my post. I just went back over my material here as well, and can't find some things I thought were posted here. It's possible I posted in another forum...I've been in several...and it's also possible I had an issue with...

Greetings! I have truly benefitted by my participation in these forums. I have had several questions answered by the great gurus that respond to queries here. I have been unfailing in my thanks and in my praise. I have done my best to always have my communication be in a positive voice. I...