Netadvantage Ultracombo & date time problem

Hi

I have this application that I am fighting with for days now. Here is the
whole project; www.infovis.biz/tasks.zip. Please run and press the new task
button to see what I mean. Much of the code is either form taskvision or
infragistics samples btw and requires netadvantage 2004 vol2.

I have the following problems with this and would appreciate any help I can
get;

1. When I click in the clients field, I then click on any other field the
cursor is stuck in the client field requiring an entry to be typed or
selected. How can I make it so I can leave this field blank if I want to?

2. When a value is typed in the subject, details etc. fields, the time part
of 'Remind date' disappears.

3. In any event, the remind date & time are not being stored properly in the
tbltasks table in the access database. Not sure where in the code these
values are lost even though I can see them on the screen when saving the new
task form.

4. When I type a value in any field apart from client field, a 0 appears in
the client field if it is blank. How can I avoid that?

Thanks

Regards

Ron
Thu Aug 05 12:42:35 CDT 2004

John,
I suggest you ask this in the infragistics.dotnet.wingrid newsgroup at
news.infragistics.com (or webgrid if this is a web application). For the
date field make sure the parameters generated for the Update and Insert
commands have the type of this field as OleDbType.Date vs. DbDate. The
wizards can set this incorrectly and this would result in the time part
vanishing when being stored.

Ron Allen
"John" <john@nospam.infovis.co.uk> wrote in message
news:uQIMz1weEHA.2764@TK2MSFTNGP11.phx.gbl...
> Hi
>
> I have this application that I am fighting with for days now. Here is the
> whole project; www.infovis.biz/tasks.zip. Please run and press the new
task
> button to see what I mean. Much of the code is either form taskvision or
> infragistics samples btw and requires netadvantage 2004 vol2.
>
> I have the following problems with this and would appreciate any help I
can
> get;
>
> 1. When I click in the clients field, I then click on any other field the
> cursor is stuck in the client field requiring an entry to be typed or
> selected. How can I make it so I can leave this field blank if I want to?
>
> 2. When a value is typed in the subject, details etc. fields, the time
part
> of 'Remind date' disappears.
>
> 3. In any event, the remind date & time are not being stored properly in
the
> tbltasks table in the access database. Not sure where in the code these
> values are lost even though I can see them on the screen when saving the
new
> task form.
>
> 4. When I type a value in any field apart from client field, a 0 appears
in
> the client field if it is blank. How can I avoid that?
>
> Thanks
>
> Regards
>
>

Ron
Thu Aug 05 14:50:25 CDT 2004

John,
I've looked at your program and you need to change the OleDbType.DBDate
types to OleDbType.Date for your date parameters in your code. I'm not sure
about the focus not leaving the UltraCombo since its' type is DropDown. You
may just have to type something in it.

Ron Allen
"Ron Allen" <rallen@_nospam_src-us.com> wrote in message
news:u8AkgOxeEHA.2916@TK2MSFTNGP12.phx.gbl...
> John,
> I suggest you ask this in the infragistics.dotnet.wingrid newsgroup at
> news.infragistics.com (or webgrid if this is a web application). For the
> date field make sure the parameters generated for the Update and Insert
> commands have the type of this field as OleDbType.Date vs. DbDate. The
> wizards can set this incorrectly and this would result in the time part
> vanishing when being stored.
>
> Ron Allen
> "John" <john@nospam.infovis.co.uk> wrote in message
> news:uQIMz1weEHA.2764@TK2MSFTNGP11.phx.gbl...
> > Hi
> >
> > I have this application that I am fighting with for days now. Here is
the
> > whole project; www.infovis.biz/tasks.zip. Please run and press the new
> task
> > button to see what I mean. Much of the code is either form taskvision or
> > infragistics samples btw and requires netadvantage 2004 vol2.
> >
> > I have the following problems with this and would appreciate any help I
> can
> > get;
> >
> > 1. When I click in the clients field, I then click on any other field
the
> > cursor is stuck in the client field requiring an entry to be typed or
> > selected. How can I make it so I can leave this field blank if I want
to?
> >
> > 2. When a value is typed in the subject, details etc. fields, the time
> part
> > of 'Remind date' disappears.
> >
> > 3. In any event, the remind date & time are not being stored properly in
> the
> > tbltasks table in the access database. Not sure where in the code these
> > values are lost even though I can see them on the screen when saving the
> new
> > task form.
> >
> > 4. When I type a value in any field apart from client field, a 0 appears
> in
> > the client field if it is blank. How can I avoid that?
> >
> > Thanks
> >
> > Regards
> >
> >
>
>

John
Thu Aug 05 20:00:46 CDT 2004

Hi

What I am really puzzled about is why the time part in date remind
disappears when a value is typed into subject or details fields.

Regards

