Hi!
I would like to know how to reach Access 97 reports from a VB 5.0
application. Any examples and book tip are appreciated.
TIA
Lars Gustavsson, Sweden
by Lars Gustavss » Fri, 13 Mar 1998 04:00:00
Hi!
I would like to know how to reach Access 97 reports from a VB 5.0
application. Any examples and book tip are appreciated.
TIA
Lars Gustavsson, Sweden
by Alfred Schwar » Fri, 13 Mar 1998 04:00:00
Lars Gustavsson schrieb in Nachricht
You can use Access97 as an OLE-Server. There are (commercial)Quote:>I would like to know how to reach Access 97 reports from a VB 5.0
>application. Any examples and book tip are appreciated.
Ciao, Alfred
by Lars Gustavss » Fri, 13 Mar 1998 04:00:00
Thanks, Alfred!
If you could direct me to any developer that have that kind of
component I would be pleased.
TIA
Lars Gustavsson, Sweden
On Thu, 12 Mar 1998 12:28:05 +0100, "Alfred Schwarz"
>You can use Access97 as an OLE-Server. There are (commercial)
>OCX/ActiveX-components available that can do this job too.
>Ciao, Alfred
by LCC Raul Ricardo Coba Poo » Fri, 13 Mar 1998 04:00:00
The MSAccess97 Knowledge base has an article about using Access as an
automation server.
acc97kb.hlp at microsoft site.
You can also try the vsreports from VideoSoft, its available in
videosoft's site
you can download a demo copy of it there.
HTH
Raul Coba Poot
> If you could direct me to any developer that have that kind of
> component I would be pleased.
> TIA
> Lars Gustavsson, Sweden
> On Thu, 12 Mar 1998 12:28:05 +0100, "Alfred Schwarz"
> >Lars Gustavsson schrieb in Nachricht
> >>I would like to know how to reach Access 97 reports from a VB 5.0
> >>application. Any examples and book tip are appreciated.
> >You can use Access97 as an OLE-Server. There are (commercial)
> >OCX/ActiveX-components available that can do this job too.
> >Ciao, Alfred
by Mark & Alexi » Thu, 26 Mar 1998 04:00:00
Hi,
If all you want to do is print reports then you can use dde to
send relevant commands.
Apologies if this does not work in 97 - we only use 2.0 at
present.
Mark.
> Hi!
> I would like to know how to reach Access 97 reports from a VB 5.0
> application. Any examples and book tip are appreciated.
> TIA
> Lars Gustavsson, Sweden
1. Previewing an Access 97 report from VB 5.0
From an earlier posting (a la Kevin Higgins):
I just got finished doing just this. Of all the reporting utilities out
there for VB, Access reports are still the easiest to develop. You'll have
to add a reference to the Access 8.0 object library then you can do the
following.
Declare an access application variable
Dim aAccess As Access.Application
aAccess.DoCmd.OpenReport sReportname, acViewNormal
You probably recognize the VB syntax as being identical to the Access Basic
syntax
Good luck!
2. Unable to bind foreign key constraint. Too many tables involved in query.
3. Printing Access 97 Reports from VB 5.0 program
4. HELP VFP 5.0 ! Main window size in .exe
5. Help: convert access 2.0 to access 97 using VB 5.0
7. Vb 5.0 Pro en MsAccess 97 Reports
9. Run-time error '3075': Access 97 and VB 5.0
11. Access 97 Generated Form in VB 5.0?
12. Differences between VB 5.0 and Access 97