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

finally got it working... thank you all ListO: I tried some debugging tools but none of them did wot I wanted. The problem is, I havnt had any training in VB and no idea how it works in Access. I know Ada/Java/C/C++ but not VB. :D I borrowed this book off my colleague Viescas, John, Running...

This is wot i have in my form module Option Compare Database Option Explicit Public pPublicStringName1 As String Private Sub CmdBranchPerf_Click() On Error GoTo Err_CmdBranchPerf_Click Dim stDocName As String pPublicStringName1 = "Monthly" stDocName =...

Works great... thanx

I was planning to use in a query, but the manager decided to changed things around. Still cant get it to work. But shouldnt be far off. Where to i declare the global variable? Private Sub Report_Open(Cancel As Integer) pPublicStringName = "Monthly" Me.LabelRptType.Caption = pPublicStringName...

I tried the method above to create a module named gGlblStringName: Option Compare Database Option Explicit Public pPubStringName As String Public Function gGlblStringName() As String gGlblStringName = pPubStringName End Function Instead of using it in a query, i tried to use it in a form...

Thanks for the quick reply, The combo box that I currently use is for selecting a criteria on a query which is called by ONE report. I need to call that one report seven times, each selecting a different item in the box. I wanted to select an "All" from the box so I dont have to select the 7...

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

And how can i do that? I'm not very familar with VBA. my guess is In on_click field, select Code expression then have something like A string = [Forms]![fmrMonthlyReports].[comboMonth] but what will i put in the query criteria?

Thank you very much.... although it should be ON instead on Where at the join

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?

Thanx for your response. But i get a run-time error with that code. Private Sub Report_Open(Cancel As Integer) Me.txtMonth.Caption =[Forms]![fmrMonthlyReports]![ComboMonth] End Sub the label is unbounded called txtMonth I'm a bit of a newbie with access. Another question: My report also...

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