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 […]
A great overview and comparison of Access, SQL Server, Visual Studio and the .NET Framework. From time to time I get a message from a client asking whether they should upgrade from Access to SQL Server, usually after seeing some presentation or ad for SQL Server. Sometimes this is appropriate (say, when they anticipate storing […]
How to have a form open to the last record. Q: Manjit Lota writes to ask how he can have a form open to the last record. A: There are several ways you can do this. If you want to use the form for data entry, change the form’s DataEntry property to Yes. Then it […]