setting memo at bottom of a report

[Guest]

I have a report that I want to display a memo at the bottom of it. Now I
don't have any use to store or to keep track of the memo in a table or
anything like that. This is just something that I want to have printed at the
bottom of every page of a report. I also want a user to be able to change
this memo. I thought it would be nice if I could have a form with a text box
on it and the user could type the memo and click a button that would delete
the old memo and save the new one in its place. How can I do this

 

[Guest]

Hi Dan,

Now I don't have any use to store or to keep track of the memo in
a table or anything like that.

Unless you want to force your user to enter a memo each time they open your
form (ie. an unbound field), you will need to store it somewhere. It's
usually easiest to do so in a table. Other options include a .ini file, or
the registry.

Create a form based on a table that holds your memo field. Add an
appropriate memo via the form. Then set the design property of the form to
disallow adding new records, or deleting records (ie. Allow Deletions = No,
Allow Additions = No and Data Entry = No). They should still be able to edit
the single record in this table.

You can use a domain aggregrate function, DLookup, to populate the textbox
in your report.

If my answer has helped you, please answer yes to the question that reads
"Did this post answer the question?" at the bottom of the message thread.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

I have a report that I want to display a memo at the bottom of it. Now I
don't have any use to store or to keep track of the memo in a table or
anything like that. This is just something that I want to have printed at the
bottom of every page of a report. I also want a user to be able to change
this memo. I thought it would be nice if I could have a form with a text box
on it and the user could type the memo and click a button that would delete
the old memo and save the new one in its place. How can I do this