Search results

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

Hi colby, thanks again for your help. i think we are nearly there, if you are ok to continue helping me i will give you a bit more background to the reason why i am doing this. Basically the database is a repository from an automated test program. The data you see is automaticallly placed in...

Ok the db is attached, no important info is attached as teh data is made up while i am setting the db up cheers colby, your help is much appreciated i finish work in 10 mins so i will get your reply 2moro

ok ive done that but now im getting a type mismatch again, to stop getting the type mismatch i have to remove the ("qryMemAll") from the following line of code: Set qdf = db.QueryDefs("qryMemAll") the code now reads: Dim db As DAO.Database Dim qdf As DAO.QueryDefs Dim strSQL As String...

just to confirm i am back to the following problem as detailed above: My main problem now is the fact that it errors when it reaches a certain line in teh code: qdf.SQL = strSQL The error i get is: compile error method or data member not found the .SQL part of the code is highlighted after...

hi again, i managed to sort that, i simply put [] round the field names in SQL view. So now this query works when used as a query alone. just a case of getting it working in VBA now. any ideas? cheers for help so far