Re: Limit Keys

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Gareth,

If you get paid to do as your told, or if you really don't know any better,
then fine...do it. I truly mean no insult by that comment. But a
professional developer's job is to provide the customer with a quality
system based on *our* expertise. That's what we're paid exhorbitant amounts
of money for, and if we cave in and blindly do as we're told without
considering the impact of that decision, or better ways of doing things,
then we're not doing right by our customer. I call that a breach of ethics.

Customers are not (normally) qualified developers, and so do not (normally)
understand the intricasies of software design or human-computer interaction.
Of course, I'm not there, and I can't see the specifics of your application,
but when someone says they're doing something a particular way simply
because they're told to, then I have to question the wisdom and ethics of
what follows.

I know that highly regarded developers, some of whom frequent this very
group, will argue with me about this very point, but none of those arguments
invalidate my statements. You should also understand that I wouldn't be
doing right by you if I didn't offer you my considered opinion. Which way
you do it is entirely up to you.

...answer a simple Y or N question then they shouldnt be allowed out
You said nothing about asking, much less answering, a question. All you said
was "...they would prefer to just enter a letter...".

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia



"Gazza" <Gazza@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4A177D33-3E45-4E6C-9231-9AFCBE1DE0A0@xxxxxxxxxxxxxxxx
Personally i prefer to just type something into a text box and press the
enter key and if the users cant answer a simple Y or N question then they
shouldnt be allowed out.

Also when the person thats paying your wages tells you to do something
personally i do it although most people tend to want to do it there way.

Thanks
Gareth

"Graham R Seach" wrote:

Gazza,

OK, it's up to you, but if a user said to me that they wanted to type a
specific letter into a textbox, I'd be asking why. From a usability
perspective (and at this point, its a purely academic exercise), it's not
terribly intuitive for a new user, whereas a combo or option group is. If
it
were me, I'd stick to my guns and make them come up with a valid reason
why
they wanted to enter a single character into a textbox in preference to
any
other data data entry model. If they come up with a real good reason,
then
fine, but if they say "because that's the way we've always done it", I'd
say
phhfffttt - get over it - here's the new way. They *will* come to prefer
it.

I recommend the option group.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia


"Gazza" <Gazza@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9EE6AE1F-0D3A-493C-B4F8-5B3964DA4537@xxxxxxxxxxxxxxxx
Thanks for the reply Graham.

Although my first option was to put a combo box on the form, after
speaking
to the people who use it they would prefer to just enter a letter and
then
press the enter key to continue.

At the moment i have tried the following code in the before and
afterupdate
event of the text box :

Dim response As Integer

Select Case Me.Select1

Case "y"
MsgBox "New record added", vbOKOnly
DoCmd.RunCommand acCmdSave
DoCmd.GoToRecord , , acNewRec
Me.Select1 = Null

Case "n"
response = MsgBox("Are you sure you want to delete this record",
vbYesNo)

If response = vbYes Then
Cancel = True
DoCmd.RunCommand acCmdDeleteRecord
MsgBox "Record Deleted", vbOKOnly
Me.Select1 = Null

End If
If response = vbNo Then
Cancel = True
Me.Select1 = Null
Me.Accountcode.SetFocus
End If

Case "D"
DoCmd.OpenForm "FrmDeliveryAddress"

Case Else
MsgBox "Please enter Y or N only", vbOKOnly


End Select

but i cant get it to do what i want.

Thanks
Gareth






.

Relevant Pages

  • Re: Limit Keys
    ... enter key and if the users cant answer a simple Y or N question then they ... terribly intuitive for a new user, whereas a combo or option group is. ... Dim response As Integer ... MsgBox "New record added", vbOKOnly ...
    (microsoft.public.access.formscoding)
  • Re: Limit Keys
    ... specific letter into a textbox, ... terribly intuitive for a new user, whereas a combo or option group is. ... Dim response As Integer ... MsgBox "New record added", vbOKOnly ...
    (microsoft.public.access.formscoding)
  • Re: social media portraits.
    ... people just push paper around and my response that these HR positions ... However, I paid him 25% ... a custodial account in my daughter's name. ... At the time the accident was reported the carrier set up a contested claims account. ...
    (alt.photography)
  • Re: Validation Rule Problem
    ... Response As Integer) ... MsgBox "The new Diagnosis has been added to the list." ... , vbInformation, "FBW Physiotherapy" ... the data is added as lower case without the validation rule kicking in. ...
    (microsoft.public.access.forms)
  • Problems with input-validation
    ... i.e. leaving the field empty. ... Response As Integer) ... MsgBox \"Only numerical input allowed in \" & ctl.Name ... how can i do a working validation of user-input? ...
    (microsoft.public.access.formscoding)