Recent content by pbaldy

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

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

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

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

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

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

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

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

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

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

You'd have to bracket it because of the inadvisable space. I assume the "!" 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...

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

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

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

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