Search results

In our Company which is comprised of 15 Departments and each Department has an Executive. We manage a number of issues and each issue has at least 1 but up to 5 Executives assigned to it depending upon each Executive's level of involvement (from Primary to 5th level). Every month we report on...

In the Executive table, there are 15 Execs/Dept. In the "issues" table there are 5 fields for Executives to possibly occupy depending upon their Department's level of involvement in the issue. All 5 have to be included in all reports to each of the 5 departments. There is only one report based...

Thanks. I'll try something like that. Ideally, I was looking, for a way to assign the 15 department Executives to the tempvars by using a do while not EOF structure or something similar. My idea is to get the tempvars refreshed each time the application starts which will then feed into...

The database tracks issues to put it simply. It tracks hundreds of issues. Up to 5 departments or Executives could have a primary, secondary, tertiary.....responsibility on each issue. While departments don't change, Executives do. I have hundreds or queries and reports that filter on the...

there are lots of tables and lots of queries, reports and forms. I'll try changing the references to the indexes rather than the names and maybe that simply takes care of it....

I was trying to keep it simple. It is a table with two fields: Department and Executive. I have many queries that use the Executive field's name as filtering criteria for reports. Executives change frequently, so I was looking for a way to dynamically update the queries by changing them from...

I have a table in my access 2010 application that lists Departments and Executives (for simplicity sake). I use the Executives in many queries throughout the application; however, Executives come and go frequently causing significant changes to my queries. I was thinking about setting up...

Thank you for your responses. I still can not get it to generate a report. It asks for [Business Unit Long] and then it pops up a query asking for one of the Business units that it is apparently finding. Once you click away the two parameter boxes, the report says no records found. I...

So, here's where I'm at. I have a form called frmNewMOR that you can enter the report title [txtTitle] and report date [txtDate]. These fields are passed to the end Report named "RptNewMOR". The form also has a subform named "qrysubRespExec" which is a form that lists Business Lines and...

One of the objectives of this program is to use one query and one report form. As I was reading older posts on this notion of running a series of reports, I noticed one post where a field was added to a table to designate selected ("Yes or No"). In this fashion a variable list of reports may...

Yes, I am comfortable with VB code. I just couldn't figure out how to do what I'm describing efficiently. Your help is greatly appreciated.

Every month, I create 15 individual reports with each report filtered by two fields, let's say Dept and Exec. You change Dept and Exec via a combo box drop down based on a table, and this information is passed to the query behind the report. Now, I repeat this process for every report. I use...