Search results for query: *

One of my applications is using a macro to send reports in Rich Text format from Access 97 by the click of a button. All worked fine until sone users switched to Windows XP. Under XP, they now get a blank (!) error message and the report fails to output into a mail attachment. At least within...

When running a macro including a list of queries and commands, is there a way to show which step is currently being executed? By default, Access 97 only shows 'Run Query' and a progress meter in the status bar, but it does not show the name of the query being currently executed. Running some...

How can I create a report with alternating background colours for each record line (price list-style)? I would assume something including an OnFormat event based on odd and even row numbers would do the trick, but perhaps someone has an easier solution at hand. Thanks, Gion

When sending a report for one record via e-mail, is there a way to automatically include a certain field value (eg. RecordID) in the e-mail header? Thanks, Gion see also thread181-159806

Is it possible to display data in a report in columns, avoiding having to use the whole page width for one recordset? I'm using Access 97, I imagine you could do it with web publishing in Access 2000, but that's not an option for me. Can anyone help? Thanks, Gion

How can I make a query that outputs a numbering field, starting at 1 for each GroupBy value? In a simple example, the result should look like this: Day Customer Number Monday A 1 Monday B 2 Monday C 3 Tuesday A 1 Tuesday C 2...