Recent content by DebbieC

No, there isn't a large div with all 5 groups of checkboxes in it. I thought about using one but I'm not real familiar with using them in Javascript. Would this work: <script language="javascript" type="text/javascript"> <!-- function checkCheckBoxes() { if...

Thanks for your response however I don't want them to be required to check at least one in EACH group, I just need them to check at least one in ANY group. It doesn't look like this code will work for this. Will it?

I tried this but it's not quite working. I actually have 5 checkbox groups. I only put 2 in the original code to simplify my question. I need it to only submit the form if at least one checkbox is checked in ANY group. I want it to return an error message if they don't select ANY checkboxes...

Thanks! That's exactly what I needed was the getElementByID part. Thanks again.

I have 2 sets of checkboxes and I don't want the customer to submit the form unless they have checked at least one checkbox in either set. I am giving each set of checkboxes the same name because of the code used to send the information through an e-mail. This is what I have: <script...

I got it working. I had to make a minor change: SELECT * FROM vHDIncidentLog Inner Join ( SELECT Distinct IncidentID As Incidents FROM HelpDeskIncidentDetails WHERE TimeStamp BETWEEN '1/2/2003' AND '10/2/2004' ) As A On...

Thank you. It amazes me that someone can just look at the code and come up with an answer so quickly. Unfortunately it returns this error message: Invalid column name 'IncidentId'. I'm trying to figure out which one is the problem. In the meantime you might be able to find it quicker than...

I'm not sure how to do this but I have a database that has Incidents that have an IncidentID. There are usually multiple records for an IncidentID - they are seperate events for each Incident. I was searching for the records by the timestamp date but I wouldn't get all of the events for a...

This was working until I added a link to a header. Now it defaults to January instead of December. When I remove the link to the header it works. I don't understand how that would affect it. I know that some javascripts interfere with letting others work however I can't see the code for the...

Thanks for all of your help. I had tried the cInt but it didn't work but I did it wrong. That is now working. Thanks for rewriting the ElseIf statement for me. I sometimes forget that it's easier to do that. Thanks again!!!!

I have a month and year that I am passing from another page and I want to compare it to the current date and even when they are the same it's not recognizing them as being the same. Here's the code: sMonth = Request.Form("Month") sYear = Request.Form("Year") CurrentMonth = Month(Date)...

It works great!!!!!!! Thanks!!!!!!

Well now that it's January I'm able to see if this works and it doesn't work quite right. It does for the year (it shows 2006 & 2007 in the dropdown list). However it's supposed to default to December 2006. In December it worked to default to November 2006 I guess the new year throws it off...

Thanks ESquared. Your suggestion worked. I had tried something similar to that with the float but the syntax must have been wrong because it didn't work. I had already tried converting it to a decimal but I got an error message that said: Arithmetic overflow error converting numeric to data...

I am trying to get an average of some fields and instead of 48.85 it's returning 48. How can I fix this?