Search results

Access 2010/ web database/ web macro: I have my Task Form, with a Task Subform. The subform should be filtered first by the list box ListWeeknumber, then the tasks displayed for the actual week should be filtered by the list box ListDepartments. I'm thinking something like this...

Thanks to both B's, for clarifying the macro terminology, and getting me on the right track regarding the macro code. The button is certainly filtering now, but I need to fiddle around with the macro to get it to filter the correct dates :) Thanks again!

No, I don't think I got it, so I just have to ask: how can I write a normal macro when working with a web database in Access 2010?

Hi boblarson, and thanks for answering :) I would like to use a normal macro for this, but since this is a web database I believe I'm excluded from that possibility. My understanding is that I have to use the data macros, and choose between the following filter actions in the macro builder...

Access 2010/ web database: The main form is named Task Week Form, and the sub form is named Task Week Subform. The form query is just a basic select query from the the Tasks table, which amongst others contains a StartDate field for each task. How can I program a button to filter the subform...

Hello, I am working on a simple Access 2010 web database, purpose: task administration for a few of the departments in my company. Tables: Tasks and Departments Both tables are properly setup, with a lookup for DepartmentName in the Tasks table. I have already made a Task datasheet containing...