Search results

I was looking in the wrong place. I was looking in the properties for the command button not for the form itself. The top corner between the the two rulers. It now opens up with the results. Just one little problem. If there are say two results to display it displays just one and i have to click...

I am struggling to get it to display the collected results. I can't get it to see the gathered results. If I could I'm confident I can make the subform to display them. Trying to follow the sql code in db1 with forms 1&2 and form 1 has code for command 4 and 5 yet I cannot see where the command...

I'll be sure not to do that again.

SUCCESS!!! I did it. Managed to put it into my db. I started it on office 2010 beta then switched to Access 2003 as that is what the computers running this db have installed on it. I believe this lead to a missing reference in Microsoft Office 14.0 Access database engine Object Library as the...

Yep thats it. I am impresssed at how you simply change it when you need to. I've decided to go to the local adult college to learn how to use access properly. Unfortunately that wont start til Sept so in the meantime I'll have to figure this out myself as they need the db asap.

I just noticed that in DB1 John Big Booty gave me that if you change the ages so they are all different i.e. not having 3 at the same age like 32 then it will only count those the same age or if they are all different only count 1 of them. I have managed to recreate that db and it acts just like...

It's Access 2003. I'll look for it and see if I can do that.

The password is Social. No need for it i was just trying adding security and forgot to take it off. My mistake. It has to be a capital S. Apologies.

The only things checked are visual basic for applications ms access 11.0 object library ole automation ms office 14.0 access db engine objects library It seems most things installed on my pc are listed in the references. I do have 4 more visual basic for applications unchecked.

I'll try doing just an age groups db from scratch and see if I can get it to work. That db is just a draft, a way for me to learn and to see what they want in it and how it's implimented. I'm sure recreating wont take too long.

It had worked in the one I gave you. I deleted the queries and forms I made which I had recreated from the db you gave me because I couldn't get it to list the results like in the last db you kindly provided for me. When I tried to do it again, well you have the results. This is the code I used...

I feel better now knowing someone who actually knows what he's doing is also stumped :D It's probably something I've done.

OK. I have done it's saved as 2003.

Here it is. There is no personal data on there. It's too big for the forums upload system. http://www.2shared.com/document/bIy_IPIy/Socialaccdb.html

I'm just not getting it. I'm having real problems now. i decided to start again with this to keep everything tidy and no I can't even get it to count the ages. What I get is in the enclosed picture. I have replicated the first db.mdb you gave me apart from the fact the values aren't from a...

Thanks. I'll try that tomorrow.

Hi. Could you explain how you to make it show the related records in that last form please. I've tried everything I know, which isn't much but I'm learning, but no luck. I'll keep plugging away at it in the meantime. I've managed to recreate the Age groups and number in groups section although...

Ok one more problem. I've created a combo box that displays how many in the age range so how do I get it to list the client records? For instance there are 2 over 40's who are jan and john. When I click on the over 40's box it then list the files for both jan and John?

OK. I figured out how to get it to count the ID. I'm showing the first draft of this db tomorrow so I'll ask them how they want this data integrated. I want to thank you for sorting this out for me. There's not much more else I can do now until they tell me what changes they want. Hopefully it...

Thanks for your reply. the age range you provided was exactly what I was after so thank you. I'm trying to implement it into my db and have it working but i am having problems having it work out the total for each age range. On yours you have it linked to the client ID on Table1. i am having...