On my Switchboard how can I program a macro or something to click on and it will open a my word templete for a form to fill out and then update my database with the info when I close it.
Would you consider making an Access form for getting the data, and then automatically fill the form in Word, or even easier, to create a report just like that form?
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.