Recent content by svsuthar1

Thanks guys, Hi mwolf00, adam0101, I know about database connection at client side, but that is too late for me to verify what the user has entered is correct. I don't want to use a combo box because i have to many records and combo box would be to time consuming for use to go through and...

Hi, Is it any way you could connect to database with javascript to validate your form data with database table. For Ex. I have text field on a form and wanted to make sure what is entered there is in the database table so when it's trying to save that into a table it does not give a error...

Thanks nicklieb, you saved my day today.. I really appreciate it.

Thanks alot nicklieb, One more question how can i make this link pop on a new page instead on the same page. Thanks, Samir

Hey guys, I am not sure what it means with this type of error. The code is below. Response.Write("<TD><A href="\..\ErrorImage\" & objRS("fldErrorImage") & ".pdf><B>View</B></A>

Wow thanks guys, I got it to work with your ideas. I was able to extract Year out of the date field and was able to sort by year and able to use loop to give what I wanted. Thanks guys. DreXor, How would you do what you are talking about can you help with any examples.

I want to show all three Year at the same time one right after another. My SQL could be for 3 year combined. I just don't know how to loop through to give me the same format. Samir

Hey Team, I have the below code working the way I want for one Year, and I could create 2 other connection and recordset and get this code to work for the other 2 years. But I want to do this by one connection and one recodset. I want to loop through all 3 years and and display it same way...

Thank, I can't believe that I totally forgot about this. Thank you so much... I think gave up too easy. Thank I really appreciated. Samir

Below is the code of what I am trying to but am not able to get it show properly. <A Alt="" href="CustomerByMonth.asp?fldInternal=0&Year=strYear">Errors By Customer</A>

Thanks mwolf00 I really appreciated. I should have tried all the combination. I know it was with "#" signs I was not doing it correctly. Thank you very much. Samir

Can I know what I am missing in the following line of code & "WHERE fldDate Between #" & strStartDate & #" and #" & strEndDate & #" _

Thank, I think it makes sense. Samir

Thank you that was it. Samir

I have the following error please help identify what it is... Syntax error in query expression '(((tblCategory.fldCategoryID)=4 AND ((tblInventoryData.fldActionID)=2));' Here is my SQL strSQL ="SELECT fldProductName, Sum(IIf(DatePart(""m"",[fldDate])=1,[fldQuantity],0)) AS Jan...