Can anyone answer my DAP question?

[Jim]

All, I'm quite familiar with Access (and DAP) out of the box; however,
I am not very experienced with customization. Here's the scenario:

I am linking access with Oracle tables, writing the queries in Access,
and using the parameter queries to feed a DAP.


The end-user would like the option to select records, via checkbox, and



then select a "print" command button that will allow for the records to



be printed.


I don't have MSE, but am guessing that I'll need to write something
that will accomplish the above task. Here are my questions to you:


Can this be done without MSE?
If yes, a sample of code would be most helpful (the DAP is named "Error



Tracking", the Command Button is entitled "Command4", and the checkbox
is entitled "Check0").
If no, can someone tell me how to download MSE (it didn't come with my
version of Access and no one in my company seems to know what I'm
talking about)?


Many thanks,


Jim

 

[Brendan Reynolds]

I can't give you the required code, Jim, as I don't have any experience with
DAPs. But I can tell you that you don't have to edit DAPs in MSE, you can
edit them in Notepad, but obviously the task will be much, much easier with
an editor that provides some kind of help and guidance with HTML and script.

Perhaps you may be able to install MSE if you re-run Office setup and choose
the option to add/remove components. (I can't say for certain as I always do
a complete install). I expect this is probably the best solution. Failing
that, you could try FrontPage or Visual Studio. If you don't have any of the
above, you could perhaps try Visual Web Developer Express Edition
(http://msdn.microsoft.com/vstudio/express/vwd/download/) or check out the
shareware sites for HTML and script editors.

I can't promise that any of the above will work for you. I would not usually
attempt to answer a question about DAPs at all. I an posting this, vague and
uncertain as it is, only because you have not received any other response.

 

[Ken Snell \(MVP\)]

I posted a sample database in another forum
(
http://www.utteraccess.com/forums/showflat.php?Cat=&Board=86&Number=1124353&fpart=1 )
that shows how to use cookies to allow passing value selections from one DAP
to another. Perhaps it will give you some ideas for how to do what you seek?
Go way down the thread to the second database attachment post
(http://www.utteraccess.com/forums/download.php?Number=1125560)