locked
how to check the fields in subform are null RRS feed

  • Question

  • Well...By using vba code, I am just wondering if there is a way to check all the fields in the subform and see if they are null...What is the code?
    Tuesday, April 27, 2010 7:42 PM

Answers

  • Hi,

    Thanks for your post here!

    This forum is dedicated to Microsoft SQL Server. If you have any questions about Office Access, please post your questions in http://social.technet.microsoft.com/Forums/en-us/office2010/threads. Thanks for your understanding.

    Thanks,
    Chunsong


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    • Proposed as answer by Naomi N Friday, April 30, 2010 4:17 AM
    • Marked as answer by Alex Feng (SQL) Thursday, May 6, 2010 12:56 AM
    Friday, April 30, 2010 2:43 AM

All replies

  • I'm not sure what subform you're referring to, but the T-SQL function used to check a field if it is null is ISNULL.  Please see this link, I hope it is helpful:

    http://msdn.microsoft.com/en-us/library/ms184325.aspx

    Aaron Jarboe

    -Remember to mark as an answer if this post has helped you.
    Tuesday, April 27, 2010 9:23 PM
  • Well...I mean in access, after you create some tables I used three tables, table customer, transaction for my main form, and product table as subform. It is very easy to create a subform by just using one of the GUI button from access in design tool tab. Once you click on it, you will get the wizard and from there you could select any table as your subform.

    The question is like I was able to check all fields(those user inputs) but cannot get those work in the subform even after I use IsNull function.

    Wednesday, April 28, 2010 4:06 PM
  • Hi,

    Thanks for your post here!

    This forum is dedicated to Microsoft SQL Server. If you have any questions about Office Access, please post your questions in http://social.technet.microsoft.com/Forums/en-us/office2010/threads. Thanks for your understanding.

    Thanks,
    Chunsong


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    • Proposed as answer by Naomi N Friday, April 30, 2010 4:17 AM
    • Marked as answer by Alex Feng (SQL) Thursday, May 6, 2010 12:56 AM
    Friday, April 30, 2010 2:43 AM