Hello, I am new to the forum and joined to get help on a specific project I am working on. I am not sure which topic this falls under.
Background: I create a lot of ppt decks for work and it is difficult to keep track of the hundreds of slides I need for the many decks.
I want to create a slide library using access where I can upload all of my slides and then perhaps run queries to create these decks.
I've been able to create a table that has the actual ppt slide, and some information about it (i.e. Author, date of creation, type of slide, unit, segment, etc.).
I've also created a basic form that displays this information using the Access Wizards and can scroll through the table and display the slide in the form.
I want to start customizing this form by creating combo boxes to filter by slide type first. So for now, i'd like my form to have a combobox that acts as a filter for the slide on display. For example, my table contains slide types for Revenue and Volumes. In the combo when i pick Revenue, I'd like to be able to scroll through only the Revenue slides on my form.
Later i'd like to add additional filters for author, unit, etc. I hope the above makes sense. I'm running into a lot of problems. I would appreciate any guidance you might have.
thanks,
Juice
I
Background: I create a lot of ppt decks for work and it is difficult to keep track of the hundreds of slides I need for the many decks.
I want to create a slide library using access where I can upload all of my slides and then perhaps run queries to create these decks.
I've been able to create a table that has the actual ppt slide, and some information about it (i.e. Author, date of creation, type of slide, unit, segment, etc.).
I've also created a basic form that displays this information using the Access Wizards and can scroll through the table and display the slide in the form.
I want to start customizing this form by creating combo boxes to filter by slide type first. So for now, i'd like my form to have a combobox that acts as a filter for the slide on display. For example, my table contains slide types for Revenue and Volumes. In the combo when i pick Revenue, I'd like to be able to scroll through only the Revenue slides on my form.
Later i'd like to add additional filters for author, unit, etc. I hope the above makes sense. I'm running into a lot of problems. I would appreciate any guidance you might have.
thanks,
Juice
I