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?
F8 to step through doesn't work in access 2013 vba
0 commentaires:
Enregistrer un commentaire