Recent content by awinnn

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

Hi, I have combobox (cboCategory), listbox (lstVehicleInfo) and textbox (txtTotal). When i select any item on the combobox, it will display the relevant category on the listbox. It works except for displaying the no. of records on the txtTotal. Private Sub cboCategory_AfterUpdate() Dim...

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

Hi, I'm having problem to display the grand total as 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...

Hi, I have combobox on datagrid in the form. In the datagrid, i have FoodName, Price, Quantity and SubTotal. The combobox 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...

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