Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
0
Answer
How to call Access Macros with parameters from vb.net
Ask a question
Ask a question
Upload Source Code:
Select only zip and rar file.
suchi rana
11y
1.2k
1
Reply
HI All,
I have created macro in Access DB. Now i want to run that macro from Windows Vb.net.
Here is my code....
Dim oAccess As Object
oAccess = CreateObject("Access.Application")
oAccess.Visible = True
oAccess.OpenCurrentDatabase("\\Asihydfp01n1\it\Soft\IT-US\CSSD\ITS-US-LA\Sucharitha\TestCase\TestC.mdb")
oAccess.DoCmd.RunMAcro("macro1", lbluid)
oAccess.CloseCurrentDatabase()
'oAccess.Quit()
System.Runtime.InteropServices.Marshal.ReleaseComObject(oAccess)
oAccess = Nothing
************
But it won't affect in DB.
after this i am not able to open the Access DB.
Please any suggestions
Thanks in Advnace
Sucharitha
Post
Reset
Cancel
Answers (
0
)
Next Recommended Forum
creating checkboxlist dynamically inside another checkboxlis
VB.Net