How do I get Access to bring up VB.net instead of vb 6?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I click on an event procedure for a button, I seem to get VB 6. I would
like to use vb.net
 
"jtwhitney" wrote
When I click on an event procedure
for a button, I seem to get VB 6. I
would like to use vb.net
Click to expand...

Though it may seem you get VB6, what you actually get is Visual Basic for
Applications (it is the same as the core library for the separate VB6
product, which is why is may seem so familiar).

Access is "Not Yet Dot Net." That is, Access, through v. 2003, has no
support for using VB.NET or C# instead of VBA. No announcement has been made
by Microsoft about using VB.NET or C# in a future version.

Excel 2003 and Word 2003 can use VB.NET or C# instead of VBA. To enable
that, you have to purchase the separate Visual Studio Tools for Office 2003
System package.

Larry Linson
Microsoft Access MVP
 
Larry said:
Excel 2003 and Word 2003 can use VB.NET or C# instead of VBA. To enable
that, you have to purchase the separate Visual Studio Tools for Office 2003
System package.
Click to expand...

You may have been misled by the name, which perhaps would have been
better as Office 2003 Tools for Visual Studio. You cannot use VB.NET or
C# instead of VBA *inside* an Excel or Word project. Instead, VSTO is a
special type of VS.NET project which can hooks certain events of a
Word/Excel document.

Jamie.

--
 
You may have been misled by
the name, which perhaps would
have been better as Office 2003
Tools for Visual Studio. You can-
not use VB.NET or C# instead
of VBA *inside* an Excel or Word
project. Instead, VSTO is a special
type of VS.NET project which can
hooks certain events of a
Word/Excel document.
Click to expand...

Jamie, thanks for the clarification.

I guess I should point out that you can also "drive" Access via COM
Automation from a .NET project done in VB.NET or C# -- not the same as the
VSTO .NET Project for Word/Excel. As that would be far more work than simply
creating an Access database, it would only be useful in some special
situations.

Larry Linson
Microsoft Access MVP
 
Back
Top