Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. newToVBA2003

    WHERE Statement

    Oh Phv in your version you have a GROUP BY but not a HAVING, what is the difference or why can HAVING be ommitted?
  2. newToVBA2003

    WHERE Statement

    That is a lot clearer and easier to read than the code I have now, so thank you as well. I like this "DateSerial" format for "BeginElig" and "enndate" better also.
  3. newToVBA2003

    WHERE Statement

    OM Goosh, thanks Harley that worked. Thanks once again.
  4. newToVBA2003

    WHERE Statement

    The second "And" in the second comparison in the Where clause is not in my code, happend when I was copying over to here
  5. newToVBA2003

    WHERE Statement

    BeginElig = "1/1/" & (Format(ClaimDate, "yyyy")) enddate = "12/31/" & (Format(ClaimDate, "yyyy")) 'and (((ClaimsBenefits.DateOfVisit)<= #" & enddate & "#)) #" & BeginElig & "# 'And (((planStartDate)>= #" & BeginElig & "#)) planStartDate= DLookup("[DentalPlanStartDate]"...
  6. newToVBA2003

    WHERE Statement

    SQL for access 2003 if that's what you are asking. Here is a snippet of the code if this helps: sqlstmt = "SELECT ClaimsBenefits.Dependent, ADACodes.Type, Sum(ClaimsBenefitsDetails.AmtPaid) AS SumOfAmtPaid INTO TmpValues " & _ "FROM (ClaimsBenefits INNER JOIN...
  7. newToVBA2003

    WHERE Statement

    I use that and I keep getting a pop up window to enter someOtherDate...someOtherDate already has a value though.
  8. newToVBA2003

    WHERE Statement

    I have a "WHERE" statement as such: "WHERE (((ClaimsBenefits.DateOfVisit)>= #" & BeginElig & "#)) where BeginElig = "1/1/" & (Format(ClaimDate, "yyyy")) Is there a way to compare two var within the Where statement? EX: I want to compare BeginElig against another date variable within the WHERE...
  9. newToVBA2003

    Code Not showing and working var not declared

    It is located in two different code sections," I have a list of forms with code behind them. The var in which I am speaking about is used in two different form code behind sections. I don't see where the var was declared for either sections.
  10. newToVBA2003

    Code Not showing and working var not declared

    Thanks...In what case would you not want to declare your variables?
  11. newToVBA2003

    Code Not showing and working var not declared

    The project was already setup before I started working on it and it uses "Option Compare Database" every where, by changing it to Option Explicit what will change?
  12. newToVBA2003

    Code Not showing and working var not declared

    Hello, I have 2 questions, I am working on a project in Access 2003 and I can view the code for all of the forms except one. It runs like it is suppose to I just can't view the code for it. 1. Is there anyway to view the code? I also have an issue with a variable that isn't declared and works...

Part and Inventory Search

Back
Top