implements statement !!

  • Thread starter Thread starter sparkane
  • Start date Start date
S

sparkane

I just discovered that VBA uses an "Implements" statement. I'd
appreciate any advice regarding its use, gotchas, tips, developer
experience documented on the web, etc, beyond the description of the
statement in the VBA help file.

Thanks in advance.
 
There is VBA, and VBA!

For example: Access VBA; Excel VBA; Word VBA; Project VBA.

I think (but am not 100% sure) that Access VBA does not support that
keyword.

HTH,
TC
 
TC said:
There is VBA, and VBA!

For example: Access VBA; Excel VBA; Word VBA; Project VBA.

I think (but am not 100% sure) that Access VBA does not support that
keyword.
Click to expand...

I am 100% sure that it does. Type "implements" into a module, then
press F1. You will see that at the very least, it is in the Help file
for VBA. Under "Statements". I have the documentation beside me.

I admit that VBA's compiler may ignore it, but that seems an unlikely
possibility.

spark
 
sparkane said:
I am 100% sure that it does. Type "implements" into a module, then
press F1. You will see that at the very least, it is in the Help file
for VBA. Under "Statements". I have the documentation beside me.

I admit that VBA's compiler may ignore it, but that seems an unlikely
possibility.
Click to expand...

The VBA Help file has topics for VBA in ALL of the Office apps, not just Access.
You will find lots of things in there that do not apply to or work in Access.
 
Rick Brandt said:
The VBA Help file has topics for VBA in ALL of the Office apps, not just Access.
You will find lots of things in there that do not apply to or work in Access.
Click to expand...

I suppose that's possible, but I think in this case it can be used in
Access. The Help topic uses forms in its example, which sounds to me
like Access. Form only appears as a class for Access. I have an Excel
reference in my database, and that library doesn't have a Form class. I
don't code in the other Office apps, though.

It would be strange for different parts of VBA to work in different
Office apps. Aren't VBA libraries shared between the Office apps? Does
each Office app have its own VBA implementation? Can you provide some
examples of VBA Statement keywords which can be used in apps other than
Access but not in Access?

spark
 
Hi,
VBA is the same accross all the Office apps.
Just go into the Object Browser in each of the apps to verify.

The Aplication's object model is of course different and will provide different
functionality. For example, a form in Access is way different from a form in Excel,
but that has nothing to do with VBA
 
I still think (but am not 100% sure) that Implements is not supported in
Access VBA :-)

Can anyone say definitely, yea or nay?

I don't mean whether it is in Help, or whether "the compiler accepts it". I
mean whether it >works<.

Any takers?

TC
 
sparkane said:
I suppose that's possible, but I think in this case it can be used in
Access.
Click to expand...

Er, "I think" is a slight retreat from "100% sure", yes? :-)
The Help topic uses forms in its example, which sounds to me
like Access. Form only appears as a class for Access. I have an Excel
reference in my database, and that library doesn't have a Form class. I
don't code in the other Office apps, though.

It would be strange for different parts of VBA to work in different
Office apps. Aren't VBA libraries shared between the Office apps? Does
each Office app have its own VBA implementation? Can you provide some
examples of VBA Statement keywords which can be used in apps other than
Access but not in Access?
Click to expand...

Sure. Check out Access 97 help for the Unload statement! (not event)

TC
 
Back
Top