Search results for query: *

I suppose I should be thankfull - 12 months ago I had great difficult creating SQL statements/queries and today I can at least perform basic queries etc. That said I spent hours last night trying to create a query that performs the following. I have three Tables. Employees with Fields EmpID...

I have a table (Manhours) with 4 fields (ManID, VehicleID, Manhours and RptDate). I created the query (query 1) below (in Access 2000) to sum the total hours for each vehicle. It works OK in Access 2000. This query is also used by an application written in VB6 (using Crystal Reports) to create...

I am using VB6 with Crystal reports 8.5 to produce a couple of reports. Both reports use the VB Data Environment to access the Access 2000 database 'workcare.mdb' and until now I have not had any real problems. If I run the application and select cmdInjClass_click (see code below), data is...

I am using VB6 with Crystal reports 8.5 to produce a couple of reports. Both reports use the VB Data Environment to access the Access 2000 database 'workcare.mdb' and until now I have not had any real problems. If I run the application and select cmdInjClass_click (see code below), data is...

I have 2 tables: Manhours with fields: ManID, VehicleID, ManHours and RPTDate Vehicles with fields: VehicleID and Vehicle I am trying to create a query that sums the ManHours for each vehicle based on a given date range. The following query works: SELECT Sum(manhours.Manhours) AS SumYearHours...

I have an Access 2000 table with an ID, dates and other info. Eg: ID Date 1 1/1/99 2 2/1/99 3 3/1/99 1 10/6/00 2 11/6/00 2 12/6/00 I need to extract the latest date for each ID but I also need that ID as I use the dataset created in Crystal reports. My dataset should contain 1...

I am using VB6 with Crystal reports 8.5. I have a single viewer on a form and within my VB code I have multiple instantiations of reports. Eg at the start of my code I have: Dim svcClass as new rptClass ' Crystal rpt with class info Dim svcEquip as new rptEquip ' Crystal rpt with equip info...

I am using CR8.5 to create a report. I am grouping by a list a names with an ID number and using this ID number as a parameter that is entered by users. The names and ID come from a table called 'Employee'. The report works fine to this point - not much to brag about I know. Under each group I...

I have created a Crystal report (8.5) and have used group by Name, with details following. I have also checked the box that forces a page break before each group, this allows each persons details to be displayed/printed on a separate page. I would like to be able to perform the initial report...

Until now I have been using DAO to manipulate data in an Access 2000 database with VB6. Had a few problems with Windows2000 installation so I decided I should move on to ADO. My DAO base program used a Module (.BAS) to publically open the database connection and declare recordsets that were...

I developed a VB6 application on a windows 98SE workstation using DAO 3.6 connecting to Access database. Worked fine on the workstation during development. I then created a package and installed on a clean build windows 2000 workstation. Again worked fine (except I did receive a message during...

I have a listview (lvVehicles) and when a line in the listview is selected (clicked) I change the forecolor of the text in the selected line. When I initially load the listview my last line in the sub is: lvvehicles.selecteditem = lvVehilces.Listitems(1) ie select the first line. BUT this does...

What am I doing wrong? I used CR 8.5 to create a report. I used the data explorer to connect to an Access database (.mdb) via the Database Files option in Data Explorer. Within CR the report works fine. I then saved it as medical.rpt In VB 6, I used the following code if the frmReports form...

I am using a Data environment to connect to an access database. The database environment looks very similar to the Universal DataLink (UDL). When I set up the Data environment at design time I select a .mdb and during all testing everything works fine. When I compile the application and...

I have asked the question in Crystal Data Access forum of how to pass a parameter from VB to a Crystal report that is embedded in VB (ie dsr). It does not look as though anyone is familiar with the way of doing this and my requirement is now urgent. In summary I have a sub report that is...

As an relatively competent user of VB I was using the inbuilt capability of VB to create reports until I realised that VB was very limited. Solution - Crystal Reports, which is VERY versatile. Initially I was given some guidance on how to create reports save them as .rpt format and then use in...

I am using a report loaded in VB as a .dsr. I have successfully used SQL queries within VB to populate the personal particulars fields on the report form. Each persons record is referenced by the database field Employee.EmployID. I also have a subreport on the report in Details a (Section 5)...

I initially created a report and then with VB6 used it in its native state (testreport.rpt) - this worked fine. I have now used this report which obtains its information from an Access database, by selecting with VB - projects/Crystal Reports 8.5. This has allowed me to use the report as a dsr...

I am using groups to display specific records but there are some records that are not in any group. These records just appear without any "Group Name" at the top of the report. Is it possible to stop these from appearing? If so can you please advise me how I go about doing it. I am...

I am a new user to Crystal and am trying to come to grips with the formula side of things. I have a database field that contains a date being presented in a report. I know it should not be too difficult but how do I change the color of the report entry from black to red if the date is after...