Free E-Books

Set it to No to hide the results of the macro or Yes to show the results. Set the
Status Bar Text argument to give the user an indication of what??™s happening. This is
useful in longer-running macros to know where in the process the macro is.
n OpenQuery: This action opens a select or crosstab query or runs an action query. The
Query Name argument contains the name of the query to open or run. The View
argument lets you pick the view??”Datasheet, Design, Print Preview, PivotTable, or
PivotChart??”that a select or crosstab query opens in. The Data Mode argument lets
you choose from Add, Edit, or Read Only to limit what users can do in a select query.
The View and Data Mode arguments are ignored for action queries.
The heart of the macro is the four OpenQuery actions that run the four action queries.
qryDeleteContactsBackup and qryDeleteProductsBackup clear the contents of
tblContacts_Backup and tblProducts_Backup, so the current data can be copied into
them. qryAppendContactsBackup and qryAppendProductsBackup append data from
tblContacts and tblProducts into the backup tables.


Pages:
2114 2115 2116 2117 2118 2119 2120 2121 2122 2123 2124 2125 2126 2127 2128 2129 2130 2131 2132 2133 2134 2135 2136 2137 2138