Search results

Turned out to be a permissions problem between folders.

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...

Rain, My tables were already created, I created a query pulling information from four tables. Created a Form based on the query and aded the cascading cbo boxed. When I selected the first cbo box it populated the second cbo box correctly. When I made a selection from the second cbo box and...

Rain, I found my problem with the cascading combo boxes; I left out the “Dim strSource As String” statement in the After Update Event Procedure. Event Procedure follows: Private Sub cboGroup_AfterUpdate() Dim strSource As String strSource = "SELECT DISTINCT Employee " & _...

I'm going to need some help. Give me some time to document what I have and have done befor I reply again. Thanks

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?

Thanks everyone, finally got back to trying and it is now working.

I believe I'm misleading everyone with the "I need the ability to select from either Combo box leaving the other blank." This is working. What I need is a way to limit the results of what is returned after selecting Faculty in Combo0. Instead of returning just the Faculty entries, it returns...

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...

:DThank You, it worked.

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...

Thank you, it works, and I really appreciate the help.

Thank you Paul for the quick reply. Took a look at the link that you provided and tried different methods with no luck. I have built a test database using data from the original and; created the tables with relationships; created Query1, created Report1 using Query1. Created a Form1 with a...

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...