Member Avatar for brale
brale 0 Newbie Poster

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?

  • 1 Contributor
  • 0 Replies
  • 69 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.