Search results for query: *

I have created a report on a VB form with an Export Option. The problem I have is that when I get the export dialog, I only get 4 options - PDF, XLS, DOC and RTF. I was under the impression I should get :- Crystal rpt Adobe pdf Excel 97-2000 Excel 92-200 Word Doc Word Editable RTF Rich Text...

Thanks. I missed a line of code above ParameterField.PromptText & Chr(13). Once again Many Thanks

I I am going through the David McAmis - Crystal Reports XI for Developers book and I am upto Ch9 - Integrating Reports into Windows Applications. Specifically "ParameterField.Name" which is in the bottom line of this code. VB tells me that it is not a member of...

Thanks for the reply, I am sorry but it is the & before the Chr(13) that is the problem. Chris

Hi, I have the following code:- ParameterField.PromptText & Chr(13) DisplayText = DisplayText & "Report Name: " & ParameterField.ReportName & Chr(13) DisplayText = DisplayText & "Has Current Value: " & ParameterField.HasCurrentValue &...

Thanks for the reply PHV. But where would I actually put this on my form. Thanks Chris

As the title says is it possible to have the Column Names appear vertical. eg C H R I S as opposed to CHRIS Thanks

It would but they need to know the grade. Chris

Thanks for the reply SNYPER. I could get that to work but there would be too many options in the case statement and it would turn out quite messy. Thanks anyway. Chris

I have an application that tracks student grades. The students do a benchmark test so that we can measure there progress during assessments, this is then measured against there current assessment and that assessment grade is colour coded depending it is up/down or on target against there...

Thanks for the Reply Crowley. At present I do what you say in the last paragraph but it is becoming a pain in the arse to keep track of all the Queries from various reports - so that is why I am looking for a bit more organised way. Thanks Chris

I have reports that can be run from a number of Forms and I dont know which is the best way to feed the data to the reports. The criteria can also change based up on which field the user wants to report on. Hopefully someone can give me some advice on the best way to do it. Should I :- 1)...

Hi all, I want to run an append query from VBA and attach a criteria. A: Is this possible B: If it is how do you do it. C: If it isnt is there a workaround. Thanks Chris

I have an application that is split into a front end and a backend on my laptop. I have all the necessary rights both at disk level and workgroup level as well as having shared access to the DB's. Everytime I try to either copy or re design a form or report(Tables and Queries or fine) - I get...

Tried all of those fellas and it just dowsnt show up. Ill try and explain it a little better I have a main form - which includes a dfetail line - in the footer of that form it adds one of the fields that is in the detail how I want it. Also in the footer I have a sub form - on that subform...

I have a field called txtSubjectsTotal in the FOOTER of a form called frmXCurricularStudentFeedback. I am trying to add the contents of that field to another field in the footer of a subform. All I get is the total in the subform field - any help appreciated. Thanks Chris

Thanks for the replies folks. I have decided to go with obli's solution. I do have a problem with it though. I am sorting on 2 fields - StudentName and Effor. The student name works fine but I get a runtime 2001 on Effort Button - You cancelled previous operation. Below is the code that I...

I have a subform that I want to sort both in ascending and descending order. It can be sorted on any one of 4 fields. The subform has a query bound to it. I presumably have 4 toggle buttons. This may be a bit vague but can someone help me with the code to do it. Thaks

As the title says how do you do crosstabs - Can you do crosstab Queries. Thanks Chris

Hi All, I have an unbound mdb and I pull data down to a local table from an SQL 2000 Server - Set out below is how I do it. At the moment the I only pass one parameter which is & Forms!frmCurrentUserDetails!txtCalendarYrID & "'", _ I now want to pass the pass thru query 2 parameters but i...