Recent content by Jim229

Thank you for the help. This but of code should simplify the process a great deal.

DCrake, currently as the code works it utilizes the windows open file dialog box to grab the photo and put it in the form and load the location into the database field so it can be loaded as often as needed. As far a a picture source, I have pictures from cameras coming in and unfortunately no...

I fully agree, unfortunately it's not always an option. I would prefer to have included a file size attribute check even though I'm not storing the image directly in the database. But this was a limitation for me as I am not an expert in Vb programming. I prefer to program in traps and this...

I agree with that concept in an Employee database. I was adapting the code for use in something a lot more complicated and needed to be able to address multiple users, some of which are not exactly computer literate. In the case of this particular project I needed to anticipate problems from...

That was the problem. I posted that a while back and forgot about it. As it turned out the code was correct but the reference on the form wasn't and I hadn't looked at the sample form at the time I made this posting. Once I included the reference in the form as a hidden field everything...

It's actually not that hard. Look at the Utility functions module, highlight and copy the section that is the audit trail code. You will be able to see where it switches to a calendar function. Go to your database and add a new module and then paste the copied code in it and save it as Module...

ScubaDiver, I attached a zip file of a database I've been working on that uses ghudsons version of Audit trail that saves the changes in a separate table. There are 2 photos included in the zip file. for some reason my Winzip wouldn't take the whole photo folder into the archive. You will...

ScubaDiver, It is possible to do what you want. I use that as a back up of sorts. While it does make the information redundant because in my implementation I keep the Audit data in a separate table as well as each table that has an entry changed. I plan to remove this from the tables though...

:confused: Please I need some help. I have been working to duplicate a function that works great in the Sample DB Northwind.mdb which is included in the MS Office XP installation. The function I need is the Photo function that allows for adding and updating the Employee photo in the Employee...

According to what I have read on the Microsoft site you need to implement your auditing approach before you migrate to any Access 2007 or newer. According to the article I read Access 2010 format does not support this activity tracking but will accept it if you had it active before converting...

I want to thank all that have posted code and methods for doing this, Great Job All of you. I unfortunately must ask if you can help me one a little more. I created a database for tracking Police Records several years back and now have a new problem with someone making changes to those...