changing report headings names

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CD Tom - 03 Nov 2007 16:10 GMT

I would like to give the user the option of changing the report heading
names, I can do this with the Docmd.openreport, stdocname,
acviewdesign,,,achidden and then grab the current heading and display that
heading and allow the user to change it. I then do a docmd.close acreport,
stdocname, acSaveYes, this works just fine when I test but when I compile the
program into a mde it doesn't like the it. Is there another way of doing
this? Thanks for any help.

Tom

Reply to this Message

tina - 03 Nov 2007 17:07 GMT

you can write the current heading names to a table, making sure the table
holds only one record. add the table to the query that the report is based
on. use textbox controls to display the heading names in the report. display
the table to the user *via a form*, where s/he can change the heading names
as desired.

hth

> I would like to give the user the option of changing the report heading
> names, I can do this with the Docmd.openreport, stdocname,
[quoted text clipped - 5 lines]
>
> Tom

Reply to this Message

CD Tom - 04 Nov 2007 17:07 GMT

Thanks Tina, that should work.

> you can write the current heading names to a table, making sure the table
> holds only one record. add the table to the query that the report is based
[quoted text clipped - 15 lines]
> >
> > Tom

Reply to this Message

tina - 04 Nov 2007 20:31 GMT

you're welcome :)

> Thanks Tina, that should work.
>
[quoted text clipped - 17 lines]
> > >
> > > Tom

Reply to this Message