Search results for query: *

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

Hi, I have combobox, cboAssetCode (used to select AssetCode) and listbox, lstAssetDetails (to display all info that relevant with the selected AssetCode). My problem is, all the AssetCode have different info. It means, each AssetCode has their own form. Any idea? This code is taken from the...

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, I have RefNo and Amount. This is sample of record, 1. A98512 1542.00 2. T54212 896.50 3. A98512 1250.00 4. C11523 672.00 5. C11523 985.00 I want to get differentiation of 2 records with the same RefNo. Let say in the report, the record is grouped by RefNo. Is it...

Hi, I have an error, "Operation must use an updatable query" when trying to update the query. Any idea? Is it possible to include sum() in the update query? any idea? thanx in advance..;)

Hi, I have table [Leave] and [LeaveDetail]. In table [Leave], i have field StaffNo and TotDays. In table [LeaveDetail], i have field StaffNo, StartDate and EndDate. Both table is linked by StaffNo. I want to update TotDays (equal to EndDate-StartDate+1). This is what i've done, UPDATE [Leave]...

Hi, I want to update table, [leave] with field carryfwd, annual and year. Every year, the data will be changed (except for annual field). My problem is to set new carryfwd value. This is because, the new carryfwd should be total(carryfwd + annual) - total(daystaken). While table, [leavedetail]...

Hi, I'm using Visual Interdev 6 on Windows XP. My problem is when running asp page connected with the database. Everytime i want to debug the asp page, this error comes out, "Unable to set server into correct debugging state automatically. You may not be able to debug asp pages. Do you want to...

Hi, I'm having problem with my company's Flash website. If there's any changes on the website, the IT people will upload the updated website. My problem is, when i open the website..it's not the updated website. But the other's pc will get the updated website. I've already delete the cookies and...