Can access be used for VBA?

[Chrisopia]

I have found what I need to do - but its a VBA tutorial...

the code looks very similar to what I've been working with in Access, but I was just wandering, what is the actual difference between raw VBA and the VBA access uses?

 

[vbaInet]

In a nutshell: VBA is an event driven language used for programming Office applications. There are some actions/methods/events that are supported in certain (Office) applications that you won't find in others (i.e. other Office apps). Although you can automate one application from the other using vba. VBA for Access is essentially the same but with topics covering methods/events/actions specifically made for programming in Access.

 

[darbid]

If you are going ahead with the translation from "raw VBA" to access VBA you can always post back here.

I would say that "RAW VBA" does not really exist, as VBA must relate to one of the office application. Maybe you mean Visual Basic which could then be raw.

Usually all VBA is available in all office applications. Some people will disagree with me on this so I will go one step further.

If you find that your RAW VBA relates to Excel and has a function exclusive to Excel. You will not be able to use this from the Access Application object. But what you can do is initiate an instance of the excel application and then use the function.

I don't have an example right now but if you have this problem then write back here.

 

[The_Doc_Man]

VBA in the abstract never exists because it is bound to an applications environment.

VB exists as a stand-alone thing because it is bound to its own environment.

"Raw VBA" is merely a VBA snippet that has been taken out of context. If it appears in a book, the odds are that the VBA was extracted to clarify the content and allow you to focus on it for educational purposes. But there is no stand-alone VBA compiler - unless one has come out recently and I missed the announcement - which could happen, I'll admit. But I don't see VBA as a stand-alone thing because, among other things, there is no way in any of the VBA cases I have seen to make a MAIN program segment. VBA can only make functions and procedures that can be called from a given environment. Like an Access or Outlook event or an Excel or Word Macro. Power Point has it as well. Others? Not so sure because to be honest, I don't use much else than those five apps in my daily office work.

 

[MarkK]

AutoCAD ships with VBA. It's Visual Basic for Applications.

 

[The_Doc_Man]

Actually, I've seen a terminal emulation package called Reflection that includes VBA, too. But the same comment still applies. VBA is used in the context of an application that will call it in some way, via function, direct call, or event-based call. But the syntax I've seen for every instance of VBA I've seen lacks the ability to make a MAIN segment that could be used to provide a starting address for a main program to be loaded by the image loader.