"Ron Allen" <rallen@_nospam_src-us.com> wrote in message
news:OQI%237VyeEHA.1048@tk2msftngp13.phx.gbl...
> John,
> I've looked at your program and you need to change the
OleDbType.DBDate
> types to OleDbType.Date for your date parameters in your code. I'm not
sure
> about the focus not leaving the UltraCombo since its' type is DropDown.
You
> may just have to type something in it.
>
> Ron Allen
> "Ron Allen" <rallen@_nospam_src-us.com> wrote in message
> news:u8AkgOxeEHA.2916@TK2MSFTNGP12.phx.gbl...
> > John,
> > I suggest you ask this in the infragistics.dotnet.wingrid newsgroup
at
> > news.infragistics.com (or webgrid if this is a web application). For
the
> > date field make sure the parameters generated for the Update and Insert
> > commands have the type of this field as OleDbType.Date vs. DbDate. The
> > wizards can set this incorrectly and this would result in the time part
> > vanishing when being stored.
> >
> > Ron Allen
> > "John" <john@nospam.infovis.co.uk> wrote in message
> > news:uQIMz1weEHA.2764@TK2MSFTNGP11.phx.gbl...
> > > Hi
> > >
> > > I have this application that I am fighting with for days now. Here is
> the
> > > whole project; www.infovis.biz/tasks.zip. Please run and press the new
> > task
> > > button to see what I mean. Much of the code is either form taskvision
or
> > > infragistics samples btw and requires netadvantage 2004 vol2.
> > >
> > > I have the following problems with this and would appreciate any help
I
> > can
> > > get;
> > >
> > > 1. When I click in the clients field, I then click on any other field
> the
> > > cursor is stuck in the client field requiring an entry to be typed or
> > > selected. How can I make it so I can leave this field blank if I want
> to?
> > >
> > > 2. When a value is typed in the subject, details etc. fields, the time
> > part
> > > of 'Remind date' disappears.
> > >
> > > 3. In any event, the remind date & time are not being stored properly
in
> > the
> > > tbltasks table in the access database. Not sure where in the code
these
> > > values are lost even though I can see them on the screen when saving
the
> > new
> > > task form.
> > >
> > > 4. When I type a value in any field apart from client field, a 0
appears
> > in
> > > the client field if it is blank. How can I avoid that?
> > >
> > > Thanks
> > >
> > > Regards
> > >
> > >
> >
> >
>
>

Ron
Fri Aug 06 07:59:30 CDT 2004

John,
I think it has to do with your data bindings as when you create a new
record by typing into the subject field the rest of the data synchs up with
the new record's items.

Ron Allen
"John" <john@nospam.infovis.co.uk> wrote in message
news:efEuCF1eEHA.644@tk2msftngp13.phx.gbl...
> Hi
>
> What I am really puzzled about is why the time part in date remind
> disappears when a value is typed into subject or details fields.
>
> Regards
>
> "Ron Allen" <rallen@_nospam_src-us.com> wrote in message
> news:OQI%237VyeEHA.1048@tk2msftngp13.phx.gbl...
> > John,
> > I've looked at your program and you need to change the
> OleDbType.DBDate
> > types to OleDbType.Date for your date parameters in your code. I'm not
> sure
> > about the focus not leaving the UltraCombo since its' type is DropDown.
> You
> > may just have to type something in it.
> >
> > Ron Allen
> > "Ron Allen" <rallen@_nospam_src-us.com> wrote in message
> > news:u8AkgOxeEHA.2916@TK2MSFTNGP12.phx.gbl...
> > > John,
> > > I suggest you ask this in the infragistics.dotnet.wingrid
newsgroup
> at
> > > news.infragistics.com (or webgrid if this is a web application). For
> the
> > > date field make sure the parameters generated for the Update and
Insert
> > > commands have the type of this field as OleDbType.Date vs. DbDate.
The
> > > wizards can set this incorrectly and this would result in the time
part
> > > vanishing when being stored.
> > >
> > > Ron Allen
> > > "John" <john@nospam.infovis.co.uk> wrote in message
> > > news:uQIMz1weEHA.2764@TK2MSFTNGP11.phx.gbl...
> > > > Hi
> > > >
> > > > I have this application that I am fighting with for days now. Here
is
> > the
> > > > whole project; www.infovis.biz/tasks.zip. Please run and press the
new
> > > task
> > > > button to see what I mean. Much of the code is either form
taskvision
> or
> > > > infragistics samples btw and requires netadvantage 2004 vol2.
> > > >
> > > > I have the following problems with this and would appreciate any
help
> I
> > > can
> > > > get;
> > > >
> > > > 1. When I click in the clients field, I then click on any other
field
> > the
> > > > cursor is stuck in the client field requiring an entry to be typed
or
> > > > selected. How can I make it so I can leave this field blank if I
want
> > to?
> > > >
> > > > 2. When a value is typed in the subject, details etc. fields, the
time
> > > part
> > > > of 'Remind date' disappears.
> > > >
> > > > 3. In any event, the remind date & time are not being stored
properly
> in
> > > the
> > > > tbltasks table in the access database. Not sure where in the code
> these
> > > > values are lost even though I can see them on the screen when saving
> the
> > > new
> > > > task form.
> > > >
> > > > 4. When I type a value in any field apart from client field, a 0
> appears
> > > in
> > > > the client field if it is blank. How can I avoid that?
> > > >
> > > > Thanks
> > > >
> > > > Regards
> > > >
> > > >
> > >
> > >
> >
> >
>
>