Prev: Where to put code?
Next: DoCmd.RunCommand acCmdSaveRecord
From: Sharkbyte on 17 May 2010 08:06
Has anyone experimented with, or completed, any kind of dynamic report
building system, within Access? This would be for use from an MDE, not the
Reports tab.

I would be interested in looking at how you were able to accomplish this.

Thanks in advance.

Sharkbyte
From: Arvin Meyer [MVP] on 17 May 2010 08:12
If you mean an adhoc report, you cannot create anything at runtime with an
MDE, but you can run existing code to show or hide objects. You can also
used a Dialog form to alter the values of the report's criteria.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


"Sharkbyte" <sharkbyte1(a)hotmail.com-> wrote in message
news:BE58C0CE-4E8D-490D-A7B2-C0483B90CBB5(a)microsoft.com...
> Has anyone experimented with, or completed, any kind of dynamic report
> building system, within Access? This would be for use from an MDE, not
> the
> Reports tab.
>
> I would be interested in looking at how you were able to accomplish this.
>
> Thanks in advance.
>
> Sharkbyte


From: bubbles on 17 May 2010 22:01
On May 17, 8:06 pm, Sharkbyte <sharkby...(a)hotmail.com-> wrote:
> Has anyone experimented with, or completed, any kind of dynamic report
> building system, within Access?  This would be for use from an MDE, not the
> Reports tab.
>
> I would be interested in looking at how you were able to accomplish this.
>
> Thanks in advance.
>
> Sharkbyte

You mean like Crystal Reports?
From: david on 18 May 2010 07:08
Yes, I've done it, no, I can't really give any advice.

You don't want to re-create MS Access: that application already exists, and
it would be far to much work.

Instead, as a starting point you need to decide what small feature of your
reports you would like your user to be able to change, and create a form
that allows them to change that.

(david)

"Sharkbyte" <sharkbyte1(a)hotmail.com-> wrote in message
news:BE58C0CE-4E8D-490D-A7B2-C0483B90CBB5(a)microsoft.com...
> Has anyone experimented with, or completed, any kind of dynamic report
> building system, within Access? This would be for use from an MDE, not
> the
> Reports tab.
>
> I would be interested in looking at how you were able to accomplish this.
>
> Thanks in advance.
>
> Sharkbyte


 | 
Pages: 1
Prev: Where to put code?
Next: DoCmd.RunCommand acCmdSaveRecord