PC Review


Reply
Thread Tools Rate Thread

Delete data in textbox Enabled=False

 
 
=?Utf-8?B?YW4=?=
Guest
Posts: n/a
 
      21st Jul 2007
Hi!

I have a combo with 3 rows.
In Afterupdate I have:

If combo = 3 then
TextboxXPTO.Enabled = False
Else
TextboxXPTO.Enabled = true
End If

Work fine but the last data in this texbox written in previous records are
saved in the table.
How is possible to prevent this, please?
Thanks in advance.
an
 
Reply With Quote
 
 
 
 
=?Utf-8?B?QmVldGxl?=
Guest
Posts: n/a
 
      21st Jul 2007
If TextboxXPTO is not enabled, then data connot be written to it. If you
have a scenario where you need TextboxXPTO to be enabled, but you want to
prevent data being written or saved to it unless some other conditon is
true/false, then use can use the Before Insert or Before Update events of
TextboxXPTO to trap for this.

HTH
"an" wrote:

> Hi!
>
> I have a combo with 3 rows.
> In Afterupdate I have:
>
> If combo = 3 then
> TextboxXPTO.Enabled = False
> Else
> TextboxXPTO.Enabled = true
> End If
>
> Work fine but the last data in this texbox written in previous records are
> saved in the table.
> How is possible to prevent this, please?
> Thanks in advance.
> an

 
Reply With Quote
 
=?Utf-8?B?YW4=?=
Guest
Posts: n/a
 
      21st Jul 2007
Thanks for your reply.

I need to delete the data in this TexboxXPTO, because there are data in it
of the previous insertion where this TextboxXPTO.Enabled = True.

an

"Beetle" wrote:

> If TextboxXPTO is not enabled, then data connot be written to it. If you
> have a scenario where you need TextboxXPTO to be enabled, but you want to
> prevent data being written or saved to it unless some other conditon is
> true/false, then use can use the Before Insert or Before Update events of
> TextboxXPTO to trap for this.
>
> HTH
> "an" wrote:
>
> > Hi!
> >
> > I have a combo with 3 rows.
> > In Afterupdate I have:
> >
> > If combo = 3 then
> > TextboxXPTO.Enabled = False
> > Else
> > TextboxXPTO.Enabled = true
> > End If
> >
> > Work fine but the last data in this texbox written in previous records are
> > saved in the table.
> > How is possible to prevent this, please?
> > Thanks in advance.
> > an

 
Reply With Quote
 
=?Utf-8?B?QmVldGxl?=
Guest
Posts: n/a
 
      21st Jul 2007
It sounds like you're saying that you need to delete whatever information was
saved in this text box for the previous record, in which case I'm not sure
why you are having difficulty. Move to that record in your form, enable the
textbox and delete the info, or just delete it directly from the table. Or
maybe you're saying that this text box has some default value that is always
there and you want to get rid of that? I'm not sure.

"an" wrote:

> Thanks for your reply.
>
> I need to delete the data in this TexboxXPTO, because there are data in it
> of the previous insertion where this TextboxXPTO.Enabled = True.
>
> an
>
> "Beetle" wrote:
>
> > If TextboxXPTO is not enabled, then data connot be written to it. If you
> > have a scenario where you need TextboxXPTO to be enabled, but you want to
> > prevent data being written or saved to it unless some other conditon is
> > true/false, then use can use the Before Insert or Before Update events of
> > TextboxXPTO to trap for this.
> >
> > HTH
> > "an" wrote:
> >
> > > Hi!
> > >
> > > I have a combo with 3 rows.
> > > In Afterupdate I have:
> > >
> > > If combo = 3 then
> > > TextboxXPTO.Enabled = False
> > > Else
> > > TextboxXPTO.Enabled = true
> > > End If
> > >
> > > Work fine but the last data in this texbox written in previous records are
> > > saved in the table.
> > > How is possible to prevent this, please?
> > > Thanks in advance.
> > > an

 
Reply With Quote
 
=?Utf-8?B?YW4=?=
Guest
Posts: n/a
 
      21st Jul 2007
OK, B.

Thanks for your help.
an

"Beetle" wrote:

> It sounds like you're saying that you need to delete whatever information was
> saved in this text box for the previous record, in which case I'm not sure
> why you are having difficulty. Move to that record in your form, enable the
> textbox and delete the info, or just delete it directly from the table. Or
> maybe you're saying that this text box has some default value that is always
> there and you want to get rid of that? I'm not sure.
>
> "an" wrote:
>
> > Thanks for your reply.
> >
> > I need to delete the data in this TexboxXPTO, because there are data in it
> > of the previous insertion where this TextboxXPTO.Enabled = True.
> >
> > an
> >
> > "Beetle" wrote:
> >
> > > If TextboxXPTO is not enabled, then data connot be written to it. If you
> > > have a scenario where you need TextboxXPTO to be enabled, but you want to
> > > prevent data being written or saved to it unless some other conditon is
> > > true/false, then use can use the Before Insert or Before Update events of
> > > TextboxXPTO to trap for this.
> > >
> > > HTH
> > > "an" wrote:
> > >
> > > > Hi!
> > > >
> > > > I have a combo with 3 rows.
> > > > In Afterupdate I have:
> > > >
> > > > If combo = 3 then
> > > > TextboxXPTO.Enabled = False
> > > > Else
> > > > TextboxXPTO.Enabled = true
> > > > End If
> > > >
> > > > Work fine but the last data in this texbox written in previous records are
> > > > saved in the table.
> > > > How is possible to prevent this, please?
> > > > Thanks in advance.
> > > > an

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Color of the text in a Textbox with enabled = false Broeden Microsoft Dot NET Compact Framework 3 4th Jan 2008 03:47 PM
how make a textbox enabled false without postbac k Patrick.O.Ige Microsoft ASP .NET 7 10th Apr 2006 01:04 PM
Setting the web control textbox property enabled = FALSE Gill Smith Microsoft ASP .NET 4 22nd May 2004 09:20 PM
If Chk False then Enabled=False Donna Brooks Microsoft Access Form Coding 1 29th Dec 2003 07:54 PM
Enabled=False J.C. Microsoft Access Forms 2 22nd Nov 2003 10:53 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:22 PM.