Access DB

Results 1 to 3 of 3

Thread: Access DB

  1. #1
    Join Date
    Dec 1969

    Default Access DB

    How do you change the value of a Yes/No field using ASP. When I try using a update like this...<BR><BR> objUpdt("Stu_Active").value = False<BR> objUpdt.Update<BR><BR>I get the error...<BR><BR>Item cannot be found in the collection corresponding to the requested name or ordinal.<BR><BR>I changed the format of the Yes/No field to True/False. I have also tried using...<BR><BR> objUpdt("Stu_Active").value = No<BR> and<BR> objUpdt("Stu_Active").value = "No"<BR><BR>without success also. Any comments would be great. Thanks.

  2. #2
    NPKumar Guest

    Default RE: Access DB

    Try with 0.<BR>objUpdt("Stu_Active").value = 0

  3. #3
    Join Date
    Dec 1969

    Default RE: Access DB

    Access will accept TRUE and FALSE no problem, it doesn&#039;t look like a type mismatch, it looks more like "Stu_Active" doesn&#039;t exist in the recordset......worth double checking the field names...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts