Richard Webster
New member
- Local time
- Today, 15:21
- Joined
- Mar 5, 2015
- Messages
- 1
I am a retired lawyer and in my former life I set up an Access 2000 database to store data and create letters in Word. The merge facilities in Word didn't fit my case so I used bookmarks and told VBA to insert the contents of varaiables created from the database in Word.
I would debug code by toggling a breakpoint - which coloured it brown. I would then "Run Sub" in VBA (which I can't seem to do now because it wants to run a macro!) and then once at the breakpoint I would hit F8 to move to the next line and so on to see where any bugs were in the code.
I'm now using a database to deal with bookings at a Scout campsite and want to use similar procedures to insert variable content form an Access Database in a Word docx.
Now I run the procedure and when it gets to the breakpoint I hit F8 and nothing happens. I've ticked "Use Access Special Keys" in Options. Why is this?
I would debug code by toggling a breakpoint - which coloured it brown. I would then "Run Sub" in VBA (which I can't seem to do now because it wants to run a macro!) and then once at the breakpoint I would hit F8 to move to the next line and so on to see where any bugs were in the code.
I'm now using a database to deal with bookings at a Scout campsite and want to use similar procedures to insert variable content form an Access Database in a Word docx.
Now I run the procedure and when it gets to the breakpoint I hit F8 and nothing happens. I've ticked "Use Access Special Keys" in Options. Why is this?
