Search results for query: *

Hi Duane.. thanx again for reply..:) it's still not working..hmm...i've done exactly as u said..but still no luck..:( any idea? thanx in advance..;)

Hi Duane, thanx for reply..;) it's not working..it displayed as #Name? if i check on the query, the [Enter Year] is equal to Expr1..and i've included the Expr1 on the Row Source of the chart and changed the statement into this, ="Vehicle Summary For the Year - " & [Expr1] but it still not...

Hi Duane, Thanx for reply again..;) Now my problem is to display [year] on the chart header. Let say if i want to view chart for year 2003, the header will be like this, "Vehicle Summary For Year - 2003" My problem is to display the 2003. I've put textbox and set the Control Source as =[YEAR]...

Hi Duane, thanx for reply, the above code is in the Row Source of the chart.. the code is taken from this query, SELECT Sum(tblVehicle.AMOUNT) AS SumOfAMOUNT, Format ([RepairDate],'mmm yyyy') AS [MONTH] FROM tblVehicle WHERE (((Year([RepairDate]))=[ENTER YEAR])) GROUP BY...

Hi, I'm having problem with displaying a [Year] parameter value on the chart header. This is the Row Source of the chart, SELECT [MONTH],Sum([SumOfAMOUNT]) AS [SumOfSumOfAMOUNT] FROM [qryVehicle] GROUP BY [MONTH]; Any idea? thanx in advance..;)

Hi, I have 3 textboxes, datagrid and button. What i want to do is, when i enter data into the textboxes and click on the button, it will goes directly to the datagrid. Is there any sample? any idea? thanx in advance..;)

Hi, I want to display no of staff with date on the chart. This is the sample of data, NoStaff(Y) Date(X) 2 03/01/2004 1 08/01/2004 3 12/02/2004 1 23/02/2004 6 09/03/2004 2 12/03/2004 4 19/03/2004 But when...

...FROM tblVehicle" strWhere = "WHERE" strOrder = "ORDER BY ID;" If Not IsNull(Me.cboCategory) Then strWhere = strWhere & " (Category) Like '*" & Me.cboCategory & "*' AND" End If strWhere = Mid(strWhere, 1, Len(strWhere) - 5) Me.lstVehicleInfo.RowSource = strSQL & " " &...

Hi, i have combo box in datagrid to display an item n textbox for price. My problem is, is it possible when i select any item on the combo box, the price will be displayed automatically? Any idea? Thanx in advance..;)

hI, Thanx for reply..;).. The code is work if only all the VehicleNo in the record is same. What if i have more than 1 VehicleNo? As for example, VehicleNo StaffNo ReceiveDate WFF9949 50424 08/05/2003 BFF9877 53200 06/01/2003 WFF9949 80690 12/09/2003 ACD5140...

Hi, I have Datacombo(cbofields(0)) and Datagrid (grdDataGrid) on the form. What i'm trying to do is when i select item on the datacombo, only the relevant record will be displayed on the datagrid. By default, the datagrid will display all the records. This code is taken from the sample database...

Hi, I have a problem with displaying only the latest record. This is what i've done, SELECT VehicleNo, StaffNo, Max(ReceiveDate) FROM tblMain GROUP BY VehicleNo, StaffNo; This is the sample of data, VehicleNo StaffNo ReceiveDate WFF9949 50424 08/05/2003 WFF9949 80690...

...a Currency format. The value is taken from the datagrid. This is what i've done.. Set rsgtot = New ADODB.Recordset rsgtot.Open "SELECT Sum (price * pt) AS [GrandTotal] FROM [Order Details] where SN=" & "'" & txtFields (0).Text & "'" & "group by SN", db...

...will show list of food. If i select FoodName..the Price should appear automatically. And i need to enter the Quantity and the value of (Price * Quantity) will be stored in SubTotal. My problem is, i can select the FoodName and enter the number of Quantity. But i can't view the Price and...

Hi, I'm having problem with the navigation button (to display no. of record) on the bottom of data report. It disappear. Any idea? Thanx in advance..;)

...= "ORDER BY tblHardware.ID;" If Not IsNull(Me.cboAssetCode) Then strWhere = strWhere & " (tblHardware.AssetCode) Like '*" & Me.cboAssetCode & "*' AND" End If strWhere = Mid(strWhere, 1, Len(strWhere) - 5) Me.lstAssetDetails.RowSource = strSQL & " " & strWhere...

Hi, I'm getting problem with connecting Flash and SQL Server with ASP. Most of the articles or samples on the Net is using Access not SQL Server. Anybody can give me some example or any link so that i can study on myself? Can you help me? Thanx in advance..;)

Hi, I have Code, RefNo and Amount. Code has value (HS, HOSPSP, HOSPIR, HOSPCH). I've set the criteria on Code like this, In("HS","HOSPIR"). My problem is to display record for HS and HOSPIR(only with the same RefNo with HS). It is because..there are some HOSPIR with the same RefNo as HOSPSP and...

Hi, I have RefNo, StaffName and Amount. I've created RefNo header and footer on the report. RefNo will be on the RefNo Header, while StaffName and Amount on the Detail and differentiation of Amount on the RefNo Footer. My problem is to get total of the differentiation on the Report Footer. This...

Hi all, Sorry for late reply..;) I've tested the DSum function and it works..;) thanx again for the reply..