Join Robin Hunt for an in-depth discussion in this video Building macros to run on demand queries, part of Building Solutions Using Excel 2013 and Access 2013 Together.
- View Offline
- So you may already be using Access…and manually running queries in the back end by hand.…And you're running them in a particular order…'cause that's the way they work.…This sometimes means that you're gonna be…dealing with messages like appends and you're…about to copy or you're about to update.…It's always good to be sensitive to your row counts.…This is a great option when you have people…who need to run the actual queries for you…through a macro but you don't want to give them…backend access as well.…This is an easy way to add productivity to the process.…
Okay, so lets talk through this before…we get started.…First of all we have a macro that imports new hires.…The only challenge with the macro that we created…was that every time we do this that macro…actually just appends the data versus replaces it.…So the first step of the process is to actually…delete the new hires, import the real new hires…before we run the other steps of appending them…and updating them.…Remember, in most cases you double-click these…
These techniques are the key to better personal productivity data systems. Start watching now.
- Using the Problem Steps Recorder
- Importing and linking Excel data as Access tables
- Creating queries with tables
- Calculating data in Excel vs. Access
- Building forms
- Creating reports for your solution
- Building macros to run imports and queries