•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 426,465 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,258 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS Access and FileMaker Pro advertiser: Programming Forums
Views: 1201 | Replies: 0
 |
•
•
Join Date: Jun 2006
Posts: 20
Reputation: 
Rep Power: 3
Solved Threads: 0
Newbie Poster
Need help in MS ACCESS VBA 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?
(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?
|
•
•
•
•
•
•
•
•
DaniWeb MS Access and FileMaker Pro Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- MS Access vs. MySQL (MS Access and FileMaker Pro)
- Freelance Developer ASP.NET / VB.NET / C# / VB / ASP & Crystal Reports (Web Development Job Offers)
- Access error 3111 (Visual Basic 4 / 5 / 6)
- when clic, it should show the equvelant english to the tamil(a language india) wrd (Visual Basic 4 / 5 / 6)
- i need login code in C# (C#)
- Using VBA with Access (was: Please Help!!!) (Visual Basic 4 / 5 / 6)
- OK, where do I start (VB.NET)
- ASP.NET Freelance Programmer / Developer (IT Careers and Business)
Other Threads in the MS Access and FileMaker Pro Forum
- Previous Thread: Interactive products for FileMaker
- Next Thread: How to include multiple tables in FM format
