Access Database Auditing

[Adrian Gonzalez]

Hi,

I have a database which is used for a model policy we have and i have a
form where the paragraphs for the policy is put. Now i need a way in
which i can highlight or underline the changes that are made by anyone
for the model policy data. I have searched on google and a number of
sites but come up empty handed.

Any help would be appreciated.

[Alan Webb]

Re: Access Database Auditing

Adrian,
Word does this way better than Access. I'd consider embedding a Word
document in a form and use Word's Revision tool to help you with this.

"Adrian Gonzalez" <gonzotron@gmai l.com> wrote in message
news:1102310026 .372079.80560@c 13g2000cwb.goog legroups.com...[color=blue]
> Hi,
>
> I have a database which is used for a model policy we have and i have a
> form where the paragraphs for the policy is put. Now i need a way in
> which i can highlight or underline the changes that are made by anyone
> for the model policy data. I have searched on google and a number of
> sites but come up empty handed.
>
> Any help would be appreciated.
>[/color]

[Larry Linson]

Re: Access Database Auditing

Unless you use a Rich Text Box, you cannot underline or highlight text in an
Access Text Box without highlighting or underlining ALL text in that Text
Box. But, without more information on what you have and what you are trying
to do other than a general description, it is going to be impossible for us
to make specific suggestions.

Larry Linson
Microsoft Access MVP

"Adrian Gonzalez" <gonzotron@gmai l.com> wrote in message
news:1102310026 .372079.80560@c 13g2000cwb.goog legroups.com...[color=blue]
> Hi,
>
> I have a database which is used for a model policy we have and i have a
> form where the paragraphs for the policy is put. Now i need a way in
> which i can highlight or underline the changes that are made by anyone
> for the model policy data. I have searched on google and a number of
> sites but come up empty handed.
>
> Any help would be appreciated.
>[/color]

[Adrian Gonzalez]

Re: Access Database Auditing

Ok here is a more detailed explanation of what i have.
I have a form where all the main headings reside you select the heading
you want then click on a button that takes you to another form with all
the subheadings and information that will be under that main heading. I
then have a textbox for subheadings and a model policy textbox were the
information for under the subheading is entered. I then have accept and
reject checkbox's were if the information is accepted then the data in
the first textbox is copied over to another textbox for the companies
version of this policy. If it is rejected then they input what they
want in the company version textbox. I then have a number of checkbox's
for who the information from the data is for eg: Managers, employees,
or Contractors.

Now when any changes to the data in any of the model policy textbox's
is made i need it to be shown so when anyone access's the form they
know what the last lot of changes were. I know that it can't be done
with normal textbox's but is there some way that it can be done in an
access form.

[Adrian Gonzalez]

Re: Access Database Auditing

Ok here is a more detailed explanation of what i have.
I have a form where all the main headings reside you select the heading
you want then click on a button that takes you to another form with all
the subheadings and information that will be under that main heading. I
then have a textbox for subheadings and a model policy textbox were the
information for under the subheading is entered. I then have accept and
reject checkbox's were if the information is accepted then the data in
the first textbox is copied over to another textbox for the companies
version of this policy. If it is rejected then they input what they
want in the company version textbox. I then have a number of checkbox's
for who the information from the data is for eg: Managers, employees,
or Contractors.

Now when any changes to the data in any of the model policy textbox's
is made i need it to be shown so when anyone access's the form they
know what the last lot of changes were. I know that it can't be done
with normal textbox's but is there some way that it can be done in an
access form.

[Adrian Gonzalez]

Re: Access Database Auditing

Ok here is a more detailed explanation of what i have.
I have a form where all the main headings reside you select the heading
you want then click on a button that takes you to another form with all
the subheadings and information that will be under that main heading. I
then have a textbox for subheadings and a model policy textbox were the
information for under the subheading is entered. I then have accept and
reject checkbox's were if the information is accepted then the data in
the first textbox is copied over to another textbox for the companies
version of this policy. If it is rejected then they input what they
want in the company version textbox. I then have a number of checkbox's
for who the information from the data is for eg: Managers, employees,
or Contractors.

Now when any changes to the data in any of the model policy textbox's
is made i need it to be shown so when anyone access's the form they
know what the last lot of changes were. I know that it can't be done
with normal textbox's but is there some way that it can be done in an
access form.

[Larry Linson]

Re: Access Database Auditing

If you want to change some properties of an entire Text Box, such as
bolding, italicizing, text color, or background color, you can do so with
the Text Box's Properties. To change parts of the text within a TextBox,
you'll need a Control that handles Rich Text -- there is one that comes with
the Developer Edition of Office XP and earlier (I know there has been some
change in the ActiveX controls that are supplied with the Visual Studio
Tools for Office 2003 System, the current counterpart to the Developer Tools
for Access and do not know if this is one that was omitted), or there are
third-party providers of custom controls for Access, of which FMS, Inc. is
one (http://www.fmsinc.com), who have rich text controls. Finally, MVP
Stephen Lebans has a free rich text control at his site,
http://www.lebans.com (but, like any freebie, it comes with no guarantee of
ongoing support).

If you wish to highlight the whole Text Box, you can keep a separate
"Changed" Yes/No field that you use to set the highlighting; if you choose
to highlight only the changes, then you'll have to store the data with Rich
Text markup.

Larry Linson
Microsoft Access MVP



"Adrian Gonzalez" <gonzotron@gmai l.com> wrote in message
news:1102374897 .087396.131290@ f14g2000cwb.goo glegroups.com.. .[color=blue]
> Ok here is a more detailed explanation of what i have.
> I have a form where all the main headings reside you select the heading
> you want then click on a button that takes you to another form with all
> the subheadings and information that will be under that main heading. I
> then have a textbox for subheadings and a model policy textbox were the
> information for under the subheading is entered. I then have accept and
> reject checkbox's were if the information is accepted then the data in
> the first textbox is copied over to another textbox for the companies
> version of this policy. If it is rejected then they input what they
> want in the company version textbox. I then have a number of checkbox's
> for who the information from the data is for eg: Managers, employees,
> or Contractors.
>
> Now when any changes to the data in any of the model policy textbox's
> is made i need it to be shown so when anyone access's the form they
> know what the last lot of changes were. I know that it can't be done
> with normal textbox's but is there some way that it can be done in an
> access form.
>[/color]

[Adrian Gonzalez]

Re: Access Database Auditing

Thanks i'll see how i go with the rich text control