Search results

Hello! I have a query that lists the roles that staff play on each project. In many cases staff played more than one role on a project, so staff names appear multiple times. I.e.: Row 1 - Name: Sue Smith - Role: Editor - Project: CC1 Row 2 - Name: Sue Smith - Role: Analyst - Project CC1 Row 3 -...

Hello! I have two tables that I want to link together. One table lists staff and the trainings that they've taken. The other lists projects and the roles that each staff person played. I want to be able to query a person's name and see their trainings, projects, and roles. The only problem is...

Hello Everyone! I have an excel spreadsheet that I have imported in access. The spreadsheet has a column that lists project title and then 6 staff titles (project manager, admin asst, etc). I'm trying to create a query (or maybe it should be a report) that shows the projects and titles that...

I have a drop down field on a form that lists staff positions. For this position I also lists the persons name in another field. On a report I've listed the staff positions (i.e.): a. accountant Name: b. doctor Name: c. lawyer Name: I'm trying to write an if statement that pulls the...

Hello All, I want to create a 5-page report in Access. My first question is there anyway to do this in one report? I tried and it won't go any longer than 22". I have 37 cities that I am collecting information on but I want to generate a report (including each of the 5 pages) for each city, is...

Hello, I'm creating a form with 8 tabs (with somewhat long titles) and I can't get the tabs to stack on top of each other instead of just going straight across...thus increasing the length of my form. I know it's probably something simple, but I can't figure it out. :confused:

Hi I have written a code for a field to become visible (it's set to invisible in the properties of the field) if it meets a certain requirement: Private Sub Domain_AfterUpdate() If Domain = "Partnerships for Systems Change and Policy Development" Then Partners_Label.Visible = True...

Hello all! I'm working on creating 3 combo drop downs (cascading). I can get combo3 to work based on what's selected in combo1 but I want it to be based on whats selected in combo1 AND combo2. I'm currently using this coding to make the combo3 work: Private Sub Program_Component_AfterUpdate()...