We just need to wait for Gina to reply as she understands your problem better and I've not been following the thread, I just had a quick skim through.
Question Database Coordinator/IT Analysis
- Thread starter Mrkeith
- Start date
Cool. The OP gets more control with a separate form so yes your idea (as always) is good.
So instead of the AfterUpdate event of the textbox, because that requires focus to be moved to another control for it to fire, the OP will need the Close or UnLoad event of the pop-up (edit) form. That is of course if a save is forced after editting.
GinaWhipp
AWF VIP
- Local time
- Today, 12:41
- Joined
- Jun 21, 2011
- Messages
- 5,876
vbaInet...
<not disputing just trying to explain>
First the checkbox opens a box for entering/editing notes only is checked *True*. So, yes, it does open a form and I guess I could have applied the ZoomBox there... I never use the ZoomBox because I can't control it (shape) and when zi want to show the notes I have requirements including backcolor. So I always go to form creation. Yes makes my answers biased AND there is always more then one way to get the function you want applied mine is a form.
I suppose if someone else had come to this thread they might have opted for the ZoomBox.
As a side note, I did not take offense to anything you said or rather posted... I don't mind the queries at all I may learn something!
<not disputing just trying to explain>
First the checkbox opens a box for entering/editing notes only is checked *True*. So, yes, it does open a form and I guess I could have applied the ZoomBox there... I never use the ZoomBox because I can't control it (shape) and when zi want to show the notes I have requirements including backcolor. So I always go to form creation. Yes makes my answers biased AND there is always more then one way to get the function you want applied mine is a form.
I suppose if someone else had come to this thread they might have opted for the ZoomBox.
As a side note, I did not take offense to anything you said or rather posted... I don't mind the queries at all I may learn something!
I'm sure you didn't
Yea, the pop-up form is a viable solution.
Ah, I see what you're referring to, the AfterUpdate event of the edit textbox on the pop-up form right?
GinaWhipp
AWF VIP
- Local time
- Today, 12:41
- Joined
- Jun 21, 2011
- Messages
- 5,876
@vbaInet
Actually, both or rather all...
If the User decides to edit the text then no problem AND if they decide to edit and back out (cancel) also no problem AND if the User edits or creates new text no problem. The After_Update event will handle anything that is done to the text so that the incorrect text is never displayed.
Actually, both or rather all...
If the User decides to edit the text then no problem AND if they decide to edit and back out (cancel) also no problem AND if the User edits or creates new text no problem. The After_Update event will handle anything that is done to the text so that the incorrect text is never displayed.
Hi Gina,
Here's a scenario:
1. Checkbox is ticked and the Edit form pops-up
2. User enters "Hello World" and moves away from the textbox, so the After Update event fires
3. Now user decides that they don't want to change the original text afterall and clicks on the 'X' Close button.
4. The user doesn't remember what the previous text is and there is no undo button. What happens here?
From what I gather the text will be saved immediately and the ControlTipText updated immediately too right?
My thoughts were:
1. Checkbox is ticked and the Edit form pops-up
2. User enters "Hello World" and moves away from the textbox, no update is performed.
3. Now user decides that they don't want to change the original text afterall and clicks on the 'X' Close button.
4. ControlTipText remains the same and the Value of the textbox is not changed.
So if the user wants to save changes, a Save button would be a nice thing to have on the Edit form so the user is explicitly agreeing to override the current value of the memo. Since memos can be quite long, it would be particularly useful to override current text only after confirmation.
Or is this not what the OP wants?
Here's a scenario:
1. Checkbox is ticked and the Edit form pops-up
2. User enters "Hello World" and moves away from the textbox, so the After Update event fires
3. Now user decides that they don't want to change the original text afterall and clicks on the 'X' Close button.
4. The user doesn't remember what the previous text is and there is no undo button. What happens here?
From what I gather the text will be saved immediately and the ControlTipText updated immediately too right?
My thoughts were:
1. Checkbox is ticked and the Edit form pops-up
2. User enters "Hello World" and moves away from the textbox, no update is performed.
3. Now user decides that they don't want to change the original text afterall and clicks on the 'X' Close button.
4. ControlTipText remains the same and the Value of the textbox is not changed.
So if the user wants to save changes, a Save button would be a nice thing to have on the Edit form so the user is explicitly agreeing to override the current value of the memo. Since memos can be quite long, it would be particularly useful to override current text only after confirmation.
Or is this not what the OP wants?
GinaWhipp
AWF VIP
- Local time
- Today, 12:41
- Joined
- Jun 21, 2011
- Messages
- 5,876
IGNORE... just saw your post (one minute apart 
from mine)
@vbaInet
After some thought... I realized the line would need to be placed in the After_Update event of both the Text Box and the Checkbox. Why, you say? Simple, because he *may* want to not show the ControlTipText and remove the checkmark. Having it both places goves him options.
Of course, we haven't heard anything for awhile so not even sure if that is working the the OP wants.
from mine)@vbaInet
After some thought... I realized the line would need to be placed in the After_Update event of both the Text Box and the Checkbox. Why, you say? Simple, because he *may* want to not show the ControlTipText and remove the checkmark. Having it both places goves him options.
Of course, we haven't heard anything for awhile so not even sure if that is working the the OP wants.
Last edited:
GinaWhipp
AWF VIP
- Local time
- Today, 12:41
- Joined
- Jun 21, 2011
- Messages
- 5,876
@vbaInet...
Yes, I see your point but then wouldn't it be better to put an Undo button? Actually a message in the On_Close event that would only fire if changes are made.
Of course, until we here from the OP we are only guessing...
Yes, I see your point but then wouldn't it be better to put an Undo button? Actually a message in the On_Close event that would only fire if changes are made.
Of course, until we here from the OP we are only guessing...
@GinaWhipp: Yep, both good ideas, actually I much prefer the Close idea because the database won't be hit unecessarily. But here's an addition to your idea, how about a confirmation message on Close asking for confirmation to save new text? Obviously we would have to trap the Unload event and make this form unbound.
Yes, you're right. I will leave it in your very capable hands now. I just wanted to throw some ideas.
Have a good weekend!
Yes, you're right. I will leave it in your very capable hands now. I just wanted to throw some ideas.
Have a good weekend!
Good afternoon friends!
Gina, I've been away for a while but i'm back. I've read the post that you and vbaInet have put up. The information that you've post is great. Gina, I need to be able to view the memo or comments text when the check box is tick. Also be able to view the memo or comment when I mouse over the check box. I don't want to see the comments if the check box is not check. vbaInet had a good point a save button would be idea. because the other users will need to view the pass information in the comments box. Gina you are awesome. Thanks so much.
Gina, I've been away for a while but i'm back. I've read the post that you and vbaInet have put up. The information that you've post is great. Gina, I need to be able to view the memo or comments text when the check box is tick. Also be able to view the memo or comment when I mouse over the check box. I don't want to see the comments if the check box is not check. vbaInet had a good point a save button would be idea. because the other users will need to view the pass information in the comments box. Gina you are awesome. Thanks so much.
Similar threads
