473,289 Members | 1,866 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,289 software developers and data experts.

Access Database Auditing

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.

Nov 13 '05 #1
7 1549
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" <go*******@gmail.com> wrote in message
news:11*********************@c13g2000cwb.googlegro ups.com...
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.

Nov 13 '05 #2
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" <go*******@gmail.com> wrote in message
news:11*********************@c13g2000cwb.googlegro ups.com...
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.

Nov 13 '05 #3
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.

Nov 13 '05 #4
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.

Nov 13 '05 #5
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.

Nov 13 '05 #6
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" <go*******@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
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.

Nov 13 '05 #7
Thanks i'll see how i go with the rich text control

Nov 13 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: latosca68 | last post by:
I need to demostrate, in a forensic job, that I can change (insert, update, delete) records in a table of an access database without trace. How can I do this ? I plan to make the queries or export...
13
by: Jim M | last post by:
I've been playing with Allen Browne's audit code and found it very useful. I need to track record insertions, deletions, and edits for several tables. I am planning to replace Access with Microsoft...
21
by: Kevin Swanson | last post by:
I'm attempting some remote registry manipulation via C#. I've written a test app to simply grab a specified key from a specified hive on a specified machine. The call to OpenSubKey is throwing...
4
by: Ed Rauscher | last post by:
Does ayone know what Class is used to enable Registry Auditing? Any help would be great.
0
by: UserNotFound | last post by:
Hi, I need to register/log 'who' (usercredential) access 'what'(foldername) in a Windows 2003 server - FileSystemWatcher doesn´t gives information about user. if someone knows how to obtain...
0
by: dba | last post by:
Hi folks, I would just like to share with you SQL CodeSecure, a newly released database protection and auditing tool from SqlLabs: SQL CodeSecure provides ultimate protection from unauthorized...
6
by: jsacrey | last post by:
Hello everybody, I've got a bit of a situation that I could use some guidance with if possible. I work for an auditing firm where my users audit electronic shipping data for customers to see if...
7
by: Neil Jones | last post by:
Hello, We have a large database of our customers. Some of the important customers records are flagged and can be accessed only by applications designed for upper management. The management...
6
by: jsacrey | last post by:
Hey everybody, got a secnario for ya that I need a bit of help with. Access 97 using linked tables from an SQL Server 2000 machine. I've created a simple query using two tables joined by one...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.