Recent content by thardyjackson

Is there an add-in or some way to format my SQL like adding line breaks, etc. It's hard to review and debug when I have one long sequence. I'll add carriage returns but they aren't saved when I reload the sql. Thanks MS Access 2010

SOLVED by using Me.Undo http://www.pcreview.co.uk/forums/differences-between-me-undo-and-docmd-runcommand-accmdundo-t1162440.html

Don't want this ability. I thought "Undo" was only available while in the current record. Here were my steps: 1 - Loaded form that shows 1 record per form page. 2 - Edited a record 3 - Moved to another record with status bar nav arrow 4 - Verified my edit was in the underlying table 5 - Moved...

I got something working that only takes 10 seconds (big improvement over 6 minutes with DSUM). See below. The biggest challenge is that accurate account numbers don't exist in tbl_payments2 (customer typos, etc.). So, I have to override some account numbers before calculating the running...

We want customers to receive 1 SMS for each payment they make so they know it was received and credited to their account. Running balance is preferred over current balance since it shows their balance changing with each payment. Thanks.

I think I need a running sum not a current total because the SMS messages are sent in batch. For example, someone sends $10 once at 9AM, once at 10AM and once at 11AM. The next day we download the transaction file from the bank and create the SMS messages. The customer should get 3 messages...

Pat -- Thanks for the response. The running sum is used in SMS messages sent to customers acknowledging their payment (e.g., "Thanks for your payment of $10, you have paid $30 in total. You are only $25 away from saving enough money to get your water pump."). There are 25 SMS message templates...

Pat -- Tried your suggestion but not getting expected result. Expected result ... if a customer made 3 payments of $10, [pmtSumAfterPmt] (the customer-specific, running total field) should show $10, $20, and $30 next to the relevant payment. Actual result... [pmtSumAfterPmt] shows $10 each...

I just experimented by dumping all data from qry_pmtTblProcessing into a new table and ran qry_pmtRcptAnalysis off of the new table. Exporting qry_pmtRcptAnalysis only took 20 seconds instead of 6 minutes. Was qry_pmtTblProcessing re-running every time DSUM looked up something in that query...

I have a calculated field [pmtSumAfterPmt] that’s a running total of payments for each customer. It's based on DSUM. It is super slow -- as a point of reference, adding that one field to the query causes an Excel export of 1500 results to take 6 minutes instead of 3 seconds; viewing the...

I remember hearing about this issue. It's happening to me. I wrote a SQL query that works fine. But when I call a custom function to export it to Excel, my query SQL will get deleted (not consistent). All that is left of the script is SELECT; Anyone know why this is happening and how to...

CJ -- Thanks. Can you give me an example of what you mean by your comment below? Also, I should have mentioned I also have a control on formA that filters the results of queryB. Not sure if that requires a re-run. Perhaps that example is what you mean be your comment below?

In simplified terms, I have reportFinalResults based on data from queryA which is based on results from queryB which uses data from table1, table2, etc. If I update table1 and table2 and then open reportFinalResults, will the changes to table1 and table2 be reflected in reportFinalResults...

Thanks folks.

Is there a good resource with guidance on when to use brackets, periods, exclamation points, etc.? For example .... tableName.fieldName vs. tableName.[fieldName] vs. [tableName].[fieldName] [Forms]![formName].[nbrCustAcct] vs. [Forms].[formName].[nbrCustAcct] [Forms]![formName].[nbrCustAcct]...