Search results for query: *

I have a form (Frm_Entry) whose record source is Tbl_Main. In that table and on that form, I capture a cumulative Benefit score and a cumulative Effort score in order to conduct a brief analysis for the work we might pursue. I want to display this data as a XY Scatter chart on the form. When...

I have a Form (Form.Main) with a subform (Form.Sub) embedded in it. Here's what I would like to do. If I update a field (Status) on the subform, can I force it to update a field on the main form with an IF statement? I'm thinking: Private Sub Status_AfterUpdate() If Me.Status.Value = "Blue"...

I have a customer database that allows customers to enter requests. After a customer enters a request, I need the database to send an email to all of the technicians (whose names and emails are stored and updated in a table (tbl Technicians). I have what I believe to be similar code that sends...

I have a form (Data Entry Form) that service center individuals fill out for each service request that they receive during the day. The fields on the form include Request #, Date, Technician Assigned, etc. Here is what I need - when a new entry is populated and the form is closed, the database...

I have a stacked bar chart that is supposed to display the volume of different service request types (e.g. "Promotion Record Request" or "Travel Document Support") per month. The criteria for the underlying criteria (date range, etc.) is pulled from a "criteria form" that works great for text...

I currently have a form with a Suspense Date and a Record Entry Date. I am using the following 2 modules to subtract Now() from the Suspense Date in order to keep a timer running on remaining time available. Module 1 Option Explicit Function GetElapsedSeconds(interval) Dim totalhours As...

I have a database (of course) that tracks services requests by technicians that complete them. I want to create a stacked bar chart that displays all of the technicians and the number of completed service requests - even if the technician has not completed any. To accomplish this, I designed...

Does anyone know how to create control charts in Access 2007?

I have a form that tracks project status, and the individuals who use the form are not supposed to move from phsae 1 to phase 2 (all the way through phase 5) without approval from management. I have a checkbox for each phase (I-V) listed on the bottom of the form, and would like these to be...

I have a column chart that summarizes discrete activities across 60 organizations. At 8 font on an 8.5 x 14" piece of paper, there seems to be ample room for all values (organization names) across the x-axis. However, only every other organization is displayed. Also - when I change the font...