I have stored procedure in MS SQL and I want to deliver value from form
(value of textbox) in MS ACCESS.
CREATE PROCEDURE sp_DeleteOwing
@OwingID int
AS
INSERT INTO Arhive
SELECT MemberID, ArticalID, OwingDate, GETDATE()
FROM Owings
WHERE OwingsID = @OwingID
DELETE Owings
WHERE OwingsID = @OwingID
GO
I tryed whith this code in VBA but it doesn't works:
DoCmd.RunSQL("EXEC sp_DeleteOwing FORMS!DeleteOwing.TEXT0")
Can someone tell me how I can do it on some other way?