How to Change value in Date Time Picker, Help PLZ

shopgirl · April 28th, 2004, 02:58 AM

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

happygv · April 29th, 2004, 12:09 AM

I have not worked with DatePicker control.

But I can suggest you with good examples of Javascript Datepicker popup controls, which is most widely used that ASP DatePicker, which is easy to handle and much faster comparitively.

Has got different dateformat examples. Link to Source code is on top of the page.
http://www.mattkruse.com/javascript/calendarpopup/

Good one indeed.
http://javascript.internet.com/calen...te-picker.html

Will update you if I find something on Activex DTPicker contol

Hope that helps.

-Vijay G

shopgirl · April 29th, 2004, 08:34 PM

Hi Viajy G...

Thank You for your replay....I did check those 2 web site and I will use one of them,I think I will using the second source because I'm looking with the icon, anyway thank you for your information I appreciate.

thanks