Advice on Filtering By Form
I'm looking for advice on how to go about creating and encoding a filter by form buttons on my Access 2007 main form.
I want the command button to change my form to look like it does when I use the toolbar's Filter By Form option and a command button that performs the same action as Apply Filter/Sort.
To summarize: I want buttons on my form that do the same things as the options on the toolbar.
I'm new to coding but would like to do this myself, more or less. I haven't found much stuff online that wasn't about advanced stuff like ADO and DAO programming.
Any thoughts, tips, insights or helpful suggestions, out there ot help me on my way?
Is this best suited for macros?
Main-Form.jpg
I want the command button to change my form to look like it does when I use the toolbar's Filter By Form option and a command button that performs the same action as Apply Filter/Sort.
To summarize: I want buttons on my form that do the same things as the options on the toolbar.
I'm new to coding but would like to do this myself, more or less. I haven't found much stuff online that wasn't about advanced stuff like ADO and DAO programming.
Any thoughts, tips, insights or helpful suggestions, out there ot help me on my way?
Is this best suited for macros?
Main-Form.jpg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Can you recommend a good place to look to copy code for this purpose (regardless of how it is performed)?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I see your point. I wanted to search by field without using a seperate form including using multiple criteria.
Can I get back with you, tomorrow, after I send a picture of the Allen Browne code I adapted (and decided not to fiddle with)?
It involved creating combo boxes, etc., in the form header and a search/cancel command button. I was having some snafus, but I think it was pretty close to working.
I was hoping to avoid adding more junk on my form. I wanted to idiot-proof the user form so other's could use it in my absence.
I think I can present it in a clean-cut and straightforward manner that will make it clear as to what needs tweaked.
Is that okay with you?
Can I get back with you, tomorrow, after I send a picture of the Allen Browne code I adapted (and decided not to fiddle with)?
It involved creating combo boxes, etc., in the form header and a search/cancel command button. I was having some snafus, but I think it was pretty close to working.
I was hoping to avoid adding more junk on my form. I wanted to idiot-proof the user form so other's could use it in my absence.
I think I can present it in a clean-cut and straightforward manner that will make it clear as to what needs tweaked.
Is that okay with you?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you, both. It may be as much as 24 hours before I can implement, get back and award points. All this stuff looks like sound advice.
See you then!
See you then!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
A.) I think the custom toolbar might be most practical for now. Is there a web tutorial you can refer me to, or, is it easier simply to explain it?
I look forward to hearing from you.
B.) Also, as my skills grow, which strategy do you recommend I look to in order to employ the ability to edit a filtered/queried recordset? Using plain code? ADO?
I was hoping for a 1-word/1-sentence answer, so as to know what to pay close attention to as I study. Thank you.
I look forward to hearing from you.
B.) Also, as my skills grow, which strategy do you recommend I look to in order to employ the ability to edit a filtered/queried recordset? Using plain code? ADO?
I was hoping for a 1-word/1-sentence answer, so as to know what to pay close attention to as I study. Thank you.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
mbizup & boag2000, you both sunk so much time and energy into instructing me! I've converted this to .pdf doc so I can review this, offline. Once I realized how far over my head I found myself, I realized that I need to go back to the proverbial 'Brick pile". But I like that idea of customizing the Ribbon. And I understand that SQL manipulation is going to be the expert way to do stuff, when I get to that.
Thank you for my online college experience, here!
(The points added up to 80/20%)
Thank you for my online college experience, here!
(The points added up to 80/20%)
Glad to help out!
Good luck with your project.
Good luck with your project.
ASKER