Search results

Thanks for your reply! However, I believe your solution would only list the rows in which the EmployeeNo is equal to the value in the combo box, or am I mistaken? In my table, there may be many rows with the same projectNo, but different EmployeeNo (many people in the same project). I would...

Hello, I'm very new to Access and have a problem: I have a table with fields as follows: ProjectNo, EmployeeNo, [+many fields which display dates when the employee was finished with different tasks in said project] Each project can have many employees, ie one row for each employee (but with...

Hi, I'm very new to Access and have question. I would like users to get filtered report data based on a combo-box or similar. How do I do this? I tried this: 1) I created a form "frm1" with a combo-box "combo1" choosing from values in a column in query "qry1". 2) I then made a query "qry2"...

Hi, I'm terribly new to Access, so forgive me if this makes no sense ;) Let's say you have multiple people inputing data to an Access database through forms. Is it possible to let these forms be opened as files directly through the Explorer file system? So that each person might have their own...

Thank you!

Thanks for your reply! My plan is to let several employees input their own work status for each project in their own spreadsheet. I then want to link all these spreadsheets to an Access file where the above transformations are made. Whenever someone inputs something new in their personal Excel...

Hi everyone! I'm very new to Access, so please bear with me if my question may not make sense :) My situation is this: I have two tables in Access that each are linked to an Excel spreadsheet. The two spreadsheets have the same column headers. Table 1: Project no, date finished with task 1...