Play button replays our keystrokes, and presto, the next line of code is written: Stop Recording button to save our keystrokes. Line from the field name, then move to the same place on the next line: Keystrokes It's simple! Move the cursor to the beginning of FirstFieldName, then record the keystrokes necessary to convert that line to this:

Rather than manually entering the text for each line, wouldn't it be easier to do it just once for the first line and repeat it for the others? Recording Keystrokes RstTarget! = rstSource!īut before we wrote that code, we only had the list of fields inside the Do.Loop: Set rstTarget = dbs.OpenRecordset('tblTarget') Set rstSource = dbs.OpenRecordset('tblSource') Let's say we want to copy fields from one table toĪnother.

Here's a simple example of how you may can use the macro Note that the Macro Recorder only records keystrokes and not references to the menu or mouse movements and clicks. Keystrokes are repeated exactly the way you originallyįYI, the appearance of the buttons may differ based on your Windows and VB6/VBA version but the order is always the same. To repeat your keystrokes, then press Play. Move your cursor to the location where you want This is enabled after you press the Stop Recodingīutton. You're done with your series of keystrokes, press this This is enabled after you press the start button. To start, select macro recorder from the Total Visual CodeTools menu or toolbar: Series of keystrokes and replay them directly inside your VB6 or VBA Editor The Macro Recorder is a very powerful tool that lets you record a complex

Macro recorder windows