Re: SQL server Vs Oracle

From: Brendan Reynolds <brenreyn_at_indigo.ie>
Date: Wed, 12 May 1999 22:33:48 +0100
Message-ID: <nrm_2.2151$yr2.956@news.indigo.ie>

I've never used it either. On Not In List works fine for me. I came up with this in response to a question posted here (comp.databases.ms-access, for those following this thread in other newsgroups) from someone who wasn't satisfied with On Not In List, but wanted to actually disable typing in the combo box. It could be improved by changing the If ... Then statement to a Select Case and including tests for F4 and the arrow keys, but as I don't have any practical use for it, I can't be both... er, I mean I've left that as an exercise for the student!

And besides, I couldn't resist the one-liner!

--

Brendan Reynolds
brenreyn_at_indigo.ie

Arvin Meyer<A_at_M.COM wrote in message
<7hcria$da4$1_at_esinet2.esinet.net-...-Touché (since we're into French today <g-)
-
-I wouldn't use it, out of respect to the data entry folks out there, but
-there you go, it can be done, and very simply. Now I expect in his next
-post, Jim will protest that this is a kludge.

---

-Arvin Meyer
-onsite_at_esinet.net
-
-Brendan Reynolds wrote in message ...
--Private Sub cboCntryID_KeyDown(KeyCode As Integer, Shift As Integer)
--

• If KeyCode <- vbKeyReturn And KeyCode <- vbKeyTab Then KeyCode = 0
  --
  --End Sub
  --
  

  ---

  
  --Brendan Reynolds
  --brenreyn_at_indigo.ie
  --
  --Jim McCusker wrote in message <3739B5F3.CBE02619_at_iname.com-...
  ---For instance, try to get a native
  ---MS-Access combo-box to not be editable (only being able to select items
  ---from the pull-down). It's not gonna happen.
  --
  --
  --
  -
  -
  

Received on Wed May 12 1999 - 16:33:48 CDT