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

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

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

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

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

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

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

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

I have a Calendar Type Report with the date down the left hand side, I hide duplicate dates. When I have a date change I would like to have a line going across the report. How do I do this please. Thanks Chris

Does anybody, know how to stop users, being able to use the internet from the My Computer Address bar? I can disable Internet Explorer but, the ability to type a url in the "My Computer" bar is still possible. Any idea's would be great!!!!

I have a mailbox, which I need to share between 3 Recipients. I am unsure of what permissions I need to allow them all to have access and create sub-folders, within the mail-box. Do I need to have the mailbox assigned to particular recipient? Or can I leave it blank (as it currently is)? The...

Hi All, I work in a school and I am trying to merge student details into a word document. The name, address etc is not a problem but I need to merge a details section which contains student subject choices. How do I do this? Thanks Chris

Hi All, I am running an append query and in that query there is a calulation. The answer could come out as 6.597489 - this figure is appended into a field in a temporary table that is numeric, fixed, with Decimal Places of 1. The problem I am having is that in the temporary table the figure...

Hi All, I have just entered the brave new world of MDX and OLAP. Can a measure be a Letter or does it always have to be numeric. I work in a school and I need to show grades in the cells/measures as opposed to numbers. Thanks for you help Chris