Hi,
I hope I post my question in the right forum...
I never been using ActiveX before so I really need help...:(PLEEEEESSSEEEEEE.....Thank's in advance
I'm using DTPicker in my Update.asp page. If User want to do update to their data,the date will show in DTPicker box where the Date already been save in the Access table, but when the User click on the DTPicker the Calender will show too.
is it Possible?
Could someone helping me, any kind of help appreciate
here's my Code:
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<TITLE></TITLE>
</HEAD>
<BODY bgcolor=Bisque >
<CENTER><H1>UPDATE EMPLOYEE DATA</H1></CENTER><BR>
<BR>
<%
Response.Write "<b><CENTER>" & ("WELCOME ") & Session("UseID")& "</CENTER></b>"
Dim intID, varSName, varAddress
Dim intPhoneHome, intPostalCode
Dim Entry, Salary
Dim strsql
Dim Conn, rsData
Dim strConnect
Dim strCounts
Dim LngRecordNo
intID = Trim(Request("EmpID"))
Set Conn = Server.CreateObject ("ADODB.CONNECTION")
Set rsData = Server.CreateObject ("ADODB.Recordset")
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\TblEmploy.mdb"
Set rsData = Conn.Execute("Select * From Data Where EmployeeID=" & intID & "")
If rsData.BOF AND rsData.EOF then
Response.Write ("<CENTER><H2> No RECORD
FOUND</H2></CENTER>")
End if
%>
<FORM ACTION= "ConfirmUpdate.asp" METHOD=post Name=frmConfirm >
<CENTER>
<% Do While Not rsData.EOF %>
<TABLE style="WIDTH: 475px; HEIGHT: 172px" cellSpacing=1 cellPadding=1 width=402 border=1>
<TR><TD bgcolor="#ffffcc"><P>EmployeeID</P></TD>
<TD bgcolor="#ffffcc"><INPUT type="text" name="EmpID" value="<%=rsData("EmployeeID") %>"></TD></TR>
<TR><TD bgcolor="#ffffcc"><P>EmployeeName</P></TD>
<TD bgcolor="#ffffcc"><INPUT type="text" name="EmpName" value="<%=rsData("EmployeeName")%>"></TD></TR>
<TR><TD bgcolor="#ffffcc">EmployeeAddress</TD>
<TD bgcolor="#ffffcc"><INPUT type="text" name="EmpAddress" value="<%=rsData("EmployeeAddress")%>"></TD></TR>
<TR><TD bgcolor="#ffffcc">EmployeePhoneHome</TD>
<TD bgcolor="#ffffcc"><INPUT type="text" name="EmpPhone" value="<%=rsData("EmployeePhoneHome")%>"></TD></TR>
<TR><TD bgcolor="#ffffcc">EmployeePostalCode</TD>
<TD bgcolor="#ffffcc"><INPUT type="text" name="EmpPostal" value="<%=rsData("EmployeePostalCode")%>"></TD></TR>
<TR><TD bgcolor="#ffffcc">EmployeeDateEntry</TD>
<TD bgcolor="#ffffcc">
<OBJECT id=DTPicker1 style="LEFT: 0px; WIDTH: 107px; TOP: 0px; HEIGHT: 26px" name=EmpDate
classid=clsid:20DD1B9E-87C4-11D1-8BE3-0000F8754DA1 width=107 height=26 VIEWASTEXT>
<PARAM NAME="_ExtentX" VALUE="2831">
<PARAM NAME="_ExtentY" VALUE="688">
<PARAM NAME="_Version" VALUE="393216">
<PARAM NAME="MousePointer" VALUE="0">
<PARAM NAME="Enabled" VALUE="1">
<PARAM NAME="OLEDropMode" VALUE="0">
<PARAM NAME="CalendarBackColor" VALUE="-2147483643">
<PARAM NAME="CalendarForeColor" VALUE="-2147483630">
<PARAM NAME="CalendarTitleBackColor" VALUE="-2147483633">
<PARAM NAME="CalendarTitleForeColor" VALUE="-2147483630">
<PARAM NAME="CalendarTrailingForeColor" VALUE="-2147483631">
<PARAM NAME="CheckBox" VALUE="0">
<PARAM NAME="CustomFormat" VALUE="">
<PARAM NAME="DateIsNull" VALUE="1">
<PARAM NAME="Format" VALUE="662831105">
<PARAM NAME="UpDown" VALUE="0">
<PARAM NAME="CurrentDate" VALUE="38103">
<PARAM NAME="MaxDate" VALUE="2958465">
<PARAM NAME="MinDate" VALUE="-109205"></OBJECT>
</TD></TR>
<TR><TD bgcolor="#ffffcc">EmployeeSalary</TD>
<TD bgcolor="#ffffcc"><INPUT type="text" name="EmpSalary" value="<%=rsData("EmployeeSalary")%>" ></TD></TR>
</TABLE></P>
<P><CENTER><INPUT id=submit1 style="WIDTH: 85px; HEIGHT: 40px" type=Submit size=28 value=UPDATE name=update>
<INPUT type="button" value=CANCEL OnClick="location.href='MainPage.asp'" style="WIDTH: 88px; HEIGHT: 42px" size=22 id=button1 name=button1>
<%
rsData.MoveNext
Loop
set rsData= Nothing
%>
<INPUT type="button" value=BACK OnClick="location.href='SearchUpdate.asp'" style="WIDTH: 88px; HEIGHT: 42px" size=22 id=button2 name=button2></CENTER></P>
<P> </P>
</FORM>
</BODY>
</HTML>
thank's
How to Change value in Date Time Picker, Help PLZ
Linear Mode
