AboutSrini Nagarajan Expertise I can answer any kind of questions in ASP.NET, C#, VB.NET, SharePoint 2007, ASP, Coldfusion, Powerbuilder 7.00 / 8.00, JAVA servlets, MS SQL 2000 / MSSQL7, Sybase
Experience Contact me if you need any custom development on ASP.NET, ASP, SharePoint 2007, Coldfusion, Powerbuilder.
Question QUESTION: I try display multi page between start date and end date,while running 1st page diplay record click next page
date error ,how can sort out the error,am using ms access and asp
ANSWER: hi,
sorry for the delay in reply.
you need to convert the string to date format before pass as start date or end date.
-Srini
---------- FOLLOW-UP ----------
QUESTION: I format date string even 2nd page click(error messageMicrosoft JET Database Engine (0x80040E07)
Syntax error in date in query expression 'dep_date >= ## and dep_date <= ##'.)
strSQL = ("Select * From departure Where dep_date >= #" & date1 & "# and dep_date <= #" & date2 & "# order by dep_date")
Answer hi
where the date1 and date2 to get filled?
in page 2 the date1 and date2 are blank so you are getting this error.
if you are getting the date value from request form or query string, you need to pass the date1 and date2 value when you goto page 2.
