Search results

When a normal user opens my SP Reports.accdb database they are presented with a Form with 3 buttons. Each button takes them to a different Form that will produce a Report or Query based upon their selection. When the user selects button 1 or 2 they get the following error message: “The...

Have researched cascading combo boxes and am unable to find out if they can be based on a query instead of tables? I have a query that pulls information from four different tables named Query1. On the Form is it possible for the combo boxes RowSource to be Query1?

My Form1 has 2 Combo Boxes and a Command Button that runs a Query. Query Criteria: Like [Forms]![Form1]![Combo0] & “*” or Is Null Like [Forms]![Form1]![Combo2] & “*” or Is Null Combo0 entries include: Faculty Faculty & Staff Faculty, Staff & Students If I...

I have a main table that has relationships with seven other tables. I have a Query that runs correctly based upon the main table and the other seven tables. I have a Form that contains a Combo box based upon the four of the other tables. There is also a Command button to run a Query. From the...

I have a table that has a list of categories (tblCategory) with a key of Cat01 through Cat21. I have a second table (tblItems) for Items that can have up to 4 Categories each; Category1, 2, 3, and 4. Each Item entry in the second table has one or more keys from the first table in the...

Working with Access 2010 and need some help. I have defined and populated my tables; Team table contains an entry for every employee that works on that team and a Employee table that contains basic contact information; phone numbers and email addresses. For example: Team 1 contains 3...