Search results

I mean, if you type the data labels in a chart manually e.g. 'label1 (value1)' and the values change, the value 'value1' remains value1 and does not change. Is there a possibility to do it?

Hello, I would like to design the data labels in my chart individually. For optical reasons it is good to design it like: 'label (value)'. I know the data label can typed manually, but it is not updated in that case. How can it be designed with automatical update? Thank you for your help.

Hello, I would like to make a chart with the Chart Wizard. I follow the instructions step by step and the chart appears in the Print Preview. but when I change do Design View, there is not my chart shown but a 'Microsoft Graph 2000 Chart'. That name is in the OLE class property. Changed back to...

Thanks for your advice. It works now.

Hello, I changed the syntax to: =DCount("[Date]","Query1","[Date] Between [Query]![Query1]![Parameter Date: beginning] And [Query]![Query1]![Parameter Date: End]") But it does not work...

Hello, I have some problems with a statement of a DCount function. My statement: =DCount("[Date]","Query1","[Date] Between [Parameter Date: beginning] And [Parameter Date: End]") Whereas 'Query1' is the basic for the report. Query1 depends on two parameters: [Parameter Date: beginning] and...

Actually, they are hand typed. How can I do it with a reference?

Thanks MStef, but unfortunately I do not understand, what you mean. Neither can I understand, how the number of records can be counted in the example database. By the way, the query I would like to count the records in is not the query the data for the form comes from. Could you please explain...

Hello, I would like to insert a DCount function in an unbound textbox in a form to count all records in a query. My current code in the textbox is: '=DCount("*","Query1")'. The Query 'Query1' depends on two parameters, which has to be entered before opening the query. The result is '#Error', if...

Thanks, great help.

Hello, I would like to use the FindRecord Method, but something does not work. I would like to find a record which contains the data I entered in an unbound textbox in the form. The action should be started by a command button. As 'Find what'-object I used '=[text61].[text]. Thanks for your help.