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

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.

Hi, Any site or tutorial for generate chart in msaccess or excel using ms access. bcz I want to generate chart which are very complicated. Thanks.

Hi, I use adodb. I try to read data from one table and add into another table. I create two recordset. now i use do while loop till eof and read data but last row cannot be insert in the table. my code is: do while not rsTestUser.eof rsTest.addnew...

Dataentry form Hi, If u help me to create data entery form with Add,Edit,Delete and Save button. If any example it will help me lot. Thanks.

Hi, Please find attachment file and i want generate report in that format. I use two different table for Cost and consumption column in report. I want to find out summrize data for current month, last month and last year and also current year. There is Date column in both the table...

Hi, Using ADO how can i open access connection and handled transction in that code. I use below string but it will give me error message while i'm commit or rollback trans. CurrentProject.Connection.BeginTrans rsCosts.Open "select * from Costs", CurrentProject.Connection...

Hi, I have two table in Test.MDB. First table name is Master and second table is MasterDetail. I want to copy all Master table row in to the MasterDetail table. It's like when user click on Transfer button it should start row transfer from one table to second table. How i do this task. Thanks.

Hi, I want to export data from One Test.mdb access file to another Original.MDB access file using form. I show form with one button and button name is Export when user click on it. I want to start exporting data form Test.MDB to Original.MDB file. How can i accomplish this task. Thanks.

Hi, I want generate summrize report with current month and previous month compersion. I take current month data as parameter. but how can i calculate previous month using this parameter in query? or i might be go wrong way.please help me how can i generate summerize report for current month...