Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2011
    Posts
    413

    Unanswered: Problem with Query or Module ?

    I am having a lot of difficulty figuring this one out. Either it is a problem with my query syntax or the module or maybe both, not sure. Anybody feel like tackling this one? I need another pair of eyes. Mine are old and my brain is old too.
    I attached a crunched down version and a pic of the master form used for date criteria.

    Thanks,

    Dave
    Attached Thumbnails Attached Thumbnails TimeCardsMasterForm.png  
    Attached Files Attached Files

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Quote Originally Posted by Burrina View Post

    ...Either it is a problem with my query syntax or the module...

    ...Anybody feel like tackling this one?
    The fact that almost 100 members have viewed this thread and none have responded would make the answer to your question a resounding NO!

    "Either it is a problem with my query syntax or the module"

    says absolutely nothing! You cannot expect anyone to take the time and trouble to download your attachment and look at it when you haven't bothered to give us even a vague hint as to what kind of problems you're experiencing!

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Nov 2011
    Posts
    413
    The problem is with a query that gives an error message and not sure if it is a true syntax problem or a problem with the module the code comes from.
    Ok, here is the syntax of the query;

    ' Syntax Error in Query QSaleComTotWkA, expression 'FicaMulDate = # #'.


    Thats the error message I get when I try to run the query.
    Here is the syntax in the query,

    ' Syntax Error in Query QSaleComTotWkA, expression 'FicaMulDate = # #'.


    Although it stems from the module ModDate which I believe to be the real culprit.

    Here is the error code for the module;
    Fica = DLookup("FicaMul", "TFica", "FicaMulDate = #" & DMax("FicaMulDate", "TFica", "FicaMulDate <=DteEnd()") & "#")

Posting Permissions

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