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 Chriss 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: *

  • Users: Tia77
  • Order by date
  1. Tia77

    Convert Access Expression to VBA formula

    wow you are honestly a genius...I was barely able to understand my own crazy IF's and somehow you made sense of it and got it to work.. amazing much appreciated.
  2. Tia77

    Access Query is too complex to run - error message

    I began to convert it to VBA: Public Function GetVal(BegTaxBasis As Variant, Contribution As Variant, Distribution As Variant, TaxIncSubTotal As Variant, TBBLL As Variant, Recourse As Variant, QualifiedNonRecourse As Variant, NonRecourse As Variant) As Long Dim TRQN As Long TQRN = TBBLL +...
  3. Tia77

    Convert Access Expression to VBA formula

    oh wow that is really helpful thank you!! Can you by chance help me with the first section as well I want to convert that into VBA IF- Then's: IIf([BegTaxBasis]=0 And [Contribution]+[Distribution]=0,0,IIf([BegTaxBasis]=0 And...
  4. Tia77

    Convert Access Expression to VBA formula

    GainRecDistr: IIf([BegTaxBasis]=0 And [Contribution]+[Distribution]=0,0,IIf([BegTaxBasis]=0 And...
  5. Tia77

    Access Query is too complex to run - error message

    Thanks for your help! When I try to run that it gives me a compile error: see image attached. http://files.engineering.com/getfile.aspx?folder=5fe027ed-93b6-4687-9e80-479b6fe39172&file=Capture.PNG
  6. Tia77

    Access Query is too complex to run - error message

    I have a query in Access Database and when I try to run it, I get an error message "query is too complex to run." Runtime error 3360." The problem is with one formula / programming logic, see below: Previously the formula was the below - and it worked. IIf([BegTaxBasis]=0 And...

Part and Inventory Search

Back
Top