473,237 Members | 1,393 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,237 software developers and data experts.

access97, is there an event triggered when you undo the contents of a field

I've got a comboBox with 2 choices and based on the choice, I make
button A or button B visible

if choose choice 1, button A is visible
now, I undo the choice so that the comboBox is null, but button A is
still visible

I tried the field's onChange event, but no luck

I could use the form's timer event, but I wonder if there's a better
event to use

Jun 22 '06 #1
4 1723
The Undo events were introduced in Access 2000, so are not available in 97.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<le*********@natpro.com> wrote in message
news:11**********************@y41g2000cwy.googlegr oups.com...
I've got a comboBox with 2 choices and based on the choice, I make
button A or button B visible

if choose choice 1, button A is visible
now, I undo the choice so that the comboBox is null, but button A is
still visible

I tried the field's onChange event, but no luck

I could use the form's timer event, but I wonder if there's a better
event to use

Jun 22 '06 #2
Bri
le*********@natpro.com wrote:
I've got a comboBox with 2 choices and based on the choice, I make
button A or button B visible

if choose choice 1, button A is visible
now, I undo the choice so that the comboBox is null, but button A is
still visible

I tried the field's onChange event, but no luck

I could use the form's timer event, but I wonder if there's a better
event to use


What about the AfterUpdate event? Or better yet, since you are looking
at only two choices, use an Option Box instead of a Combo, that way the
can only choose one or the other, Null isn't possible.

--
Bri

Jun 22 '06 #3
On 22 Jun 2006 04:23:30 -0700, le*********@natpro.com wrote:
I've got a comboBox with 2 choices and based on the choice, I make
button A or button B visible

if choose choice 1, button A is visible
now, I undo the choice so that the comboBox is null, but button A is
still visible

I tried the field's onChange event, but no luck

I could use the form's timer event, but I wonder if there's a better
event to use


What do you mean by "undo"? Do you highlight and delete? Do you push <esc>?
When you "undo", do you want both buttons to be invisible?

When the form is first opened is either button A or button B visible?
If you don't want either button to be visible, make a third choice in the
ComboBox which is "niether" which makes both buttons invisible. Make that
choice the default value.

Just a wizard prodder
Chuck
--

Jun 23 '06 #4
using the 'esc' key to undo the contents of the combo

say I've got a blank form, and I start adding a new record

I fill in some data, including selecting choice 1 from the combo box,
which makes button A visible

now say, I don't want to finish the entry session, and can't save it
because required fields are missing data

I hit esc-ape twice, and the form is cleared of my keyed data, and I'm
no longer in new-record mode

the combobox is blank, but button A is still visible

the idea of third combo box selection is a good thought, so is the idea
of an 'undo' button
but there are too many other generic ways to undo (escape, ctl-z, edit
pull down menu)

if the combo box is null, I don't want to see either button
Chuck wrote:
On 22 Jun 2006 04:23:30 -0700, le*********@natpro.com wrote:
I've got a comboBox with 2 choices and based on the choice, I make
button A or button B visible

if choose choice 1, button A is visible
now, I undo the choice so that the comboBox is null, but button A is
still visible

I tried the field's onChange event, but no luck

I could use the form's timer event, but I wonder if there's a better
event to use


What do you mean by "undo"? Do you highlight and delete? Do you push <esc>?
When you "undo", do you want both buttons to be invisible?

When the form is first opened is either button A or button B visible?
If you don't want either button to be visible, make a third choice in the
ComboBox which is "niether" which makes both buttons invisible. Make that
choice the default value.

Just a wizard prodder
Chuck
--


Jun 23 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Nyuszi | last post by:
Hi, I am creating a finance database from scratch. I have a yes/no field in my table. I was wondering what can I do to display an extra field when yes is clicked in this field. What events to...
3
by: Christoph Boget | last post by:
I have a TreeView object that I'm filling in with the directory structure. However, for the sake of this learning exercise, I am making it flat. So that when a user clicks on the directory name,...
6
by: No Spam | last post by:
Dear Access 2003 Users, Is there a way to pop up a MessageBox warning when a user changes data on a form? Basically, I have one field that I really want people to think about before changing,...
0
by: adolph | last post by:
Hi, I have a beforeupdate evbent that tests to see that a customer chosen before the user can enter an amount. If the customer has not been chosen yet, then I would like to popup a message...
1
by: lesperancer | last post by:
I've got a form that is opened in readonly mode and no fields can be changed, great but if I click on a combo box that has an _enter() event that sets a field on my form to a value (albeit the...
2
by: lindseyhansen | last post by:
Access 2000 with linked tables to SQL Server 2000: I have a form where I am trying to update a date field when any of the fields for the current saved record get changed. I am using the...
0
by: Paul Hadfield | last post by:
I'm looking for thoughts on the "correct" design for this problem (DotNet 2.0 - in winforms, but that's not so important). I've got two combo boxes (combo1 and combo2), both are populating via...
13
by: Keith Wilby | last post by:
I've never used this event before and I'm struggling. I have this code in it: If MsgBox("You entered " & Me.cboManagerName _ & " - is this the manager's network logon ID?", vbYesNo, "Confrim...
2
by: Roger | last post by:
I've got two tables in sql2005 which have an 'ntext' field when I linked the first table in access97 last week using an odbc data source the access-field type was 'memo' when I link the 2nd...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.