How to make the cursor go to the first column in the new record row. Q: Henry W. writes that he needs to move the cursor to the first column in the new record row of a datasheet subform, from the AfterUpdate event of a combo box that assigns a record source to the subform. […]
A reader wants to know how to get a report to display just the items related to a specific order. Q: George Adams is having a problem with getting a report to display just the items related to a specific order. How can this be done? A: You need to filter the report for […]
How to import the contents of a specific Word document into a Memo field on an Access form. Q: John Piper asks if there is a way to import the contents of a specific Word document, in a specific folder, into a Memo field on an Access form. A: The following Click event procedure will […]
A reader wants to know why Access loses the paper size of reports if they are anything other than letter size. Q:Jericho Johnson writes: I would like to know why Access loses the paper size of reports if they are anything other than letter size. For Example: I create a report keeping the “default printer” […]
How to add and delete listbox items, and how to get the most out of the AddItem and RemoveItem methods. Access Archon #172 Introduction About six years ago, I wrote two Access Archon articles on working with listboxes, adding and deleting items from the lists. I used tables as the listboxes’ row source, with […]