Search results for query: *

PassingBy - Thanks for the tip! That could be my solution. Unfortunately, I don't have a good solution for you. Here's a page that discusses tracking changes in more detail than what I'm doing. http://www.vb123.com/toolshed/00_access/auditrecords.htm This page may help with your need to...

PassingBy - I forgot a part. Paste this code into the same module as you do the code above. It will give you the network username: Function NetworkUser() As String On Error Resume Next 'Hacked up code from ACC: How to Retrieve Workgroup Information Under Win32 'PSS ID Number: Q148835...

Hi PassingBy! All this code does is write either: 'Created by User on Date' or 'Changed by User on Date'. User = the network username. If this results is satisfactory to you, here's what you do: Create a new module and paste this code in it (or add to an existing one): Note: My form is...

Hi! One my App Owner's requirements is to track changes made to data. I have a 'Before Update' event on my form that creates an audit trail of changes that happen to the data through the form, but I don't know how to track changes to the data if it's done directly in the table. I don't mind...

Hi! Thanks for your replies! I think I got confused about the shortcut. I used the help file to get me as far as I got, but I didn't read far down enough to see the section about having secure and non-secure databases, which is the only place I found that addressed \WRKGRP. In fact, I was...

LarryDeLaruelle - You rock! That's exactly what I've been looking for. Thanks!

Hi! You can have your list box show multiple columns of your table by changing some of the properties: column heads = yes column count = 3 (or however may columns you would like) Then, make sure your row source has all three columns selected for showing. Hope this helps.

Hi! I have an access database that is in a network directory. Here are the steps I've taken so far to secure the db. 1)Created a workgroup file specifically for the database and saved it in the same directory. 2)Created myself as a user and set admin password. 3)Removed admin from Admins...