Search results

Hi, How can i pass Cross tab query Parameter value from Forms object, as i try to generate recordset? Following query i have written : PARAMETERS [Forms]![frmParamSummaryReport]![txtFromDate]![Value] Long; TRANSFORM Sum([Usage].[UsageValue]) AS [SumOfThe Value] SELECT [Usage].[ST_DATE]...

Hi, I write below query.. TRANSFORM Sum([Usage_Cost].[UsageValue]) AS [SumOfThe Value] SELECT [Usage_Cost].[BYM] AS BYM_Date, [Commodity].[Commodity_Id], format([Usage_Cost].[BYM],'mmm yy') AS [Month] FROM Usage_Cost, TS_US_Code, Commodity WHERE [Usage_Cost].[TS_Code]=[TS_US_Code].[TS_Code] And...

hi, I don't want to split this two table. If possible with split how to do it please explain me more detail. Thanks.

Hi, I have total 2.5 billon rows in the 'Units' table and 1 billion rows in the 'Sales' table. when i am use below query then access is hang.. strquery = "select count(*) from Sales where bym in (SELECT distinct BYM FROM Units) What is problem? It is problem with In clause or what...

Hi, I want to fill combo box at runtime. I create a Recordset and i want to bind this recordset value to combobx.

Hi, I want to set X axis labels using programmticaly. I attach here file. when u select chart and right click on that and select source data option. It will show source data window. In the Series tab it will shown Category X-axis labels. There i want put range like B2:B10. I write following...

Hi, I am using OLE Object in my Access Form. It shows me following error message. The Ole Server may not be registered. To register the OLE server, reinstall it. I open Form in the Design mode and select Insert menu, I select Object option. It is show me Object...

Hi, I am tried this function, which is u suggest but it is show Janaury for all month number like 9,10,11. But i am success to find month name using MonthName function. I found this function from msdn site. But Thanks for reply and suggestions. Once again Thanks.

Hi, How can i show Month name using below query? TRANSFORM Sum([Usage_Cost].[UsageValue]) AS [SumOfThe Value] SELECT DatePart('m',[Usage_Cost].[BYM]) AS [Month] FROM Usage_Cost WHERE [US_Code]=[Forms]![frmUsageChart]![cboCommodity] GROUP BY DatePart('m',[Usage_Cost].[BYM]) In above query...

Hi, How to bound recordsource at runtime? I do data compersion at runtime and generate recordset. now, i want to bind this recordset to report recordsoure and value to it's control like text box etc.. If any other way, please suggest me. Thanks.

Hi, I'm getting below error message on all forms "The expression On Load you entered as the event property setting produced the following error: Error accessing file. Network connection may have been lost." This error occured first time. Please help me. Thanks.

Hi, How can u please give example. Thanks for reply.

hi, It is solved? How to get month name? using query I write my query below and i want month name insted of month number. SELECT DatePart('m',[Usage_Cost].[BYM]) AS [Month1] FROM Usage_Cost WHERE [US_Code]='EL' GROUP BY DatePart('m',[Usage_Cost].[BYM]) reply me.

Hi, Thanks for reply.. But it is not work. It is work like this I create query with Parameter. It is takes parameter from my this form combo box. When i run report first time it find value in combo box. So it will display report. Now, User is select different value and press button...

Hi, That problem solved. Thanks. But one more doubt is I have one combox box, Command button and ole chart on my form. First time my form read value form combo box and passed the query which is put above. now i select second value from combo box and i click on Button the graph is...

Hi, I passed one parameter using form to query it shows me below error message. " The Microsoft Jet Database engine does not recognize [Forms]![frmUsageChart]![cboname] as a valid field name or expression" i write query as TRANSFORM Sum(Usage_Cost.UsageValue) AS [SumOfThe...

Hi, I try below code for destory object like excel application object, workbook, work sheet and adodb. Public Sub gSetNothing(ParamArray objName() As Variant) Dim i As Integer For i = LBound(objName) To UBound(objName) If IsObject(objName(i)) = True Then...

Thanks lot.

Thanks.

Hi, I use combo box in my form. I want facility like drop down box had in Visual basic. I use unbound combo box. I want to show always first value to be selected. and user cannot write in combo box. Thanks.