Hi everybody,
its me once again, first of all thanks to all who helped me previous forums regarding the Oracle Database and systems , its was a great help,
now its just a minor question that i have in mind that is; how can we use VB.net Code in access forms?? i have developed a great deal in VB.net applications , i know there is no major differences in VB and VB.net but i want to use some features that are accessible through the Visualstudio OR can i open up the Access forms in Visual Studio.net 2003??? is it really possible??????

What sort of features do you want to use? We can show you the VBA analog if one exists.



mmcdonal

 

You can't at this point (as of VS.NET 2K3, can't speak about 2K5), and my suspision is that Microsoft won't be moving in that direction. They seem to be headed the other way: making Office functionality available to .NET assemblies, not integrating Common Language Runtime supported languages (C#, VB.NET, etc.) into Office. But who knows. For example, Visual Studio Tools for the Microsoft Office System enables you to create .NET projects that use Word and Excel functionality (no support for Access as far as I know). I havn't played with it yet, but I think installing the Tools on your system creates a new project type in VS.NET IDE: Microsoft Office System Projects, which enable you to use classes in the Microsoft.Office.Core namespace:

' VB.NET
Imports Office = Microsoft.Office.Core

// C#
using Office = Microsoft.Office.Core;

Again I'm not sure, but I heard SQL Server 2005 was going to integrate support for some CLR supported languages, allowing you to write, say, stored procedures using VB.NET or C#. Don't know if that happened or not. Just ain't buyin' the new stuff the day it comes out like I used to.

But as far as Access is concerned, only the Jet engine (which, of course, isn't Access) can play a role in a .NET solution as a backend data store. Otherwise, Access and .NET don't speak to each other.

Bob

YOu can check out the Wrox book "Beginning VB.Net Databases." There is also one by another publisher that specifically covers Programming MS Access with VB.NET", but as Bob said, it is just as a Jet data store.

If you can explain what features you are looking for specifically, someone may be able to show you how to do it in VBA.

mmcdonal

Hi everybody thanx for replying
actually i have tried and worked on access creating web applications as well as windows based applications but i was playing with the front end of the software so i decided to use some of the features like installing menubar like we do in applications , i have the book "Begining VB.net databases" but i cannot as bob replied but i will play and i hope to get through with it and as i will i will publish here in the upcoming days.
ALLY HASSAN ALI