To create an invoice in our accounting package (MYOB) we need to transfer information from various fields displayed on an MS Access form into corresponding fields in MYOB. When I have to do many invoices I currently create a csv file from MS Access and import to MYOB but when I need to do one or two invoices it is quicker to just copy and paste data. However if I could create a keyboard macro then it would be even quicker.
So is there any way of using VBA to run a keyboard macro that will enter a sequence like:
CustomerName <Tab><Tab><Tab><Tab> OrderNumber <Tab> OrderDate <Tab> Description <Tab><Tab> Amount <Tab> JobId
Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline
In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page.
The problem with sub-reports and headings:
Add a dummy group to the sub report using the expression =1:
Set the “Repeat Section” property of the dummy…