How to create a simple Add-to Combo Box. Access archon #161 Introduction Back when my Access Archon column appeared in Office Watch (around 1998), and there were no code samples, in Access Archon #7 and #8 I described how to create add-to combo boxes that let users enter new
At the end of Access Archon #159 (in AW 9.06), I noted that in some cases, multi-valued fields can replace complex code for add-to combo boxes. As it turns out, I have to take that statement back – I was relying on a feature that was pulled from Access 2007
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
An easy-to-use form that applies either one or two filters to data on a form. Introduction In Access Archon #129(Fancy Filters), I described a form that allowed you to filter data using seven filters and two sorts. Some readers found the complexity of this form overwhelming, so in response to
Some helpful insights about the future of DAO, and what it means for you. For several years now, there have been rumors that DAO would be dropped, so that in future only ADO could be used to work with Access data. While doing research for my new book, I even
A reader suggests an alternative method to referencing a subform control. Q: Bob Massey writes to comment on my answer to Noni Nabong’s question in AW 9.03, where I gave the syntax for referencing a subform control. He suggests an alternate method, as follows: I have mostly (99% of the
How to use Access 2007’s new “multi-valued fields” feature. Access Archon #159 Access 2007 has a new feature for fields: one field can now hold multiple values. This feature is called “multi-valued fields,” and is implemented by creating a field with the Lookup Wizard. On the first screen of the
A reader responds to the AW article on the new “save to PDF” feature in Access 2007. Tom Van Dam writes: just finished reading your latest Access Watch on the new PDF feature in Office 2007. I have often wanted to save files to PDF format for storage and later
How to save a report to PDF file in Access 2007. Access Archon #156 Introduction For many years now, Access users have wanted the option of saving a report to the PDF format. An Access report saved as a PDF file can be opened by anyone (unlike Access snapshots,
Access 2007 has a new Report view which implements interactive sorting and filtering. Access Archon #158 Access 2007 has a new Report view for reports, which implements a long-requested feature: interactive sorting and filtering. To use this feature, select the Report view for a report: Figure A. The new Report
How to filter reports. Q: Sandy Salas writes to ask: I have a report that has several fields on the report that could be used as a filter. … Phase, Priority, Grouping, Open, Division… I may not use all of the filters might only need the first 2 but possible
How to use Rich Text in memo fields in Access 2007. Access Archon #157 Introduction Over the years, the functionality of Access forms and reports has been significantly upgraded. In Access 2007, one long-requested feature has finally arrived in a workable form (I recall an early and unreliable implementation that
How to merge data from linked tables Q: Lisa Hartley writes: I’m planning to use the code in code2.zip to merge data from Access into word documents. Could you please give a couple lines of sample code which would tell me how to get data from a related table. In
A look at the Extras Add-in which combines the functionality of backup and field listing. Access Archon #155 Introduction In previous articles, I described a set of objects you could import into any Access database to do database backup (Access Archon #151) or list tables and queries and their fields
How to create a database with links to external documents. Q: I am looking for some information and examples for creating a database of documents….(Excel spreadsheets, PDF files, word documents, jpegs, and bimps). I would like to see an example of records with links to external docs, and perhaps an
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 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:
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
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
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
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
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
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 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