troubleshooting Question convert Access VBA code to

Avatar of Murray Brown
Murray BrownFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft AccessVisual Basic.NET
3 Comments2 Solutions603 ViewsLast Modified:
Hi. I have the following code in Access VBA. I need to build it in for my Excel Add in

Function oCreateBatchID() As Long

    Dim oUser As String
    oUser = Environ("USERNAME")

    Dim rs As DAO.Recordset
    Set rs = CurrentDb.OpenRecordset("BatchID")
    rs!oUser = oUser
    oCreateBatchID = rs!ID
    Set rs = Nothing
End Function
Join our community to see this answer!
Unlock 2 Answers and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros