Search results

DCrake, Perfect soluction. Thanks :D

Let supose I have the following records: Car - color - performance - date Ford - Red - 100% - 01/01/2008 Ford - green - 90% - 02/01/2008 Ford - blue - 95% - 03/01/2008 Rover - Red - 90% - 04/01/2008 Rover - green - 97% - 05/01/2008 Rover - blue - 95% - 06/01/2008 I need a query to group by...

I want to group only one field and If I try to display the date without grouping it wont run the query. I need something like: SELECT fldModelName, Max(fldPercentage) AS Rank, fldDate FROM tblModels GROUP BY fldModelName ORDER BY Max(fldPercentage) DESC; but it only runs if is like that...

Thanks to your help DCrake. And if I have another field called date and I want it also displaying the date with the max(fldPercentage)? How do I do?

Hi there If i've got the following fields and values: Cars - colour - performance Ford - Red - 100% Ford - green - 90% Ford - blue - 95% Rover - Red - 90% Rover - green - 97% Rover - blue - 95% It's possible to write a query to give me the best performance by each car? ex Ford - Red - 100%...

Thank you very much. :o

Hi there I need to use Cristal report in my work but I have no idea how it works. I would like to know if it can retrieve the information direct from the SQL database or if it needs an application built as example in vb6 or vb.net? Thanks

Hi there. I built the following code to run a report: Private Sub cmdTest_Click() If Not IsNull(txtDateFrom) Or (txtDateFrom <> "") Then DataEnvironment1.Command2 txtDateFrom.Text DataReport2.Show End If End Sub When I run it displays the report strait away but if I try to run another report it...

Hi there I had the same problem in SQL2000 and I had to delete the field ID and create a new one. It may be another easy way to do that but this worked with me. I hope this helps

Hi I've got an VB6 application front end with an SQL2000 database as a back end. I need to create some reports using the datareport but I don't know how to do. Is there anyone that could tell me where to find a good tutorial online please.

Hi there Once again thanks SQL_Hell for your help. I've use an example I've found to build the following dts.execution from VB: Dim opackage As DTS.Package Set opackage = New DTS.Package opackage.LoadFromSQLServer PARS, , , DTSSQLStgFlag_UseTrustedConnection, , , , copyTxt, 0...

Thanks SQL_Hell. You are absolutely right. I would like to create a button on an VB6 application when clicked execute the saved packdge. Is this possible? Thanks again

I'm using the follwoing part of code to connect to an VB6 application to a sql 2000 server: Sconn=”Provider=SQLOLEDB.1;Trusted Connection = True; Integrated Security=SSPI;Persist Security Info=False;User ID=sa;Initial Catalog=PARS;Data Source=10.100.66.118" conn.open sconn The problem is whe...

Hi there I'm new on SQL server and I need some help. I'm building a VB6 front end with SQL 2000 as a back end. I've built my tables but the information that will be feeding them It will be received weekly on text files and then I have to export manually into the tables. I woul like to know if...

Thanks rainman89. That was perfect

hi there I've got a calendar in my access Vb application and when I click the ady I want it will input that day in a text box in the follwong format dd/mm/yyyy. Then I save this with some more information into a table. The problem is when I use the following code: count3 = DSum("[Duration]"...

Thanks guys.

Hi boblarson Thansk for your help. My first application few years ago I've done like you said, back end on one side and gave the each member a copy of the front end but I had a problem that I dint find out how to resolve. I had to manually link each front end application to the back end. On the...

My access VB applications use to be built in access 97 but recently the company updated the software and is using now access 2003. My only problem so far is: my applications built in access 97 are able to be opened by over 40 users at the same time and but the ones built in access 2003 only...

Hi there If i use a msgbox with vbOkCancel I get a box with ok button and Cancel button. Is there any code that I could have as example green instead ok and red instead cancel? Thanks in advance