Search results

I have a pie chart that is based on IIF statements. I want specfic colours for each sector. However, because it is based on IIF, not all the sections are there each time the report is produced. Any hints on how to do this. I have tried setting the colour of the pie chart to manual instead of...

In a combo box, [Forms]![frmMonthlyReport].[ComobBranch] it is used to select the criteria for a query. There are seven to choose from each used for a report. Currently, the user has to select each item from the combo box then open to report. Now, I need to be able to select 'all' from the...

I've a database that logs arrivals of documents at work. Documents get forwarded to other section of the Division. I already got a query that selects the documents forward in a particular month. (called qrymonthlyarrivals) Now I need to count the ones that are forwarded to people within the...

Hi, My report calls a query with criterias in a form eg [Forms]![fmrMonthlyReports]![ComboBranch] When the form closes, the information on the report disappears. Is there any way of stopping this, like passing the parameters of the forms to some temp variable then to the query?

I am trying to convert Month numbers to words eg. 1 -> January, 4 -> April but i cant get it working.... I've looked at some examples involving converting currency into words but havnt got me anywhere here's my code for the module MonthNum2Word(int) Option Compare Database Option Explicit...

For a query, I have to criteria points to a Form [Forms]![fmrMonthlyReports]![ComboMonth] which is a combo box (Value List: 1;2;3;4;5....12) In the report that calls that query, i have a label that displays this criteria =[Forms]![fmrMonthlyReports]![ComboMonth] When the form closes, the...