Search results

correct. i admit i deleted the post because i decided i didnt want to bother anyone and just kinda figure it out. I got the search form to display the School ID and School Name via a query and adding both columns to the properties. so thats covered. the value returned is the ID, which makes life...

OK. I got the search working ! ( I had to use a split form to get access to get all form fields to show u early...it seems access cant go past 22 inches unless its in a datasheet form) using the tools you have given me I think im going to do some exploring and see if i can build a more dynamic...

OK! I am with you now! at first I was having trouble understanding the ModifyQuery function. but once you explained the parameters being passed to it via the integration into the Allen Browne code snippet, it all made sense. I will put the puzzle pieces together and report back as soon as I...

awesome. thank you for responding so quickly, as well as the reassurance that this is very possible to do! I am going to go through the posted code and read up on the functions, and objects so i know exactly whats going on (still new to the VBA coding). I am trying to get the train of thought...

got it. went through properties of the form and it is set to both. yeah it is definitely a lot of fields, it makes me nervous because I am not sure if Access was built to handle such an extensive advanced search. naw, its a Continuous form (or Multiple items form) so i put the unboound...

Good Afternoon Everyone, I am currently serving as a Peace Corps Volunteer at my host countries Department of Education. The goal is to construct a database encompassing every teacher's information throughout the region. The Form I am currently working on is a search form. My goal is to...

yeeeah, the experience is definitely weird like that. The general perception of the peace corps volunteer by Americans is living in the woods, with no electricity, saving little foreign babies every day. I am definitely right outside the city, with a satellite on my roof (for internet access)...

Ah! did she like it? I am in Guyana.

Hello all My name is Robbie Robinson. I am originally from Charleston, South Carolina, but am currently serving in the Peace Corps. So I am over in South America at the moment. got my undergraduate degrees in Computer Science and another in Mathematics. I am an ok programmer, my usual work...