Recent content by swills

Sorry i should have explained it better, basically the 3 combo boxes need to be correct for the report to display properly. so for example is release 3.4.2.1 is selected then only certain databases can be selected etc If they do not match then a report is shown but it is just empty. is there a...

Hi all, this is probably quite simple but im a having a mind block doing this. I have a form with 3 combo boxes in and depending on these selections a report is shown with a graph on it. this works fine. However if these selctions are wrong i want an error message to be shown and the report...

Hi all, I have a graph that is shown on one of my reports and i was wondering if there is any way to add vertical gridlines to the report? Thanks in advance

Thanks alot Gemma, ive got it working, really appreciate your help

yeah sorry, forgot i had raised it.

sorry im a bit of a noob sometimes. basically have a diff label for each combo box? then in the reportopen event label.caption = cboRelease is that what you mean? also the reportopen event where should that be? in the report class object? thanks for ur help

Hi all, I have a form when i start my db and depending on the options selected in the combo boxes on this form, a chart is shown on a report. Is it possible to include the selections made in these combo boxes in the report title? if so, how would i go about this, thanks in advance

Hi all, I have a form when i start my db and depending on the options selected in the combo boxes on this form, a chart is shown on a report. Is it possible to include the selections made in these combo boxes in the report title? if so, how would i go about this, thanks in advance

Cheers colby you have been a fantastic help, thanks alot. couldnt have got this far without u

i think you may have hit the nail on the head here. is it possible to hide the column with the heading <> in qryMemAll? also what is this showing just out of interest? cheers also i really need to get the fields shown as they are in the table and not in alphabetical order if thats possible. cheers

very close :) just the last point, i will literally only need the crosstab query to be shown, i will create the report seperately you know how to do it?

Cheers colby, your help is much appreciated. basically i created the crosstab query to query the results of tblmem and tbdetails and output them in a way that would allow me to create a chart on a report. i had this all working fine with no problems. my manager then requested that i set up a...

HI all, In my database i have a crosstab query that has a text field as a row heading and a number field as a column heading. The query is sorting the row heading on the left hand side alphabetically. I dont want it to do this, i want it to show the fields as they are in the table. Is there...

no, at the moment the sort fields are empty cheers

HI all, In my database i have a crosstab query that has a text field as a row heading and a number field as a column heading. The query is sorting the row heading on the left hand side alphabetically. I dont want it to do this, i want it to show the fields as they are in the table. Is there...