Search results for query: *

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...

This does not work, because the record that is copied is not normally going to be the last record. I just tried it and it is bringing up some other record still. Any other ideas? Jerome Benton JERPAT Web Designs www.jerpat.org GOD Is Good All The Time!!!

All, I have 3 forms. One is a search form and the other is a results form, and then there is a results form from a button that copies a record. I have a command button on the results form to copy that record. Once that record is copied it opens up the form with the copied...

All, Is the following possible? I think I want to set up a rule for this if that is the right way to go: I get an email from joeblow@nothing.com I want the rule to automatically send a template email back to joeblow@nothing.com. That template email would be something like a confirmation...

The problem I was having was with the iecdNumber field which was formatted with \cyy. Because of the formatting I couldn't see the actual date until I clicked in that field. The problem was some of the dates wasn't in the correct sort order, so I just simply changed some of the dates to force...

All, The field that has the value "c03" has been formatted like so: \cyy and it is a date field. I would like to do the suggestion from BNPMike about stripping characters, but I would like to do this on a form with this new field hidden. Maybe I could create another field on a form...