CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 Access 2000 date format

Print topic Send  topic

Author Message
Brian Gubb
Posted: 05/30/2002, 5:36 AM

This is a multi-part message in MIME format.

------=_NextPart_000_000D_01C2083C.1075A2C0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

When I create a search on a date, the format is not recognized, can you =
tell me what format I should be using, general, short,... etc. Or is it =
something else I'm doing wrong.

Thanks in advance
Brian

------=_NextPart_000_000D_01C2083C.1075A2C0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2716.2200" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>When I create a search on a date, the format is not=20
recognized, can you tell me what format I should be using, general, =
short,...=20
etc. Or is it something else I'm doing wrong.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Thanks in advance</FONT></DIV>
<DIV><FONT size=3D2>Brian</FONT></DIV></BODY></HTML>

------=_NextPart_000_000D_01C2083C.1075A2C0--
Alexey Alexapolsky
Posted: 05/30/2002, 7:19 AM

This is a multi-part message in MIME format.

------=_NextPart_000_0022_01C207FD.ED1FCDC0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

You probably need to refer to this article :
http://www.gotocode.com/art.asp?art_id=3D22&#_Toc517639992

--=20
Alex
CodeCharge Developer


"Brian Gubb" <b.gubb@clear.net.nz> wrote in message =
news:ad56cd$95u$2@news.codecharge.com...
When I create a search on a date, the format is not recognized, can =
you tell me what format I should be using, general, short,... etc. Or is =
it something else I'm doing wrong.
=20
Thanks in advance
Brian

------=_NextPart_000_0022_01C207FD.ED1FCDC0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2919.6307" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>You probably need to refer to this article =
:</FONT></DIV>
<DIV><FONT size=3D2><A=20
href=3D"http://www.gotocode.com/art.asp?art_id=3D22&#_Toc517639992">h=
ttp://www.gotocode.com/art.asp?art_id=3D22&#_Toc517639992</A></FONT><=
/DIV>
<DIV><BR>-- <BR>Alex<BR>CodeCharge Developer</DIV>
<DIV> </DIV>
<DIV> </DIV>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: =
0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV>"Brian Gubb" <<A=20
href=3D"mailto:b.gubb@clear.net.nz">b.gubb@clear.net.nz</A>> wrote =
in message=20
<A=20
=
href=3D"news:ad56cd$95u$2@news.codecharge.com">news:ad56cd$95u$2@news.cod=
echarge.com</A>...</DIV>
<DIV><FONT size=3D2>When I create a search on a date, the format is =
not=20
recognized, can you tell me what format I should be using, general, =
short,...=20
etc. Or is it something else I'm doing wrong.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Thanks in advance</FONT></DIV>
<DIV><FONT size=3D2>Brian</FONT></DIV></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_0022_01C207FD.ED1FCDC0--
Brian Gubb
Posted: 05/30/2002, 7:49 AM

This is a multi-part message in MIME format.

------=_NextPart_000_0063_01C2084E.96D7EDC0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi Alex,
I put that code into my Open Event, still nothing happens. I don't get =
an error message, I just have the same grid as I started with. Text =
fields search fine, just the date won't and that's the in I need most.

Brian
"Alexey Alexapolsky" <alexa@codecharge.com> wrote in message =
news:ad5ccs$luo$2@news.codecharge.com...
You probably need to refer to this article :
http://www.gotocode.com/art.asp?art_id=3D22&#_Toc517639992

--=20
Alex
CodeCharge Developer


"Brian Gubb" <b.gubb@clear.net.nz> wrote in message =
news:ad56cd$95u$2@news.codecharge.com...
When I create a search on a date, the format is not recognized, can =
you tell me what format I should be using, general, short,... etc. Or is =
it something else I'm doing wrong.

Thanks in advance
Brian

------=_NextPart_000_0063_01C2084E.96D7EDC0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2716.2200" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>Hi Alex,</FONT></DIV>
<DIV><FONT size=3D2>I put that code into my Open Event, still nothing =
happens. I=20
don't get an error message, I just have the same grid as I started with. =
Text=20
fields search fine, just the date won't and that's the in I need=20
most.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Brian</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Alexey Alexapolsky" <<A=20
href=3D"mailto:alexa@codecharge.com">alexa@codecharge.com</A>> =
wrote in=20
message <A=20
=
href=3D"news:ad5ccs$luo$2@news.codecharge.com">news:ad5ccs$luo$2@news.cod=
echarge.com</A>...</DIV>
<DIV><FONT size=3D2>You probably need to refer to this article =
:</FONT></DIV>
<DIV><FONT size=3D2><A=20
=
href=3D"http://www.gotocode.com/art.asp?art_id=3D22&#_Toc517639992">h=
ttp://www.gotocode.com/art.asp?art_id=3D22&#_Toc517639992</A></FONT><=
/DIV>
<DIV><BR>-- <BR>Alex<BR>CodeCharge Developer</DIV>
<DIV> </DIV>
<DIV> </DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Brian Gubb" <<A=20
href=3D"mailto:b.gubb@clear.net.nz">b.gubb@clear.net.nz</A>> =
wrote in=20
message <A=20
=
href=3D"news:ad56cd$95u$2@news.codecharge.com">news:ad56cd$95u$2@news.cod=
echarge.com</A>...</DIV>
<DIV><FONT size=3D2>When I create a search on a date, the format is =
not=20
recognized, can you tell me what format I should be using, general,=20
short,... etc. Or is it something else I'm doing wrong.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Thanks in advance</FONT></DIV>
<DIV><FONT =
size=3D2>Brian</FONT></DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_0063_01C2084E.96D7EDC0--
Alexey Alexapolsky
Posted: 05/31/2002, 6:19 AM

