Recent content by naina

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.