Search results

  1. D

    Dlookup based on compared record date

    Thanks to those who viewed this thread. I found a workaround using a subquery.
  2. D

    Dlookup based on compared record date

    I've been reading and working with The Doc Man's excellent thread about dependent lookups (the system won't let me post the link for some reason, so here's the end of address that should get you there: showthread.php?t=310382). I know this is really close to what I need, but I haven't been...
  3. D

    Portion of Month Query Formula

    My apologies if I'm posting this in the wrong section ... please let me know if I need to move it. I'm trying to write a query that will look at a specific date [HireDate], and also look at the full-time amount of the employee [BaseFTE]. The formula should then tell me what the FTE equivalent...
  4. D

    Trouble calling audit module in form vba

    Thank you for your responses! I've tried the new method and it wouldn't evaluate any of the controls at all ... I tried combined the audit modules and I feel this is closer, but it doesn't seem to handle the "else" statement. Is there a workaround? new combined module (applicable...
  5. D

    Trouble calling audit module in form vba

    Thank you for your quick responses :) When I test the form, it gives me a popup with the "operation is not supported ... " error, but it doesn't give me a end/debug option (just the ok button). Therefore, I'm not certain exactly what line it is - - unless there is another way for me to test...
  6. D

    Trouble calling audit module in form vba

    I think the area of issue is in the BeforeUpdate as well. When I keep the code to checking one tag, i.e. tagEmplAudit, and eliminate the Else statement, the code works. Is there a way to evaluate multiple tags and call the associated audit modules?
  7. D

    Trouble calling audit module in form vba

    First time posting, so please excuse if I pull a moron in my questions. I have the following: 2 audit modules: basEmplAudit and basEmplDeptAudit 1 query (tblEmployee left join tblEmployeeDepartment) 1 form using the above query as record source For this particular form I'm trying to avoid...
Back
Top Bottom