Search results

That's perfect!! Thanks

I want to add a check to a form to see if a duplicate value exists. I have done this with a table by using no duplicates allowed. In this case, I want duplicates, but just want to be made aware of them, not a hard stop. Any ideas where in the field properties I can do this? Am I in the right...

Thanks for the tip, I got what I needed!!

I am looking for an easy way to enforce Title case when typing in a name in a forms text box. I thought I had an example I had used before, but am having no luck. Thanks in advance Mike G

That's what I was asking, so you nailed it! Thanks

So, if I am reading this correctly, have the time elapsed calculated in a queery, where from I can report on it?

You're exactly right, I wasn't thinking, and just opened it directly from the ZIP. In your time calculation, it doesn't appear that you are saving it to a table is that correct?

Still no go unfortunately....also, with the Read Only, there is no way to add my ID to the list.

This looks great, although I have to look at it in design mode, as I think it's read only, and isn't displaying any fields in form view. having said that, you have given me some great ideas, or at least I can see how you did several pieces of functionality I was considering. Thanks a bunch! MG

Within our warehouses, delivery notes are created, and used to pick materials to ship. A time stamp is used to clock when the pick list went to the floor, and then when it was checked in (complete). I have created a simple 6 field form for data entry. I was using a clock function I found on...

Rural guy, so that I am clear, you are referring to the "On Current" event, correct? I still am fuzzy on the last piece of code you are referring to. As of now, there is no event associated with the On Current. Thanks MG

Has anyone on the list created or used a time clock form i.e. Punch in/Punch out like a time card? I am interested in how it worked, and compare against what I am doing. Thanks in advance. Mike G

I am looking for a way to lock an entire record down after a save has been executed. This may seem strange, but my form is 6 fields, and records do not/should not need to be updated once entered (via the form). Having said that, I am looking at locking at the form level, but having access at the...

Thanks for the assistance, I feel pretty dumb now, as I knew that going to a new record saved the previous record. Thanks again!!

I am looking to add a save button to a form, and following the save, open the form in a new record. Thanks in advance