Results 1 to 2 of 2
  1. #1
    BLFOSTER is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jun 2013
    Posts
    68

    Function in a Function

    Can this be done somehow? It's not working since I added the dhFirstDayInWeek function - before that it worked fine.

    Me.Start = dhFirstDayInWeek(DLookup("[CheckInDate]", "Activities1", "[Client ID (ref)] = Forms!ClientTable.form![Student ID] and Not IsNull([Activity - Planned Start])"))

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Could you show us the code for the function dhFirstDayInWeek?
    Also, your criteria in the DLookup is incorrect syntax.

    Try (untested)
    "[Client ID (ref)] =" & Forms!ClientTable.form![Student ID] & " and Not IsNull([Activity - Planned Start])"
    Last edited by orange; 01-29-2016 at 01:20 PM. Reason: spelling

Please reply to this thread with any new information or opinions.

Similar Threads

  1. How to do a function in VBA
    By sanderson in forum Programming
    Replies: 8
    Last Post: 09-22-2015, 02:48 PM
  2. Replies: 8
    Last Post: 11-04-2014, 10:44 PM
  3. Replies: 8
    Last Post: 01-31-2014, 01:45 PM
  4. Want function to get current function name
    By Davis DeBard in forum Programming
    Replies: 2
    Last Post: 08-13-2009, 05:02 AM
  5. Sum Function Help
    By newbie in forum Reports
    Replies: 3
    Last Post: 06-30-2009, 05:32 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums