[AccessD] (OT) VB Express + SQL Server Express ??

MartyConnelly martyconnelly at shaw.ca
Sun Feb 12 21:32:22 CST 2006


You can also use tools like this to turn Access Form and Report 
applications into Web-enabled Crystal Reports
http://doc.advisor.com/Articles.nsf/nl/12367

Jim Lawrence wrote:

>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






More information about the AccessD mailing list