Recent content by nomojo

My problem is simple, and i imagine it is easy to fix. I have more forms in my db than I would like to count, and I have a couple lines of code to add to the onload event of each form. Is there an way, without actually having to edit each form myself, to add the code i need to add to all...

That is almost exactly what i have. I have an unbound text box where the user can input the name of the volunteer they are looking for, or because i am using "like" any part of the name they are looking for. I am trying to make it so they could just put in a letter, such as "L" and only the...

I phrased my question poorly. I am referring to if the user types an "L" or any other letter for that matter, into the last name field, all the results that back will begin with that letter.

Thanks Beetle. It took me some time to get the full gist of the search code, but once i did it became easy enough to modify to fit my needs. The client is happy, thanks much. I do have one question, its not a big deal, just for some piece of mind. In the filter code example for the text box, it...

I am working on a volunteer database for a local non-profit. They have many programs and would like to filter the names they see so that only the volunteers that fit their profile (job, availablility, interests, etc) are shown. Is there a way for me to provide a form that gives them the options...

thank you both Pat and Bob, everything working. You saved me a lot of headaches.

I dont know if this is in the right spot, or if it is even possible. I am trying to take similar fields from unrelated tables. both fields contain information about the age of my clients. The tables they are in are unrelated, as they are different types of clients, and therefore can not find...

The Goal: I am attemting to find something called shelter nights. Shelter nights is determined by taking the number of nights a household stayed in the shelter and multiplying by the number of people in the household. its quite an easy formula, and i can do it quite well in Access. My problem...

nevermind. i think i got it.

Okay, I have a form that pops up when a button is pushed. I would like the parent form to open the record chosen in the pop up when the ok button is pushed. i have the close command figured out, i just need the right record to open on the essentially parent form.

alrighty, bound the textbox everything is working as expected. thank you very much!

The checkboxes are bound to fields in the table. they are yes/no fields. the text box is not, because it is simply for display purposes

That works for single form view, but in continuous or data sheet, all the records say the same gender when you check one of the options. for example, if i check male in one record, all of them say male, while their respective check boxes may say otherwise. i would like to be able to see all the...

I have a form that involves a block if statement in the OnPaint event. The form is set to continuous forms view. As soon as i placed the code in the onpaint event, the forms that are not the focus keep flickering, if i change the focus the flickering changes, so that those that do not have the...