How to write long strings to an InputBox. Q: Peter Matthews writes that help for the InputBox says it will input the user’s string, and the definition of a (variable length) string says it can be up to 2 billion characters. So how come my VBA called out InputBox won’t
How to create an Excel timesheet, and export data from an Access timesheet. Q: Maurice writes that he needs to export Access timesheet data to an Excel worksheet for distribution, since some users don’t have Access, so he can’t just create an Access report. Is there a way to do
How to find Outlook mail messages from a specific sender. Q: Ray in New Zealand writes: “I’m trying to link my Access db (Accommodation) to Outlook. I receive accommodation bookings from guests and would like to be able to click on a button on the guest data form which will
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
A reader’s having some problems backing up back end databases. Q: Bob Linthicum writes that he is having a problem with backing up back end databases using the code from Access Archon #151. He is getting Error 76, “Path not found”. A: Try my new Extras Plus add-in (Code Sample
Q: Bradley Welland writes to ask if there is any information available on using ActiveX controls in Access. A: This continues to be a sore point, even in Office 2007. ActiveX controls (other than the few native ones) can’t be depended on to work the same in Access as in
How to prevent duplicate data entry in different records. Q: Nigel Heremaia wants to prevent users from entering the same data in the FirstName and LastName fields in different records. He is using this code, but it isn’t working: Private Sub Form_BeforeUpdate(Cancel As Integer) Dim FirstName Dim LastName Dim
How to insert a field in a Word document that calculates dates. Q: George Forsythe writes: “I want to insert a field in a Word document that calculates Tomorrow’s date. It would be even better if I could make it Next Weekday’s date. There seems to be no intuitively obvious
How to edit Value Lists in Access 2007. Access Archon #169 In Access versions through 2003, if you selected Value List as the row source type for a listbox or combo box, you had to type in the list values as a semicolon-separated list, which is a tedious chore for
Q: Fred Kerr writes that code for importing data from text files that worked fine in Access 2003 doesn’t work in Access 2007. Why? A: If you are using a saved Import spec, it won’t work in Access 2007. There was a significant change in Importing/Exporting in Access 2007; import/export
How to get basic system specification info from the PC. Q: Briant Manix writes: “Do you know how to get basic system specification info from the PC? I would imagine that the function would either use a Windows API or e look up in the Registry. I want to get
Charles Hui writes: After reading your article “ACCESS Archon Column #44 – Merging to Word from Linked Access”, I have expanded my WORD template to include a table and have successfully created letters using custom doc property and table together. In our letters, the fixed Borrower Name and Address are
More on how to merge data from recordsets and queries to Word documents. Access Archon #168 Creating Queries on-the-fly for Filtering Data If you need to send letters to customers, and want the option of filtering by any country, not just the ones with the most customers, the frmMergeToWordDocProps
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
Access Archon #170 Introduction Several earlier Access Archon articles have dealt with various aspects of mass emailings. In Access Archon #106 I described how to send mass emailings from an Access table, in Access Archon #135 I described how to send reports as attachments for a mass emailing, and in
How to suppress subtotals on reports. Q: Barbara Gorches writes: I am creating a report that needs to subtotal my detail records on several different levels. Level 1 – project phase totalLevel 2 – project totalLevel 4 – grand total This works fine, but when we have a lot of
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
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
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
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 …
Access Archon #170 Before we finish this article a reminder that mass emailing should always comply with all local laws. More generally, you should ensure that all mailings are to people who have authorized the use of their email address for that purpose. Our purpose is to help you efficiently
How to change back end database structure. Q: Peter Matthews writes: “If you have split a data base, and then decide to change the data structure – say to add some extra information to a table – is this a problem? There does not seem to be any way of
How to enable Macros in Office 2007. Q: Marge W. writes that a client called her in panic, saying that “nothing works” in the updated database she just delivered. Upon questioning, it turned out that nothing happened when buttons were clicked on the main menu, and that the client had