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

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'."...

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