Jim Lawrence
accessd at shaw.ca
Sat Feb 11 15:08:05 CST 2006
Hi Marty: That is brilliant.... have been about to start a search on relevant reporting for a VB.Net project. Excellent mind reading! :-) Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MartyConnelly Sent: February 11, 2006 1:01 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] (OT) VB Express + SQL Server Express ?? Why not just call Access Reports from VB.Net You will need either the Microsoft Office XP or 2003 Primary Interop Assemblies (PIAs). Microsoft Office XP primary interop assemblies (PIAs) are available for download XP http://support.microsoft.com/kb/328912/EN-US/ 2003 http://support.microsoft.com/kb/897646/ Then How To Automate Microsoft Access From Visual Basic .NET http://support.microsoft.com/default.aspx?scid=kb;en-us;317113 or more general http://support.microsoft.com/kb/311452/ http://msdn.microsoft.com/office/default.aspx?pull=/library/en-us/odc_of2003 _bk/html/officeinteroperabilitych2_part1.asp you may have to reference the Microsoft.Office.Interop.Excel namespace through an alias, like so: using Excel = Microsoft.Office.Interop.Excel; simple access vb.net access program Developing Office 2003 solutions with .NET http://builder.com.com/5100-6373_14-5315974.html#Listing%20A Dan Waters wrote: >I've downloaded VB Express to get a look at the features. I've never >developed with VB before (just Access), and I remember reading that >subforms/subreports aren't available in VB. I looked through the list of >controls for forms, and didn't find any reference to subforms/subreports. > >Also, VB doesn't have a reporting feature like Access. SS 2005 has >Reporting Services, but SS Express doesn't. > >So, is the idea of using VB Express with SQL Server Express for business >applications not feasible? > >Does anyone have experience using these products yet? > >Dan > > > -- Marty Connelly Victoria, B.C. Canada -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com