yes Ecoid is a autonumber field. would you please Suggest me about this code.
Code:
Valid = " Exec dbo.CheckBalance " & Me.CboEconomic & ", " & Me.tXtHDC_Bal & "," & Me.TxtCodeAmount
sknaina
Last Activity: Jun 13 '10, 02:21 PM
Joined: Mar 3 '10
Location:
-
Hi ,Thanks for your reply
yes Ecoid is a autonumber field. would you please Suggest me about this code.
is it a correct syntax for holding the variable value.... -
run time Error : type mismatch
My project is based on a2003adp with sql2000 srv.
Over there i want to control input validity check via Sp and VBA. That's why I write the following Stoted Proc as well as VBA Function and Procedure . Problem Is that when I Pass this input it prompt "type mismatch"
I 'd not figure it out where I made a mistake , any suggestion would be highly appreciated .
My Stored Procedure::
...Code:CREATE Procedure dbo.CheckBalance
-
Jim, first of all sorry for late response due to we have lot of power problem. Any way, many many thanks for your meaningful information . And Once again Sorry for my SP (this was unintentional mistake). AND last of all, it works fine.
Thanks for your great co-operation.
>>>>>>Naina<<<< <<<<<...Leave a comment:
-
Jim thanks for your reply
accordance to your suggestion create a Private function and call this function on after event of form control. But no desired result achieved. that means listbox show nothing below I would post both code
Private Function To execute the parameter Sp.
...Code:Private Function ListUpdate() Me!Lst_Challan.RowSource = "Exec dbo.DailyChallan " & Format$(Me.TxtChallanDate, "mm/dd/yyyy")
Leave a comment:
-
listbox with parameter sp of unbound control of forms
Hi everyone,
I've a A2003 adp & mssql2k base application Where I want to use List box with control source parameter sp . My form is bound but forms controls are unbound. now i describe what i've follow to achieve the task
forms record source:: Select * from HDC_ChallanT
listbox record source:: DailyChallan
...Code:CREATE Procedure dbo.DailyChallan @Pdate datetime AS Select Challanno,depositor,HDc_EconomicT.Economic+'-'+HDc_EconomicT.Engdesc,Amount
-
Jim, now it works and once again thanks for great suggestion...Leave a comment:
-
Thanks to reply, Yes I already use Same Input parameter for form as well as report(forget to mention) though form is unbound. AND Second thing , when run the report independently it prompts access default form . ....Leave a comment:
-
pass form parameter to Sp to Run the the report
I have a parameter form to populate the report whose control source "Stored procedure", Form has 3 control and one click event as well as as Set on Report's Input parameter property is
Code:@UID=Forms!RPM_Audit_Trail!CboUser,@SDate=Forms!RPM_Audit_Trail!TxtSdate,@EDate=Forms!RPM_Audit_Trail!txtEdate
And My Stored procedure is
...Code:CREATE PROCEDURE dbo.Sp_UserActivity @UID
-
sknaina started a topic Is it possible to save unbound Continuous subform record Using Stored procedure and Vin AccessIs it possible to save unbound Continuous subform record Using Stored procedure and V
Hi Eveybody,
I've a main form with a continuous subform based on 'DonorTranSmast erF' & 'DonorTranSdeta ilsF' ,
both tables are linked via 'DonorTransiD' field. I know & learn , How to save record Using SP & VBA
if the context of 'Unbound Continuous Subform' is it possible to save record via SP & VBA ?
Subform has two fields <'CboItemCode ' and 'Txtamount'>.
(application build on A2003... -
Dear Delerna,
Now it works fine.
Thanks a lot for your great solution!
NainaLeave a comment:
-
Problem with Returning value from Parametrized Sp
Hi, I Am New in Access arena and moderate knowledge of Sql 2000 Server
Now , I'm trying to Buildup an Application with Access2003 ADP & Sql 2000 Server. Over there I create a stored procedure to return balance calculation
My Sp performs okay When I run this via Query analyzer. Problem is I can't fired this Stored procedure on Forms After update event
any one help me to solve the problem ........
Here is...
No activity results to display
Leave a comment: