Search results

I have a parameter form to populate the report, report control source "Stored procedure", Form has 3 control and one click event as well as as Set on form’s AND Report's Input parameter property is...

Hi every one I solved this problem ! Here is the Modified query, But I'm not sure is it a good logic what I'm applying on this Query ? Would you anyone suggest me . . . CREATE Procedure dbo.GetHDCBillGrs AS SET NOCOUNT ON BEGIN DECLARE @HGrs float SET...

Hi I want to Filter ComboBox underlying value based on TxtBox Date value, that's why I'm trying to write this logic but error shows: run time error: '6' overflow Private Sub TxtTokenDate_AfterUpdate() Dim iToken As String iToken = "Select Token From HDC_BillparT" & _ "Where tokendate=" &...

Hi everyone, here is my Sp of A2003 Project to calculate the gross amount but does not return the desired result First I wrote the sp in this way.. CREATE Procedure dbo.GetHDCBillGrs AS SET NOCOUNT ON BEGIN DECLARE @HGrs float SET @HGrs=(Select isnull(Sum(HDC_BillChildT.Codeamount),0) From...

Hi I'm trying to write VBA code for returning Sp(non parameter) result on form's textControl field but it shows the code rather than result. my sp is tested via Query analyzer Would you someone advise me what's wrong with this code (Application Based On A2003 adp With Sql2000 Server)...

Dear khalid I Definitely mention whatever System I use Here is My Old Post of Current Thread <<<<<<<<<<<<< same error when run this in Sql SELECT Format([AuditID],"00000") As AuditNum FROM AuditTrailT Note: My Application is Based on A2003 ADP & Sql 2000 Server. >>>>>> And I've not changed...

Dear Khalid You are 100% Right. but My Application is based on A2003 adp with Sql 2000 Server. that's why I can Easily use Sql Data type <<<<<<Naina>>>>>>>>

Hi, at last I got the solution, Here is the Query SELECT RIGHT('00000' + CONVERT(varchar(5), [auditid]), 5) as AuditNum FROM AuditTrailT And thanks to Every one <<<<<<<Naina>>>>>>>>>>

Would you please give an example of query level formatting for this context

Hi Thanks to Everyone for excellent co-operation. And one more question for vbaInet regarding the above Quote is it a limitation of MSAccess or SQL ?

thanks Khalid Problem is not changing table field value . Table field is auto number it will generate 1 2 3 4 ... or if I Use Format 0000 then it will generate 00001 00002 00003 ..No problem With this but I would like to get the value as 00001 not 1 via select Query which is used for...

Thanks vbaInet It turns the Table filed Value 00001 00002 .. But problem is When I Run the Sql Query to get this value it shows '1' not '00001' Select Query SELECT AuditID As AuditNum FROM AuditTrailT

thanks vbaInet But how to do this would you please ...

same error when run this in Sql SELECT Format([AuditID],"00000") As AuditNum FROM AuditTrailT Note: My Application is Based on A2003 ADP & Sql 2000 Server.

Thanks Dk When I run this select Format([AuditID],00000) from AuditTrailT en error msg shows 'Format' is not a recognized function name.

hi, I've a Table with auto number field[auditid] , it generate 1 2 3 .. Now, I'd like to represent 00001 00002 00003 instead of 1 2 3 as a output result. that's why I'm trying this select right(str("0000" & [auditid]),4) from AuditTrailT Result shows "Invalid column name '0000'."...

Thank You Very Much

Hi Every one, I have a 3 combo field. these are CboLegal (Combo#1), CboEcoCode(Combo#2) & CboFunOpCode(Combo#3). Combo#2 is dependent of Combo#1 AND Combo#3 is dependent of Combo#2, Problem is record not populated on combo#2 and Combo#3, I would attach table structure and Combo Property. Would...

Hi Here is my SP Where you can find your answer ,perhaps. You can turn onto Function easily ******************* CREATE PROCEDURE DBO.CodeBalance @FiscalYear AS INT, @Itemcode AS INT AS SET NOCOUNT ON --SET ANSI_NULLS ON --SET QUOTED_IDENTIFIER ON BEGIN...