accessing Access 2000 Report using VB6 ADO
Thanks a lot Norris I owe u one...
Right now I am downloading SP5 and I am looking forward to
work on it. I there any online help on this, please do let
me know...
Thanks
Biju
Quote:
>-----Original Message-----
>You could try using the Data Report designer.
>It takes a bit of getting used to as it's not quite so
intuitive or
>versatile as an Access report. However, you can design
quite adequate
>reports with it and it takes any ADO recordset as its
record source -
>including disconnected ones. It doesn't need a license
and is contained
>within your project.
>Make sure you have the latest VB service pack installed
as early versions of
Quote:
>the designer had problems with changing paper orientation
and needed a
>rather clunky bodge (sorry - workaround) that Microsoft
provided that
>requires administrative control over at least one
installed printer.
>Norris
>> Thanks Doug
>> This is what I am doing.. and if possible could u please
>> let me know the best opproach for this...
>> Right now I am in the process of converting a Excel
>> spreadsheet to an Access 2000 database. I am creating a
UI
>> in VB 6 and using ADO to access Access database.
>> Since we were having problems with sharing Excel
>> spreadsheet, since it kept on locking on each user.
>> I have almost completed the UI and the interaction with
>> ADO control. Now I am stuck with viewing the database
in a
>> report format.
>> Do I have to this project entirely in Access 2000 and
>> forget about VB6 & ADO or keep continuing in this path,
if
>> so could you please let me know how to call automation
>> from VB6..
>> Thanks a lot in advance for looking in to this.
>> Biju
>> >-----Original Message-----
>> >Do you mean you have a report in Access 2000 that you
>> want to produce? If
>> >so, the answer's no, ADO cannot open Access reports.
>> >The only way I'm aware of to use Access Reports from VB
>> is through
>> >Automation:
>> >ACC: How to Use Automation to Print Microsoft Access
>> Reports:
>> >http://support.microsoft.com/default.aspx?scid=kb;EN-
>> US;Q145707
>> >ACC2000: How to Use Automation to Print Microsoft
Access
>> Reports
>> >http://support.microsoft.com/default.aspx?scid=kb;EN-
>> US;Q210132
>> >ACC2002: How to Use Automation to Print Microsoft
Access
>> Reports (Q296586)
>> >http://support.microsoft.com/default.aspx?scid=kb;en-
>> US;Q296586
>> >ACC: Using Microsoft Access as an Automation Server
>> (Q147816)
>> >http://support.microsoft.com/default.aspx?scid=kb;EN-
>> US;Q147816
>> >ACC2000: Using Microsoft Access as an Automation Server
>> (Q210111)
>> >http://support.microsoft.com/default.aspx?scid=kb;EN-
>> US;Q210111
>> >Note that this requires that Access be installed on the
>> workstation.
>> >--
>> >Doug Steele, Microsoft Access MVP
>> >http://I.Am/DougSteele
>> >> Hi there:
>> >> Is there a way to generate a report using VB6 ADO
>> >> conncetion with Access 2000
>> >> Any code samples will be much appreciated
>> >> Thanks
>> >> Biju
>> >.
>.
