Search results

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

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

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

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

This should be easy but I'm struggling. I want a very basic report that shows: * all field reps (sales people), * their quota in terms of new customer registrations * their actual new customer registrations for a particular month The report should include field reps with 0 sales. The...

I am trying to export a table with VBA. This code works fine: DoCmd.OutputTo acOutputQuery, objectName, "ExcelWorkbook(*.xlsx)", "TESTFILE.xlsx" The code below (with a path) does NOT work. The only difference is the path prefix. I have tried different paths with no success. The error is...

I am periodically importing Excel files into access. Making the data usable requires removing spaces, parsing certain fields, adding datasource field, etc. Currently, I am importing the un-formatted data into a staging table, cleaning it up with a query and then copying the updated staging...

I need to update a field whenever another field changes via a query. The solution is probably obvious but I'm a newbie -- any ideas appreciated. I have a table tracking all mobile payments received. Table name is tbl_payments which includes 2 fields: accountNumberValid -- "Yes/No" which...

I have a form with customer info. When user changes a value in the productChosen combobox, other fields should change. I have experimented with "After Update" and "On Change." In both situations, I see identical behavior with respect to the underlying table -- the table is getting updated...

I have a form for new customers. One of the fields is the product they have chosen ("new model", "old model", etc.) in a drop down Combo box. I want default pricing to appear in the form based on the what user selects for the product. But, I am getting nothing shown in the price box after...

Things were going fine :banghead: .... I'm building a query that creates customized SMS messages based on customer payment statistics.... "Your balance is $100 and please make a payment by Dec 1, 2013." I have a field called [smsIdentifierToUse] that determines which SMS "template" to use...

I want to generate a file of customized SMS messages for my customers. There are 10 types of messages "your balance is xxx" "thanks for your payment of xxx" "we have not received a payment since xx/xx/xx" I've tried creating an "SMS" table with 10 generic messages in 10 records... record 1 is...