Recent content by ragu111

Printer driver installed in Client's machine. i need to know how to map printer..

We have an application in FoxPro. one of our remote office have access to this application through Ctrix MetaFrame. the application is working fine. But the problem is the client from repote office cant take print. the server is not getting the client's printer (Epson LQ2170). i'm new to Ctrix...

i have a cross tab query like below item 2001 2002 2003 2004 2005 2006 ----------------------------------------- item1 500 500 500 500 500 350 item2 300 400 400 400 400 item3 150 200 200 200 ----------------------------------------- if i give a date...

Good, fineally you helped me on this. i mention "Total" on the ID column where it got Numbers. so the Total Row came on the last row. Thanks again.

IN MY SUBFORM I PUT BELOW CODE: Private Sub Amount_AfterUpdate() If Me.C_Code = "c" And Me.Cost = 0 Then Me.Cost = Me.Amount Me.C_ACODE = [Forms].[CusMaster].[Customs_Code].Column(2) Else Me.Cost = Me.Cost End If End Sub on the subform "C_ACODE" field i wanted to call the value from...

Anybody can help on this..?? ragu[pc]

Try to place below code on the DateTime fields BeforeUpdate Event Private Sub Date_BeforeUpdate(Cancel As Integer) Dim MyDb As Database Dim MySet As Recordset Dim SQLStg As String Set MyDb = CurrentDb SQLStg = "SELECT Count(EmployeeID) AS CountOfempID, UserName, Date" SQLStg = SQLStg & "FROM...

Dear PHV here i'm coming with one more help if [Purchase Price] = 50000 and [Depreciable Life] = 5 then per month [Depreciable Value] updates as 833.333333 i made a CrossTab Query by year which shows a amount of 9999.99 and the ColumnTotal 49999.99 which should be 10000 per year and the...

i feel there is a misunderstang the above code give the Row_Total in a speprate column. what i need is a single columns total to appear end of the column year 2005 2006 100 150 200 250 300 200 total600 500

Here is my SQL TRANSFORM Sum([Assets Query].Dep_Value) AS SumOfDep_Value SELECT [Assets Query].Company_Name, [Assets Query].Department_Name, [Assets Query].Asset_Cat_Code FROM [Assets Query] GROUP BY [Assets Query].Company_Name, [Assets Query].Department_Name, [Assets Query].Asset_Cat_Code...

i have a CrossTab Query. i want to have the Column Total for every record. how can i make a column total in access query. Ragu [pc]

where will i put this code?

dear Remou request you to give little more explanation how to build the SQL string and add it to the query thanks ragu[pc]

My Multi selection is working fine, but my SQL is not working with the selection. mySQL SELECT Assets.AssetID, Assets.Model, Assets.Asset_Cat_Code FROM Assets WHERE (((Assets.Asset_Cat_Code) In ([forms].[Report].[Text28]))); ------------------------------------------------------ My Code to...

Dear PHV one more change require... if the [Date of Purchase] = 09/04/2005 (09-apr-05) [date]should be: 09/04/2005 09/05/2005 09/06/2005 09/07/2005 09/08/2005 ...... ...... the starting(first) date whould be 09/04/2005 instead of 09/05/2005 Ragu[pc]