IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / Does the Tab key have any special meaning to it?
Post #92,530
by acagle
3/28/03 3:59:19 PM
Reply
New Does the Tab key have any special meaning to it?
I ask because I have a table with two field acting as the keys (Var1 and Var2). If I start a new record, type a new number into the combo box containing Var1, and then Tab to the next field (Var2 text box,which is empty) I get an error message saying that Var2 cannot contain a Null value. OTOH, if I just use the ol' mouse to click on the Var2 field, it works fine. Tabbing seems to trigger some sort of check, but there's not code telling it to do that.

It's driving me batty.
Post #92,781
by jbrabeck
3/29/03 8:10:39 AM
Reply
New Check the properties
Of those fields (Table/Design) There is a setting to (Dis)allow NULL values. Set it to allow null. Should fix the problem.

Welcome to Access...
[link|mailto:jbrabeck@attbi.com|Joe]
     'nother Access question. - (acagle) - (23) - March 26, 2003, 12:36:51 PM EST
         Tools->Relationships - (bepatient) - March 26, 2003, 12:52:54 PM EST
         Try this - (jbrabeck) - (17) - March 26, 2003, 02:03:59 PM EST
             Perfect! Thanks! -NT - (acagle) - March 26, 2003, 03:56:33 PM EST
             Ooh...I like that... - (bepatient) - (15) - March 26, 2003, 04:15:29 PM EST
                 Guess I aint as bad as I thought! - (jbrabeck) - (14) - March 26, 2003, 04:42:38 PM EST
                     Been a while since I used Access, but. - (mmoffitt) - (10) - March 26, 2003, 07:56:15 PM EST
                         Case statement - (orion) - (9) - March 26, 2003, 08:32:46 PM EST
                             Not that one. - (mmoffitt) - (8) - March 26, 2003, 08:35:00 PM EST
                                 SQL construct - (ChrisR) - (7) - March 26, 2003, 09:03:39 PM EST
                                     Still there but only for two options -NT - (tseliot) - March 26, 2003, 09:06:14 PM EST
                                     Yeah, I was thinking Access had a TSQL-like Case statement. - (mmoffitt) - (5) - March 26, 2003, 09:06:36 PM EST
                                         IIRC the queries do support it. - (ChrisR) - March 26, 2003, 09:16:09 PM EST
                                         Yes Access has a Case statement - (jbrabeck) - (3) - March 26, 2003, 09:16:46 PM EST
                                             Yeah, I remember IIF in Access. - (mmoffitt) - (2) - March 26, 2003, 09:25:51 PM EST
                                                 DECODE would do it, if Access has it, that is. - (Meerkat) - (1) - March 27, 2003, 03:00:36 AM EST
                                                     IIF, Case and Switch. No Decode - (jbrabeck) - March 27, 2003, 08:20:11 AM EST
                     Yes you are. - (tseliot) - (2) - March 26, 2003, 09:08:02 PM EST
                         Agree, but... - (jbrabeck) - (1) - March 26, 2003, 09:21:29 PM EST
                             Then you have one of four choices - (tseliot) - March 28, 2003, 04:34:34 PM EST
         Okay, here's another one: - (acagle) - (1) - March 27, 2003, 12:47:38 PM EST
             ="A" & Chr(13) & Chr(10) & "B" - (ChrisR) - March 27, 2003, 12:58:28 PM EST
         Does the Tab key have any special meaning to it? - (acagle) - (1) - March 28, 2003, 03:59:19 PM EST
             Check the properties - (jbrabeck) - March 29, 2003, 08:10:39 AM EST

"Lord Vetinari won't stop at sarcasm. He might use" -- Colon swallowed -- "irony."
69 ms