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 derfloh 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. pbaldy

    Comparing sequential values

    You can use a technique like this to get the previous value into the current record. From there the math should be easy: http://www.baldyweb.com/PrevValue.htm Paul MS Access MVP 2007/2008
  2. pbaldy

    Email Access 2007 Report as PDF Attachment to multiple recipients

    No problem. I know 2007 has built-in PDF capability, but I still use this: http://www.lebans.com/reporttopdf.htm I don't know if it's easier than the built-in method, but figured I'd post it here just in case someone needed it. Paul MS Access MVP 2007/2008
  3. pbaldy

    Email Access 2007 Report as PDF Attachment to multiple recipients

    Did you get this going? If not, this should get you started: http://www.granite.ab.ca/access/email/reporttomultiplerecipients.htm Paul MS Access MVP 2007/2008
  4. pbaldy

    How to omit Zero results when performing Query

    Try WHERE (((ARBill.ARBillDate) Between [Parameter 1] And [Parameter 2])) AND (([ExpensesBilled]-[ExpensesReceived])+([ExpensesAdjusted]))+(([FeesBilled]-[FeesReceived])+([FeesAdjusted]))+(([InterestBilled]-[InterestReceived])+([InterestAdjusted])) <> 0 None of those parentheses are required...
  5. pbaldy

    How to omit Zero results when performing Query

    If you look at the query in SQL view, does it say this? WHERE BalanceDue <> 0 presuming so, staying in SQL view, try changing it to this: WHERE...
  6. pbaldy

    How to omit Zero results when performing Query

    It may help to see the SQL, but I suspect you're running into the fact that the WHERE clause is evaluated before the SELECT clause, so the calculated fields are not known at that point. If you have: NewField: Field1 + Field2 in SQL view instead of WHERE NewField <> 0 you'd want WHERE...
  7. pbaldy

    msg box

    Here's an example of the yes/no message box: Dim msg As String, button As Variant, title As String, response As Variant msg = "Vehicle is Shopped - Do you want to dispatch anyway?" button = vbYesNo + vbDefaultButton2 title = "Vehicle Shopped!" response = MsgBox(msg, button, title) If response...
  8. pbaldy

    error setting a tempvar

    HarleyQuinn, as you know, the original posts were DAO. I only mentioned the ADO thing in case the OP had switched methods somewhere along the line, since I've seen that happen before. Sometimes when someone is searching for a solution, they end up copying and pasting code from different...
  9. pbaldy

    error setting a tempvar

    If you're using an ADO recordset (rather than DAO), you'd need to use % as a wildcard instead of *. Paul MS Access MVP 2007/2008
  10. pbaldy

    error setting a tempvar

    Try ...where UCase(trim(AmexCurrent![Cardholder Name])) Like '*" & Tempvar_CCN & "*'") * is a wildcard for any number of characters, ? is a one character wildcard (but you can use more than one). Paul MS Access MVP 2007/2008
  11. pbaldy

    error setting a tempvar

    ..."!" isn't part of the field name, so you don't want that after. You'd also need another single quote after the variable. Try this: Set tempRecordSet2 = CurrentDb.OpenRecordset("select * from AmexCurrent where UCase(trim([Cardholder Name])) = '" & Tempvar_CCN & "'") Paul MS Access MVP...
  12. pbaldy

    Ranking Fields in a Report

    Great minds think alike, Duane. And sometimes mine tags along for the ride! :p Paul MS Access MVP 2007/2008
  13. pbaldy

    Ranking Fields in a Report

    More info here Duane: http://www.utteraccess.com/forums/showflat.php?&Board=85&Number=1796615&page=1&view=collapsed&sb=5&o=&fpart=1 Paul MS Access MVP 2007/2008
  14. pbaldy

    Subform visible only to certain currentuser() of mainform

    No problem! Post back if you get stuck. Paul MS Access MVP 2007/2008
  15. pbaldy

    Subform visible only to certain currentuser() of mainform

    The syntax for that would be: If Forms![NonEmployee Personnel].WelcomeUser = "Whatever" or Forms![NonEmployee Personnel].WelcomeUser = "Whatever2" or Forms![NonEmployee Personnel].WelcomeUser = "Whatever3" Then But for flexibility I would probably create the table. You could then use a...
  16. pbaldy

    Combo Box - Color Problem

    That sounds like a known bug. See "combo becomes transparent" near the bottom of the bugs list: http://allenbrowne.com/Access2007.html#Bugs Paul MS Access MVP 2007/2008
  17. pbaldy

    Subform visible only to certain currentuser() of mainform

    In the open event of the form, try If Forms![NonEmployee Personnel].WelcomeUser = "Whatever" Then Me.FinancialInfo.Visible = True Else Me.FinancialInfo.Visible = False End If Paul MS Access MVP 2007/2008
  18. pbaldy

    get date of previous Thursday

    A brief test showed it to work, though it subtracted a week when the date was a Thursday. In other words, a date of 2/5 returns 1/29 rather than 2/5. Not sure if that's what you want. I would have done this, which is what I tested against: [MyDate]-Choose(Weekday([MyDate],1),3,4,5,6,0,1,2)...
  19. pbaldy

    Select last record in a list

    Sounds like a variant of this: http://www.baldyweb.com/LastValue.htm Paul MS Access MVP 2007/2008
  20. pbaldy

    need help with tsql

    See if this works for you: http://www.dbforums.com/showthread.php?t=1605725 Paul MS Access MVP 2007/2008

Part and Inventory Search

Back
Top