This is a multi-part message in MIME format.

------=_NextPart_000_007C_01C207F5.9B71BEA0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I suppose that your web page does not produce any errors.
Print out value of sSQL variable in grid form/open event ,=20
and see it's value when search is done. may be this will help make it =
clear.

--=20
Alex
CodeCharge Developer


"Brian Gubb" <b.gubb@clear.net.nz> wrote in message =
news:ad5e57$pda$1@news.codecharge.com...
Hi Alex,
I put that code into my Open Event, still nothing happens. I don't get =
an error message, I just have the same grid as I started with. Text =
fields search fine, just the date won't and that's the in I need most.
=20
Brian
"Alexey Alexapolsky" <alexa@codecharge.com> wrote in message =
news:ad5ccs$luo$2@news.codecharge.com...
You probably need to refer to this article :
http://www.gotocode.com/art.asp?art_id=3D22&#_Toc517639992

--=20
Alex
CodeCharge Developer


"Brian Gubb" <b.gubb@clear.net.nz> wrote in message =
news:ad56cd$95u$2@news.codecharge.com...
When I create a search on a date, the format is not recognized, =
can you tell me what format I should be using, general, short,... etc. =
Or is it something else I'm doing wrong.
=20
Thanks in advance
Brian

------=_NextPart_000_007C_01C207F5.9B71BEA0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2919.6307" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>I suppose that your web page does not produce any=20
errors.</FONT></DIV>
<DIV><FONT size=3D2>Print out value of sSQL variable in grid form/open =
event ,=20
</FONT></DIV>
<DIV><FONT size=3D2>and see it's value when search is done. may be this =
will help=20
make it clear.</FONT></DIV>
<DIV><BR>-- <BR>Alex<BR>CodeCharge Developer</DIV>
<DIV> </DIV>
<DIV> </DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: =
0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV>"Brian Gubb" <<A=20
href=3D"mailto:b.gubb@clear.net.nz">b.gubb@clear.net.nz</A>> wrote =
in message=20
<A=20
=
href=3D"news:ad5e57$pda$1@news.codecharge.com">news:ad5e57$pda$1@news.cod=
echarge.com</A>...</DIV>
<DIV><FONT size=3D2>Hi Alex,</FONT></DIV>
<DIV><FONT size=3D2>I put that code into my Open Event, still nothing =
happens. I=20
don't get an error message, I just have the same grid as I started =
with. Text=20
fields search fine, just the date won't and that's the in I need=20
most.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Brian</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; =
MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV>"Alexey Alexapolsky" <<A=20
href=3D"mailto:alexa@codecharge.com">alexa@codecharge.com</A>> =
wrote in=20
message <A=20
=
href=3D"news:ad5ccs$luo$2@news.codecharge.com">news:ad5ccs$luo$2@news.cod=
echarge.com</A>...</DIV>
<DIV><FONT size=3D2>You probably need to refer to this article =
:</FONT></DIV>
<DIV><FONT size=3D2><A=20
=
href=3D"http://www.gotocode.com/art.asp?art_id=3D22&#_Toc517639992">h=
ttp://www.gotocode.com/art.asp?art_id=3D22&#_Toc517639992</A></FONT><=
/DIV>
<DIV><BR>-- <BR>Alex<BR>CodeCharge Developer</DIV>
<DIV> </DIV>
<DIV> </DIV>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; =
MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV>"Brian Gubb" <<A=20
href=3D"mailto:b.gubb@clear.net.nz">b.gubb@clear.net.nz</A>> =
wrote in=20
message <A=20
=
href=3D"news:ad56cd$95u$2@news.codecharge.com">news:ad56cd$95u$2@news.cod=
echarge.com</A>...</DIV>
<DIV><FONT size=3D2>When I create a search on a date, the format =
is not=20
recognized, can you tell me what format I should be using, =
general,=20
short,... etc. Or is it something else I'm doing =
wrong.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Thanks in advance</FONT></DIV>
<DIV><FONT=20
size=3D2>Brian</FONT></DIV></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY>=
</HTML>

