Recent content by jbento

This is a very good thread!!! I will definitely keep this one in my favorites. Thanks, Jerome Benton JERPAT Web Designs www.jerpat.org GOD Is Good All The Time!!!

I have found this wonderful little database that logs users off automatically, so designers can do their designing. Go here: http://www.rogersaccesslibrary.com/download3.asp?SampleName=LogUsersOff.mdb It explains all about it, and you can download the sample as well. Thanks, Jerome Benton...

I think this thread will also help me!!! Thanks, Jerome Benton JERPAT Web Designs www.jerpat.org GOD Is Good All The Time!!!

Good post!!! Jerome Benton JERPAT Web Designs www.jerpat.org GOD Is Good All The Time!!!

I first want to thank KenReay for the wonderful suggestion!!! This is what I ended up doing, based on KenReay's suggestion: I created another field called oldStatus on the administrative form. On the "On Mouse Down" event of the status field I put the following code: oldStatus = status On...

Great!! You have also given me some good ideas with your suggestions, so I will try and let you know what I come up with. Thanks again, Jerome Benton JERPAT Web Designs www.jerpat.org GOD Is Good All The Time!!!

Questions: When you say extra column, do you mean another field? Should updated status be another field, or is that a function to capture updated information? I really appreciate your quick response!!! Jerome Benton JERPAT Web Designs www.jerpat.org GOD Is Good All The Time!!!

All, I hope somoneone can help with this one. I have frm_test and it has a copy record command button on it. frm_test_copy is the form that is used to capture the copied record from frm_test There is a drop-down field on frm_test called status. The values in the status field are Working...

PHV, When I apply the code, it changes the color of every record in the database, for that particular field, on my continuous form. Any other ideas? Jerome Benton JERPAT Web Designs www.jerpat.org GOD Is Good All The Time!!!

PHV, This is a continuous form. Would this change every record for this field to that color? If the answer is yes, that is not what I want. I will try it tomorrow and see what happens. Thanks so much. I will let you know what happens. Jerome Benton JERPAT Web Designs...

scottian, How can I modify the code below, if I want the text to change to the color red when somebody updates that field? If Me![Text1] > Me![Text2] Or Me![Text1] = Me![Text2] Then Me![Text1].ForeColor = vbBlue Else Me![Text1].ForeColor = vbRed End If End Sub Jerome Benton JERPAT Web...

Clyde, I am trying to do something similar in my continuous form, but I want the text in the field to change to red after update. This is how I modified the code, but it doesn't work. What am I doing wrong? Private Sub Form_Current() Dim ctl As Control, strForm As String Dim...

Ok I know what that is, but I just don't use acronyms very much, because my job is HUGE on using acronyms for everything:) Thanks my friend, Jerome Benton JERPAT Web Designs www.jerpat.org GOD Is Good All The Time!!!

TheAceMan1, I'm doing good my friend, but I may have a stupid question. What is PK? Jerome Benton JERPAT Web Designs www.jerpat.org GOD Is Good All The Time!!!

Ok. Yes I tried this, but how I have this set up that doesn't work. I thought of something else. What if I put a command in my copy command to force the newly created to be the last record? Here is my code: Private Sub Command10_Click() Dim db As DAO.Database, rst As DAO.Recordset 'Copy...