Recent content by gazza11

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

Many thanks again Parm. I have been trying different ways of obtaining the data and I ended up with the code being quite different from that above. Following your reply above - I returned all the code to original (ready to bundle for you) and ran. You would not believe it - it worked OK. All I...

Thanks parm Tried you suggestion but still no luck. I have been trying also to use the DataEnvironment connection before I go using the rsado connection. What I mean is that the Dataenvironment has a connection to the access database via a query, however this query is never used. I seem to be...

Appears no one can help me. I suspected this would be a tough one. I have spent some time looking at my problem and it appears that if I use the VB Datareport to do the reporting under cmd InjClass_Click. All is OK so it looks like Crystal does not like using the Data report + runtime...

The data environment is a VB6 ActiveX designer (see under Project/More ActiveX Designers) that allows you to connect to the database specifically for reporting etc. In VB6 you can also add a Data Report that uses the data presented by the Data Environment to create reports. Instead of using MS...

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

Worked a treat - it looked to me like there were too many brackets in my query - but that is what the SQL designer created after I used the wizard. Thanks.

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

Many thanks Gary

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

Hi - I am also trying to change a CR8.5 subreport database during runtime. I have looked everywhere and this thread is about the closest I have come to seeing anything that helps. I am using a CR with a main report and one sub report. In VB6 my code is: Set cn = new ADODB.Connection Set rsADO...

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

Have tried using the EMPID from the main table (ie that table with Names) without a subreport and it seems to work reliably except I now get blank lines if the criteria is not met. I am trying to get format as below: Name Elect LicNo Expires First Aid No Expires Joe XY123...