How to synchronize Access and Outlook – a more advanced lesson. Q: Jim Brooking writes that he is trying to use my Code Sample #49 for synchronizing Access and Outlook contacts, but it doesn’t do all that he wants, in particular two-way synchronizing. A: My Code Sample #49 dates from about 10 years ago, when […]
How to do calculations on a form and store the results. Q: Rob Stoker writes: I have a table called “tblPartHistory” where I store the quantity of parts used in the field “quantity”. When I enter the quantity used into the form I want it to subtract the amount used from the table “tblPart” with […]
In response to my tip on Updating Word fields in Documents Created from Access Merge in AW 9.11, Peter writes: Note there is a significant issue in the section mentioned above. The code shown does _not_ update fields in headers or footers. Word doesn’t make it easy to work with those sections; you’ll need to […]
Microsoft has released a set of programming tools to let developers work with Office 2007 documents without the Office applications themselves.click here for more …
How to stop Access auto-correcting your typing when you don’t want it to. Q: Maryann S. writes: “My application uses a number of two- or three-letter codes as field values. Sometimes, when I type one in, it changes to something else (for example, HGE changes to HE). How can I stop this? It is really […]
