Recent content by Dausa67

Good morning, My MIS guy can’t find a solution so I am asking my Tek-Tips friends. GENERAL INFORMATION My manager and I use Microsoft OneNote and collaborate on a regular basis throughout the day every day at work. In an effort to be more mobile my company has replaced our PCs with a laptops...

Good morning, Question: Is it possible to get my sql statements from old Crystal Report files that I have on my PC? The problem (short version): Many years ago my company bought me Crystal Reports XI. My company paid for my training to use CR XI. My PC crashed and my MIS department decided...

Good Morning, I am trying to set a Validation based on the Assigned To field. I am not sure if it is possible or at least what I have tried so far has not worked. I am hoping that someone can correct my formula so this will work. Overview We are using Share Point 2007 to assign tasks which flow...

I totally agree. Unfortunately it is engineers that are entering the data that don't care about the downstream users. Clay

Kray, Not every part number has the hidden character on the end so that will not work. Skip, unfortunately the files come from multiple sources in France. I have requested that they be aware of this but was introduced to brick walls. Clay

SKIP, I did what you suggested but it is still not visible to the eye (unless) I change the font. Dhookom, I don't think that I have ever done a user-defined function in Excel. Is that something that you can easily explain to me? Clay

Good morning, PROBLEM I am having trouble systematically removing a hidden character or space from part numbers. DETAILS 1. Table is linked to an excel sheet where the hidden character problem starts. 2. Each excel sheet is different in size. 3. Not every part number has the hidden character...

Hello, I am trying to name a formula and I can't figure out how to do this. I am working on a list in SharePoint and I have a calculated field with a formula. I would like to have the field display a name rather than the formula. Below is the formula...

Thank you for all of the responses. I am using data sheet view. Can it be done in data sheet view? Clay

Thank you for the quick response. TimerInterval is 1000 Clay

Good morning, This is what I am trying to do but it is not working. **If Required Date is less than todays date then flash. I have not used VBA but a few times so I am having trouble figuring out what I am doing wrong. The background is not flashing. Below is my code: Private Sub...

Thank you Skip. That worked perfectly. Clay

Good morning, I have a text field in a query that contains 3 sets if data that I am trying to pull out. I have tried using the Switch function and the IIF but when I combine more than one statement it does not work. I am using ACCESS 2003 and do not know VBA. Below is not code but just a...

That is what I needed. Thank you for your help. Clay

I followed what you said and I am able to make it work except for the last one "X In Inspection". How do I address this when the value is null? Do I somehow change Null value to "X"? Clay