I am trying to developed a graph report. I use form prompt to prompt user to key in the data (dept code, month and year) so that the query will filter all the data based on user selection and produce graph.
i use the same method to produce reports(not graph/chart- I use report wizard) and it works..but when using the same method to produce graph (I use chart wizard) it gives this error.
the microsoft jet database engine does not recognize '[Forms]![FAlldeptgraphmonth]![cmbmonth1]' as a valid field name or expression.
***(the format above I used in the query)
and when I click the Ok button, another error message will appear..
'An error occured while sending data to the OLE server(the application used yo create the object)'
I have added below in my reference.
Microsoft DAO 3.6 Object Libarry,Microsoft ACtivex Data Objects 2.1 Library,Ole Automation, Visual Basic for Application, Microsoft Access 9.0 Object Library.
can anyone help?
thanks
i use the same method to produce reports(not graph/chart- I use report wizard) and it works..but when using the same method to produce graph (I use chart wizard) it gives this error.
the microsoft jet database engine does not recognize '[Forms]![FAlldeptgraphmonth]![cmbmonth1]' as a valid field name or expression.
***(the format above I used in the query)
and when I click the Ok button, another error message will appear..
'An error occured while sending data to the OLE server(the application used yo create the object)'
I have added below in my reference.
Microsoft DAO 3.6 Object Libarry,Microsoft ACtivex Data Objects 2.1 Library,Ole Automation, Visual Basic for Application, Microsoft Access 9.0 Object Library.
can anyone help?
thanks
