Check Code Please
in [Forms]
|
From: Afrosheen via AccessMonster.com on 29 Jan 2010 19:56 Sorry Doug and Gina. Neither code worked. It still tells me invalid use of Null. The txtAssist is a text field I even tried it this way: sql6 = "Update tblMain set super1 = "" where super1 =""" & txtAssist & """" Afrosheen wrote: >Thanks for the reply Gina and Doug. It is a true/false question. > >I appreciate the help. I really do. > >Thanks again. > >>If super1 is a Text field, you need quotes around the value: >> >[quoted text clipped - 10 lines] >>> >>> Thanks for your help. -- Message posted via http://www.accessmonster.com
From: John W. Vinson on 29 Jan 2010 21:14 On Sat, 30 Jan 2010 00:41:16 GMT, "Afrosheen via AccessMonster.com" <u46942(a)uwe> wrote: >Thanks for the reply Gina and Doug. It is a true/false question. An Access Yes/No field has ONLY two allowable values: it can be True (-1) or False (0). It cannot be NULL, it cannot be "". I think that's the cause of the code error you're getting! If you need to allow the field three choices (yes, no, or NULL) then you'll need to use a Number field and some special code to display it as a checkbox. -- John W. Vinson [MVP]
From: David W. Fenton on 30 Jan 2010 12:05 John W. Vinson <jvinson(a)STOP_SPAM.WysardOfInfo.com> wrote in news:0c57m55nqrcdn3liuc22bbd2uboq9lgs8d(a)4ax.com: > If you need to allow the field three choices (yes, no, or NULL) > then you'll need to use a Number field and some special code to > display it as a checkbox. Uh, the Access checkbox control has the TripleState property to allow for just such a setup -- no code required. -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/
From: Marshall Barton on 30 Jan 2010 14:18 David W. Fenton wrote: >John W. Vinson wrote > >> If you need to allow the field three choices (yes, no, or NULL) >> then you'll need to use a Number field and some special code to >> display it as a checkbox. > >Uh, the Access checkbox control has the TripleState property to >allow for just such a setup -- no code required. But only if it's bound to a number field. A Yes/No field can not be Null. -- Marsh MVP [MS Access]
From: Gina Whipp on 30 Jan 2010 16:01
Afrosheen, Is this *connected* to an SQL Server? Unless you check Allow Nulls you will need to set the box to either No or False. -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Afrosheen via AccessMonster.com" <u46942(a)uwe> wrote in message news:a2dc13b4841a8(a)uwe... Sorry Doug and Gina. Neither code worked. It still tells me invalid use of Null. The txtAssist is a text field I even tried it this way: sql6 = "Update tblMain set super1 = "" where super1 =""" & txtAssist & """" Afrosheen wrote: >Thanks for the reply Gina and Doug. It is a true/false question. > >I appreciate the help. I really do. > >Thanks again. > >>If super1 is a Text field, you need quotes around the value: >> >[quoted text clipped - 10 lines] >>> >>> Thanks for your help. -- Message posted via http://www.accessmonster.com |