Recent content by kujeremy

Thanks again - I've either implemented wrong or something. I added a new column to the query that brings back this report information: Field -> Expr1:[LastWeek] Criteria -> LastWeekday(Date(),1) I then added conditional formatting to the field on the report of: Expression Is: [End_Date] =...

Minty - thanks for the reply, I do not believe that I am following correctly or at minimum doing something incorrect. What I did was: Went to the Visual Basic screen -> made a new module and copied the code you supplied and saved. So now I have a "Module2" with your code. Then - went to...

I have a report set up and I can successfully format all returned rows for a given column as I want them. However, what I want to do is only format the latest row on the report. The table that the record comes from does include an End_Date field which is also populated on the row, and the data...

Bam! Messing with CF again. I had played with it earlier and used "Active" changed that to 2 and it immediately worked. Once again, thanks for looking into!

Unfortunately I better not upload the DB here - if I did I would probably have my internal security people at my desk within minutes, and I recently had my wrist slapped for downloading screen capture software - to which they've now spent 3 weeks analyzing that PC to see if it was compromised (I...

Yes - I've tried it with quotes also and it didn't work. I also tried 2 and "2" as that is the numerical ID that "Active" has on the table, it did not work either. Tried conditional formatting also with no luck. Truth be told, I was trying it with code because when the condition was met there...

Hello - I am stuck with trying to accomplish the following and was hoping for some assistance! I have a report which I would like to change the text of a field blue if a certain condition is met. What I want to happen on this report is if a specific field has an "Active" - then it will be in...

Thanks for the additional input. I was in a hurry to get somewhere and didn't have a chance to look beyond the microsoft site where it said it was for Excel 2010. Unfortunately I can't even give this a try right now on 2007 because our computers are very locked down, I'll have to make a...

That (Fully lookup) looks like it would do the trick, except for one problem....it's for Excel 2010 and we're on 2007. I have no access to 2010 and even if I did it would be a serious no no to move this data outside of my companies network. Thanks for that suggestion though

Does anyone know of a way to compare values in two cells and determine if there is only a character or two difference? I've been asked to find a way to compare two addresses and identify if they are minutely different, such as: 123 Main St vs 123 Main Str They want to be able to easily...

Thanks! That works exactly as expected! Very much appreciated

Devine a syntax? LOL. Anyhow - it is your exact code copied and pasted in the BeforeUpdate event - the only change I made was the field name to "Index_Date". The "If Me.Index..." line is highlighted red and I receive the aforementioned error. Private Sub Index_Date_BeforeUpdate(Cancel As...

Hi Pat - I'm trying to use your code as you have below but continue to get a compile error : Syntax error on the > sign Any suggestions on why that error is being received?

Pat - after the last 2013 record is entered everything will be for the next year, but you make a great point because the db has been in use since I first made it about 4 years ago - it is one I made for myself years ago because when I took over the process a spreadsheet was being used, but this...

Thanks for the suggestion Adam - however doing as you suggest is not working. Whenever I apply that mask to the field on the form I get: The value you entered isn't valid for this field. For example, you may have entered text in a numeric field or a number that is larger than the FieldSize...