Thank you very muchly :-))
--
Allen @ Home
When an old lady got hit by a truck
I saw a wicked gleam in your eye
SA wrote:
:: Sure it can be done; provided the user has either full Access or the run
:: time version installed on their computer. You simply have to use
automation
:: to launch Acces and display or print the report as in:
::
:: Dim objAccess as Object
:: Const acViewPreview = 2
:: Const acSysCmdGetObjectState = 10
:: Const acObjStateOpen = 1: acReport = 3
:: Set objAccess = CreateObject("Access.Application")
:: objAccess.OpenCurrentDatabase "PathToYourDb"
:: objAccess.DoCmd.OpenReport "MyReport", acViewPreview
:: While objAccess.SysCmd(acSysCmdGetObjectState, acReport, "MyReport") = _
:: acObjStateOpen
:: DoEvents
:: Wend
:: objAccess.CloseCurrentDatabase
:: objAccess.Quit
:: --
:: Steve Arbaugh
:: ACG Soft
::
http://ourworld.compuserve.com/homepages/attac-cg
::
::
:: "Allen@Home" <at**@takeyourhatoff.ntalk.org> wrote in message
:: news:Zz****************@newsfep4-glfd.server.ntli.net...
::: Is it possible to create a report in a back end Access db and then
call/show
::: it from a VB front end?
::: TIA
:::
::: --
::: Allen @ Home
:::
::: When an old lady got hit by a truck
::: I saw a wicked gleam in your eye