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
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
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
Access Archon #172 Using the AddItem and RemoveItem Methods The frmPairedListboxesMethodsUnsorted form uses the new AddItem and RemoveItem methods to move items from one listbox to the other. You can’t simply iterate through the ItemsSelected collection of the listbox, and use the appropriate method, since using AddItem or RemoveItem
Q: Mark Jackson writes that he is having trouble getting code that picks up values from textboxes on a form to work – a Help topic said that the focus must be on the control in order to pick up the topic. A: Some of those Help topics are very
Access Archon #162 Getting around Vista Security We have all seen those ads where the Mac guy acts superior to the PC guy who is constantly bothered by the Vista Secret Service agent asking if he wants to cancel or continue every time he tries to do something on his
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
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
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
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 the Set Control Defaults in Access 2007. The handy Set Control Defaults command on the Format menu in Access 2003 (and earlier) can be hard to find in Access 2007. It is in the Controls group of the Design Ribbon, with a crossed tools and disc image:
Access Archon #174 The code that does the work of listing, clearing and copying doc properties is listed below. VBA Code Private Sub cmdCopy_Click() On Error GoTo ErrorHandler Dim cbo As Access.ComboBox Dim intType As Integer Set cbo = Me![cboSelectTableOrQuery] strTemplate = Nz(Me![txtTemplate].Value)
How to get calculated fields to display zero. Q: Rob Stoker writes: I have a calculated field which is sum([nettprice]*[quantity]) which works ok. However if there is no data then it displays #Error. I have tried the Nz function, and tried the IIf function but I can’t seem to stop
Adding and subtracting dates. Q: Martin writes: I have these records written in two lines (dates, without separation in the European style (1030)) 051007 051107 I then want to take the dates and subtract the dates from each other and get how much time has passed. An easy task
Access Archon #174 Introduction Many of my code samples write data from Access tables or queries to document properties in Word documents. For this technique to work, you have to add the appropriate doc properties to the Word template, which can be a time-consuming process. In this article I
How to set column heading text for datasheets. Q: Jane H. writes that she has started using a naming convention for form controls (Helen’s comment: definitely a good idea!), but now she is seeing the control names, with prefixes, as the column headings in datasheet subforms. Is there any way
A handy solution to the problem of disappearing form view headers and footers. Q: Bob writes that in Access 2003, when he is working on a form in design view, and turns on form headers/footers (using the View Form Header/Footer menu command), often the header and/or footer section doesn’t show
How to make the current row a different color for continuous forms or datasheet type subform (and for continuous forms-type main forms). Access Archon #173 Introduction When you have a form with a continuous forms or datasheet type subform, sometimes it is a good idea to highlight the current row
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