Recent content by kellyboy

Just wanted to let you know, Ling, that I tried your suggestion re Conditional Formatting, and, although it took a protracted series of trial and error expressions, I finally got it to work. The result is just what I wanted, and everyone seems happy with it. Thank you. KTB

Some good suggestions here for me to play with. Thanks, all.

Thanks, John. I thought you might have the answer there so I transferred the message code from the form's current event to the on dirty event, but nothing hapens, not even an error. This is the relevant part of the current event code I moved to the on dirty event Dim proofMessages$ If...

We have a number of pop-up alert messages, which are important when dealing with a specific client, e.g. warnings that certain actions or documents are due. Problem is that these messages keep popping up when we are doing general work with the database, for example reorganizing the fields in the...

Thank you John. I thought I did reply earlier today, but can't see my message. If I follow you correctly you are suggesting that I create a new table, which would presumably include the three fields of the old table (Name, address, DOB) plus the new Remarks field. Would this replace the old...

Our database input form has several pop-up messages that are displayed when accessing certain records. For example we require proof of address for each client, so when a client comes in and we access his/her record, if the proof of address box has not been checked a message box will pop-up...

This seems so simple but I am not too advanced so forgive my naivete. I have an existing table for dependents of main clients which contains First Name, Last Name, and Date of birth. I simply want to add a text field called Remarks, which I have done. Problem is, when I enter something in the...

Thank you Bob. It looks like your last post has got me on the right track. I looked at my main form in datasheet view and found that the entries in the "date added" column were all listed as #name? even though they appeared as normal dates in form view. So I went back into form view and clicked...

Bob, the relevant dates on both tables are formatted as medium date. Yet one report is definitely acting like it has the time element. This gets curiouser and curiouser....

Thanks Bob. I follow what you are saying but at this stage of my learning I am not aware of how to find out if the date fields in our data base are "capturing and using time". We have no need for the time element, just the date. I have looked at the properties of all the date ranges and they all...

We are a charity and we have a simple data base to keep track of how many people we help and how much we pay out in food vouchers. I have several reports programmed with date range parameters, i.e. I enter a first date, then a second date, and the report gives me the results. Problem is, on some...