Wrox Programmer Forums
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 21st, 2006, 05:34 AM
Registered User
 
Join Date: Jul 2005
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to ahali
Default Using VB.net In Access Forms

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??????

 
Old February 21st, 2006, 11:16 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

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



mmcdonal
 
Old February 21st, 2006, 06:11 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,093
Thanks: 1
Thanked 12 Times in 11 Posts
Default

 
Quote:
quote:how can we use VB.net Code in access forms??


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




 
Old February 22nd, 2006, 08:50 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

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
 
Old February 23rd, 2006, 08:26 AM
Registered User
 
Join Date: Jul 2005
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to ahali
Default

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






Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert a CATIA preview in VB.net Forms Zaman_mech VB How-To 1 September 21st, 2007 12:01 PM
Exporting forms from VBA to VB.net Kapil General .NET 0 February 9th, 2007 01:30 AM
New at VB.Net - Need help with delpoying web forms Pail .NET Web Services 0 September 21st, 2005 02:22 PM
Load and Unload Forms In Vb.net gibran VB.NET 1 December 1st, 2004 04:38 AM
Printing Forms in VB.NET? gisenberg VB.NET 2002/2003 Basics 0 July 23rd, 2004 08:22 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.