Recent content by Timko

Can anyone help? Im trying to create a report which will be grouped by Company and will display the Products for that company. This report needs to be on a seperate page for each Company. For example the: Header: will contain the Company information. There will be 1 report for each...

Still Confused Rich, Im sorry, but I am still confused by this. I have been through all the microsoft help and followed what it suggests, but it doesnt work. What im doing is I have a combo box containing a list of reports that the user can choose. Some crosstab, some not. So the user...

Rich, I have tried this, but then it asks me to enter the parameter value for each of the parameters when I open the report. What am I doing wrong? Timko

Can anyone help me? Im using the DoCmd.OpenReport comand with a where statement that changes depending on options chosen by the user. This works fine with normal select queries, but when I the report has a Crosstab query I get the following error message: Run-time error '3070': The Microsoft...

Im basically using a single Report in different places, by passing different parameters into the query. This is fine, but on opening the report I want to fill in a text box with the name of the report, which will change depending on where the report is called. Hope you can help with this. Tim

Hi Im sure there is a really simple answer to this, but I can't seem to get it right. All I want to do is put a text box on a report and fill it with a value when I open the report. but when I try to do it I get Runtime Error 2448, which says that it be in read only. But I can't seem to...

Thanks :) , this is exactly what i was after. Tim

Hi, I have a question that hopefully someone will be able to answer. I am just starting to write some code in Access 97 and I am trying to create a function that I can call, which returns a value depending on an integer that is given when the function is called. But I can't work out how to...