------=_NextPart_000_007C_01C207F5.9B71BEA0--
Brian Gubb
Posted: 05/31/2002, 7:49 AM

This is a multi-part message in MIME format.

------=_NextPart_000_0019_01C20917.BB969160
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Thanks Alex, it's working now. Brian
"Alexey Alexapolsky" <alexa@codecharge.com> wrote in message =
news:ad7t9h$dlm$2@news.codecharge.com...
I suppose that your web page does not produce any errors.
Print out value of sSQL variable in grid form/open event ,=20
and see it's value when search is done. may be this will help make it =
clear.

--=20
Alex
CodeCharge Developer


"Brian Gubb" <b.gubb@clear.net.nz> wrote in message =
news:ad5e57$pda$1@news.codecharge.com...
Hi Alex,
I put that code into my Open Event, still nothing happens. I don't =
get an error message, I just have the same grid as I started with. Text =
fields search fine, just the date won't and that's the in I need most.

Brian
"Alexey Alexapolsky" <alexa@codecharge.com> wrote in message =
news:ad5ccs$luo$2@news.codecharge.com...
You probably need to refer to this article :
http://www.gotocode.com/art.asp?art_id=3D22&#_Toc517639992

--=20
Alex
CodeCharge Developer


"Brian Gubb" <b.gubb@clear.net.nz> wrote in message =
news:ad56cd$95u$2@news.codecharge.com...
When I create a search on a date, the format is not recognized, =
can you tell me what format I should be using, general, short,... etc. =
Or is it something else I'm doing wrong.

Thanks in advance
Brian

------=_NextPart_000_0019_01C20917.BB969160
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2716.2200" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>Thanks Alex, it's working now. Brian</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Alexey Alexapolsky" <<A=20
href=3D"mailto:alexa@codecharge.com">alexa@codecharge.com</A>> =
wrote in=20
message <A=20
=
href=3D"news:ad7t9h$dlm$2@news.codecharge.com">news:ad7t9h$dlm$2@news.cod=
echarge.com</A>...</DIV>
<DIV><FONT size=3D2>I suppose that your web page does not produce any=20
errors.</FONT></DIV>
<DIV><FONT size=3D2>Print out value of sSQL variable in grid form/open =
event ,=20
</FONT></DIV>
<DIV><FONT size=3D2>and see it's value when search is done. may be =
this will=20
help make it clear.</FONT></DIV>
<DIV><BR>-- <BR>Alex<BR>CodeCharge Developer</DIV>
<DIV> </DIV>
<DIV> </DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Brian Gubb" <<A=20
href=3D"mailto:b.gubb@clear.net.nz">b.gubb@clear.net.nz</A>> =
wrote in=20
message <A=20
=
href=3D"news:ad5e57$pda$1@news.codecharge.com">news:ad5e57$pda$1@news.cod=
echarge.com</A>...</DIV>
<DIV><FONT size=3D2>Hi Alex,</FONT></DIV>
<DIV><FONT size=3D2>I put that code into my Open Event, still =
nothing happens.=20
I don't get an error message, I just have the same grid as I started =
with.=20
Text fields search fine, just the date won't and that's the in I =
need=20
most.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Brian</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Alexey Alexapolsky" <<A=20
href=3D"mailto:alexa@codecharge.com">alexa@codecharge.com</A>> =
wrote in=20
message <A=20
=
href=3D"news:ad5ccs$luo$2@news.codecharge.com">news:ad5ccs$luo$2@news.cod=
echarge.com</A>...</DIV>
<DIV><FONT size=3D2>You probably need to refer to this article=20
:</FONT></DIV>
<DIV><FONT size=3D2><A=20
=
href=3D"http://www.gotocode.com/art.asp?art_id=3D22&#_Toc517639992">h=
ttp://www.gotocode.com/art.asp?art_id=3D22&#_Toc517639992</A></FONT><=
/DIV>
<DIV><BR>-- <BR>Alex<BR>CodeCharge Developer</DIV>
<DIV> </DIV>
<DIV> </DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Brian Gubb" <<A=20
href=3D"mailto:b.gubb@clear.net.nz">b.gubb@clear.net.nz</A>> =
wrote in=20
message <A=20
=
href=3D"news:ad56cd$95u$2@news.codecharge.com">news:ad56cd$95u$2@news.cod=
echarge.com</A>...</DIV>
<DIV><FONT size=3D2>When I create a search on a date, the format =
is not=20
recognized, can you tell me what format I should be using, =
general,=20
short,... etc. Or is it something else I'm doing =
wrong.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Thanks in advance</FONT></DIV>
<DIV><FONT=20
size=3D2>Brian</FONT></DIV></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCK=
QUOTE></BODY></HTML>

------=_NextPart_000_0019_01C20917.BB969160--

   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.