Search results for query: *

Oh good lord... I was so "Sheet" concentrated that I forgot the Workbook! Thanks for the kick in the pants, Dave... Regards, Leslie

What event should you put error checking of an Excel sheet into if you want to make sure that all cells are filled in before the sheet is saved? Is it even possible? I have some lazy people working here who will fill out as little as possible and I want to be able to force them to fill out all...

John: That was it exactly!! I've put the code onto the form, put in the verbage to customize it and it's working just as I want it to. Thank you so much! I really appreciate it. Leslie

I have a table that I need to split out to different reports based on a name field. This works fine and I end up with 7 different tables. I run a Report based on each of these tables and I have some VB code running in the back of the report to make titles visible and not visible. My problem...

That was perfect, guys! Thank you so much!

Here's my issue: I need to write this in SQL, not VBA and i know that it's probably very simple, but I'm not seeing it right now. I'm not large with the text manipulation... I need to compare a four digit number from one table to a four digit number in a 2nd table. However, the four digit...

Thanks Jonfer and if I have lots of null fields? :) I'm assuming that it won't work by joining the fields in that case, right?

Is there a quick way to compare a record in two tables to determine if any changes have been made? I have two tables with 16 fields. They *should* be identical. And I know for a fact that the first 3 fields of each table will never change. What I want to do is compare the other 13 fields for...

Sorry... I meant to put that in a new thread. Please ignore.

Compare records Is there a quick way to compare a record in two tables to determine if any changes have been made? I have two tables with 16 fields. They *should* be identical. And I know for a fact that the first 3 fields of each table will never change. What I want to do is compare the...

Skip: You and Bowers are both right. It's an interesting mental exercise, but I'm off to convince my boss that it's futile and that the validation route is much better. Thank you very much for your assistance... it was very much appreciated.

Skip: I'm really appreciating all this... and I've copied and pasted your code as is. I decided that it can't be your code <g>, so it has to be something that I'm doing to cause these errors. I realized that I hadn't protected the sheet, so I did that, and now it's telling me: &quot;Unable...

Skip, I copied and pasted your code exactly as was. I'm not sure where the error is coming from. You asked what I got when I put a &quot;watch&quot; on Target.Value, and that's what I've got when it stops with the &quot;type mismatch&quot; error. Stepping through the code, Target.value never...

Mike: Thank you so much. I'm going to file this away for future reference. I would *love* to do it this way, if only for consistency's sake. But.... TBTB want it this other way. Nothing like giving me a challenge <g>

Hey Skip: This is what I get: Target.value - type variant/variant(1 to 1, 1 to 3) target.value(1,1) - value #11/03/2003# type variant/date target.value(1,2) - value Empty type variant/empty target.value(1,3) - value Empty type variant/empty

Thanks, Skip, but I'm getting a &quot;data mismatch error&quot; in the &quot;.value =&quot; line. Any idea why? Can you not use .value with a &quot;Range&quot; data type?

Hey Skip... Any hints how to do the &quot;input mask&quot; thing? <grin>

Yes, it's from a worksheet. I didn't build it, but I'm helping out. My boss wanted a different answer, but that's kinda what I figured the solution was going to be for both the date and the time references that I have. Thanks for your quick answer, Geoff!

I've got a form that's going to be used for data entry. I have cell formatting on so that dates entered come out as &quot;November 3, 2003&quot;. This works fine if someone enters &quot;11/03/03&quot;, however when you enter &quot;110303&quot; you get the date relative to January 1, 1900...

actually, that's exactly what I ended up doing. I deleted all the labels and redid them. The hardest part being that I had to name the labels the same as I had before because I'd already written the code and was NOT going to rewrite that! Thanks for your help!