Opening Report from Data Access page

  • Thread starter Thread starter Anna Booth
  • Start date Start date
A

Anna Booth

I want to place a command button on a data access page
which opens an Access report. I don't want to re-create
the report as a data access page as it looks like a dog's
breakfast.

is this possible?
 
You can use our "report server" product to deliver dynamic reports over
the web via PDF files. Our product consists of a COM object and
a server-side EXE file and typically works with a ASP or ASP.NET
environment. You could use DAPs (yuck) to write the data-entry portion of
your web app and use asp or asp.net to write the reporting section of your
web app.

HTH,
Mark
RPT Software
http://www.rptsoftware.com
 
If each of the people viewing the DAP have access on their
local machine the following snippet will work just fine.
If not, you *can* have the object created on a server
using server-side automation (well documented in the MS
KB) but it requires sometimes tempermental DCOM and *may*
be a licensing issue as well.

-ed cetron
ecetron@<nospam>tili.com

<SCRIPT language=vbscript event=onclick for=Command0>
<!--
Dim strFilter
Dim objAccess

'MsgBox("Onclick")
'MsgBox(document.all.item("defect",0).value)

strFilter = "[Defects.Defect] = " &
document.all.item("defect",0).value

'MsgBox(strFilter)

Set objAccess = createObject("Access.Application")
'MsgBox("Object created")

'objAccess.Visible = True
'MsgBox("Access Visible")

dbStr = "\\njc1\...\tp.mdb"
objAccess.OpenCurrentDatabase dbStr
'MsgBox("Database Open")

objAccess.Docmd.OpenReport "Full
Report",,,strFilter

objAccess.Quit 'close access down
'MsgBox("Object destroyed")
Set objAccess = nothing

-->
 
You are launching seperate Access instances for every request. On a web
server
if you get any kind of concurrency this can lead to problems.

Our product uses the server-side method but also allows PDF and wraps it
all together in an easy to use COM interface.

My two cents,
I started doing this about 5 years ago,
Mark
RPT Software
http://www.rptsoftware.com

If each of the people viewing the DAP have access on their
local machine the following snippet will work just fine.
If not, you *can* have the object created on a server
using server-side automation (well documented in the MS
KB) but it requires sometimes tempermental DCOM and *may*
be a licensing issue as well.

-ed cetron
ecetron@<nospam>tili.com

<SCRIPT language=vbscript event=onclick for=Command0>
<!--
Dim strFilter
Dim objAccess

'MsgBox("Onclick")
'MsgBox(document.all.item("defect",0).value)

strFilter = "[Defects.Defect] = " &
document.all.item("defect",0).value

'MsgBox(strFilter)

Set objAccess = createObject("Access.Application")
'MsgBox("Object created")

'objAccess.Visible = True
'MsgBox("Access Visible")

dbStr = "\\njc1\...\tp.mdb"
objAccess.OpenCurrentDatabase dbStr
'MsgBox("Database Open")

objAccess.Docmd.OpenReport "Full
Report",,,strFilter

objAccess.Quit 'close access down
'MsgBox("Object destroyed")
Set objAccess = nothing

-->
-----Original Message-----
I want to place a command button on a data access page
which opens an Access report. I don't want to re-create
the report as a data access page as it looks like a dog's
breakfast.

is this possible?
.
Click to expand...
Click to expand...
 
Back
Top