Search results

Well i got the code to work by changing the event from On Change to After Update. Works great. Thanks for attempting to help me. Jason

is there any way to reset this or get it to work every time a user updates the address search field?

Thanks for looking at my post. What I have done is this, i have built a custom search form for my access database. What i need is a textbox that shows how many records will show up if the user clicks generate form.. I want this textbox to update every time the person changes his search criteria...

My title is a little confusing, i have a form with a subform, what I want it to do is this say i have 10 records, 3 of which are missing any data in the subform... then when i show the form it only shows 7 records. This way all records have data in both the main form and the subform... is this...

This is a very quick question. I have a query what i need it to do is show me all values that equal 2 and any records that are blank, this is what the criteria looks like currently Field: Month([FDate]) Total:Group By Criteria: Month([DDay1]) Now the way this works is it only shows records...

I have a report that is linked to a query... lets say my query returns no records the report comes up with a whole bunch of #Errors on it. How do i prevent this from happening? thanks Green

I found out a way to do this, just thought i would share my answer, I ended up creating two queries, one that summarized all the data and then the second one to query the first. This makes the query run much faster as the custom function is only being run on the summarized data instead of the...

Thanks for helping me out with this question. Im sure this is pretty easy to do. I have a query with a few paramaters set up... one of them runs a custom function all i want to do is this query one Average water flow:Avg([WaterFlow]) when run this just shows me the average water flow for the...

Thank you John471 I will try this out I hope my small (demo) Db was at least fun to work on, i tried to add some unusual names, ill let you know if i get it working. Much Appriciated Jason

Ok, here is the small sample database, i made it real quick but it shows what im trying to do, you can look at the two tables im trying to filter out the developer names from the tblOccupants, I am trying to do this by having a query look up the values in tblDeveloperInfo and just not show these...

I will make it really really tiny :)

I hope someone is able to help me with this problem, mabye it would help if i attached a sample database with two queries to better explain my problem... Green

Kenhigg what do you mean by "bring down the dev name"? I need it to be dynamic. I hope I don't need an extra field, I would have thought this possible when the code works when i run it one way and mostly the other way. Here is the funny thing, lets say there are 5000 users and 2000 developers...

Im really stumped.. and I really need some help, Here is my problem, I have a field with a whole bunch of regular peoples names in it (user_names). Home Developer names are also in this field, it has to be this way to show if the home is still owned by the developer or moved into. What im...