Re: Checking if textbox values have been cleared or replaced, or updated
- From: "tina" <nospam@xxxxxxxxxxx>
- Date: Tue, 22 Nov 2005 01:48:21 GMT
not sure what your goal is. do you want to allow users to add new notes, but
prevent any existing notes from being deleted? or do you want to allow users
to delete existing notes?
<ILCSP@xxxxxxxxxxx> wrote in message
news:1132614385.295690.279270@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Hello, I have this textbox in a Access 2000 form, which is a memo type
> where we keep our notes for a record. Whenever there's new notes to
> add, they're piggied back to the existing notes. (new notes are
> entered at the end of the last notes).
>
> Lately, some of the existing notes have been deleted and I would like
> to know if I could check if the notes have been cleared or replaced
> with new ones before updating the record. I'm thinking of having 2
> boxes, BoxA and BoxB. Both would start the same when the record's
> loaded. However, BoxA would be visible and that's where the users would
> make changes. BoxB would be invisible and for checking purposes only.
>
> First, whenever a record needs to be updated, I would like to check if
> the notes have been deleted altogether. That's easy to do:
> if not isnull(BoxB) and is null(BoxA) then sound the alarm.
>
> The problem would arise when someone clears the notes and puts new
> ones. Then, both boxes are not null. Is there a way to check if the
> value from boxB still exists in BoxA at the beggining of the BoxA's
> value?
>
> This should work like this. If someone add new notes to the existing
> notes, then the BoxB value would be equal to the value of BoxA plus any
> new notes. If they're not, I'd offer the user the chance to reset the
> record, or let them go ahead with these changes if they really need to.
>
> If anybody has comments on how to do this, please let me know.
>
> A million thanks beforehand.
>
.
- Prev by Date: Re: Creating a multiple table query...
- Next by Date: Re: Remove decimal and leave 00
- Previous by thread: Re: Queries
- Next by thread: Re: Checking if textbox values have been cleared or replaced, or updated
- Index(es):
Relevant Pages
|
