Is any familiar with Access?? I'm in the process of building a membership database and need to create a form for filtering.
Microsoft Access 2007??
- Thread starter akingsley9000
- Start date
- th_trl_thread_readers 0
- Status
Klamathkid - no I don't think Open Office would work since I have already built the database - I most likely would have to start over from scratch.
Micheal - I have posted this in several access forums but no one seems to ever answer or they just refer me back to pages I've already looked at that are not what I'm looking for.
Micheal - I have posted this in several access forums but no one seems to ever answer or they just refer me back to pages I've already looked at that are not what I'm looking for.
Anyway, start to build a query. In that query you have to put the parameter of the field you wish to filter out. Once completed, when you build a new form, put the name of the query as the source so as to assign the fields in the query on the "text" object in the form.
I'm trying to create a user friendly form for filtering from another form. Its a membership database so i need to be able to select multiple options. Basically, I want to recreate this form:
the setup you want will take a lot of scripting and IMO it will not be user-friendly. Try a more simplified approach. I've done mine on a tabular form wherein each field can be filtered using an input box.
I'm not looking for the setup to be user friendly just the form. I know now it will take alot of scripiting and I'm ok with that I just need someone to point me in the direction of where I can find the info on scripting that I need. I tried to explain queries to the company that I am building this database for and showed them how to do but but they are afraid of it. The form above is the filter form from their old database and that what they want.
I must have had a mental lapse, because I could have sworn you said Excel 2007, not Access 2007. My bad and the reason for my edited post.
Last edited:
Using Access is a must. Its a fairly large database over over 1800 members containing payment history, membership status, addresses, education, and a whole bunch of other info.
- Status
Similar threads
