Recent content by simon551

I have a page that is supposed to set some cells to the values other cells. I want to be able to control setting the values back to their original values though, and override/replace what those original values are if necessary. The only part that isn't working is the part about setting the new...

OH. Right. Yes

I have a page that is supposed to set some cells to the values other cells. I want to be able to control setting the values back to their original values though, and override/replace what those original values are if necessary. The only part that isn't working is the part about setting the new...

Hi, I'm trying to pull values from a table that match an array of dates. If there is a date listed on the value table that matches my date, I'm ok, but if not I get the #N/A. Any help is appreciated. =IF( VLOOKUP(A5,'Validation Sales'!A6:H1003,8,FALSE), VLOOKUP(A5,'Validation...

Thanks. I'm not really sure what that means but I did change it to me.companyId and it is working. (It seems kind of unstable where it works sometimes but if I open the form new and try it again it doesn't work. Then I open the code source and even just look at it and it then works again.) The...

I'm getting an error message saying that the "Procedure declaration does not match description of event or procedure having the same name." Private Sub memBegDate_Click() Dim stDocName As String Dim stLinkCriteria As String stDocName = "membershipsDetail" stLinkCriteria =...

I think I figured it out. This worked: var str = Number(v.replace(/[^-0-9\.]+/g,""));

I found this code somewhere that helps me handle formatted numbers on an input. I would like to modify it so it will accept negative numbers (and not convert them to positive) function convertToDouble(v){ var str = Number(v.replace(/[^0-9\.]+/g,"")); num= (parseFloat(str)); return num; }

Thank you PHV!

Hi! I'm trying to get the Key ID field of a table in a query that takes the last date listed for each Foreign Key ID. I can group by the foreign key but if I try to get the key as well then it craps out. Can you help? SELECT MemberID, Max(ProcessDate) AS MaxDate, MembershipProcessID FROM...

Having a problem with numeric values that contain commas. This returns 2. $(document).ready(function() { var x = "2,915.75"; x= parseFloat(x); alert(x); }); Obviously I need it to return "2915.75". I'm not good with regex. Is there a simple function to do this?

awesome!

Hi all, Do you know a way to limit the number of characters that can be entered in a text field? Thanks, -s

got it! thanks! I new I was rusty!

That is the full SQL. The first table has roughly 500 records and I just want to go through the records that I need right now which are the ones that match to the second table (the temp table)which is why I create a join. I use the second query to filter the records and then I want to be able to...