Another oddball problem I just ran into

Another oddball problem I just ran into

Post by cdoyl » Thu, 01 Sep 2005 03:38:22


OK,
I have a page, that has the MS date and time picker active X control on
it.

The control is pointed to my date field in my table.
What it's suppose to do is, when the user brings up the page the
control should list the date that was entered into the DB, and then
modify it using the calendar if needed.

But instead, when they bring up the page. All the dates appear the
same (it appears to bring up the date when I created the control)

But now here is the real kicker, when I view the page. It works great!
I didn't even know anything was wrong until somebody else told me
about it.

Any ideas, to why it works for me? but nobody else?

Chris.
 
 
 

Another oddball problem I just ran into

Post by Paul » Thu, 01 Sep 2005 07:43:57


: OK,
: I have a page, that has the MS date and time picker active X control on
: it.
:
: The control is pointed to my date field in my table.
: What it's suppose to do is, when the user brings up the page the
: control should list the date that was entered into the DB, and then
: modify it using the calendar if needed.
:
: But instead, when they bring up the page. All the dates appear the
: same (it appears to bring up the date when I created the control)
:
: But now here is the real kicker, when I view the page. It works great!
: I didn't even know anything was wrong until somebody else told me
: about it.
:
: Any ideas, to why it works for me? but nobody else?
:
: Chris.
:
Can't tell you why it works for you, I know I had this problem on all my
machines running Windows 2k. Unfortunately, to fix it I don't remember the
exact param field but this should point you in the right direction. You
need to use notepad to open the html file and delete a param name field, if
you try to delete it while using the script editor, it will put the field
back when you save. I don't remember the exact name, but it is something
like "Date" or "TodayDate" or similar (see below for style of entry, this is
NOT the field to delete).
<PARAM NAME="MaxDate" VALUE="2958465">
Do a search for your OBJECT id = "your id of control", then look for a param
with the date value you are looking for. The dates are not in regular date
format, I think they are in Julian or some other format. You can use excel
to convert the date for you or some webpages will do it. Where you find
this number after the VALUE= field then delete that entire parameter
starting with the < and ending with the >. This should force the control
not to override the date from the database.
Paul D

 
 
 

Another oddball problem I just ran into

Post by cdoyl » Thu, 01 Sep 2005 23:17:24

I deleted one called
<PARAM NAME="CurrentDate" VALUE="36494">

but when I had someone else test it, they still got 8/31/05 on every
record (still works for me tho)

Here are my other parameters I have on the control, maybe I deleted the
wrong one?
<OBJECT id=ActiveXCtl0 title=""
style="Z-INDEX: 4; LEFT: 0.125in; WIDTH: 232px; POSITION: absolute;
TOP: 0.708in; HEIGHT: 28px"
tabIndex=18 classid=CLSID:20DD1B9E-87C4-11D1-8BE3-0000F8754DA1
ActiveXCtl0><PARAM NAME="_ExtentX" VALUE="6138"><PARAM NAME="_ExtentY"
VALUE="741"><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="0"><PARAM
NAME="Format" VALUE="662831105"><PARAM NAME="UpDown" VALUE="0"><PARAM
NAME="MaxDate" VALUE="2958465"><PARAM NAME="MinDate"
VALUE="-109205"></OBJECT>
 
 
 

Another oddball problem I just ran into

Post by cdoyl » Fri, 02 Sep 2005 22:54:17

OK,
I had the other users send me screen shot of an Active X error they
said are receiving.

It says

An Active X control on this page is not safe
Your current security settings prohibit running unsafe controls on this
page
As a result, this page may not display properly.

So does anyone know how to make this a 'safe' active X control?

Thanks
Chris.
 
 
 

Another oddball problem I just ran into

Post by Paul » Sat, 03 Sep 2005 03:31:21

< XXXX@XXXXX.COM > wrote
: OK,
: I had the other users send me screen shot of an Active X error they
: said are receiving.
:
: It says
:
: An Active X control on this page is not safe
: Your current security settings prohibit running unsafe controls on this
: page
: As a result, this page may not display properly.
:
: So does anyone know how to make this a 'safe' active X control?
:
: Thanks
: Chris.


I'm not aware of any way to make it safe, however you can relax your
security to allow the control to be used. In Internet Explorer select the
tools pull-down menu then internet options. Select the security tab and
select the zone you are running the DAP from. I run all of ours from our
server so I added our server to the trusted sites zone. After selecting you
zone, select the custom level... button and enable the activeX options you
need. Since I have my server and nothing elsed on the trusted site zone, I
just set everything to enabled.
Paul D
 
 
 

Another oddball problem I just ran into

Post by cdoyl » Sat, 03 Sep 2005 04:28:22

Yep, that's exactly what we just found out, and did.

Glad it worked, I wasn't happy about finding out that it wasn't working
for everyone.
I'm so close to being done with this project!!

thanks again
Chris.
 
 
 

Another oddball problem I just ran into

Post by Show 'Em O » Mon, 31 Oct 2005 10:45:30

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George
 
 
 

Another oddball problem I just ran into

Post by Show 'Em O » Mon, 31 Oct 2005 10:45:30

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George
 
 
 

Another oddball problem I just ran into

Post by Show 'Em O » Mon, 31 Oct 2005 10:45:30

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George
 
 
 

Another oddball problem I just ran into

Post by Show 'Em O » Mon, 31 Oct 2005 10:45:31

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George
 
 
 

Another oddball problem I just ran into

Post by Show 'Em O » Mon, 31 Oct 2005 10:45:31

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George
 
 
 

Another oddball problem I just ran into

Post by Show 'Em O » Mon, 31 Oct 2005 10:45:32

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George