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
How to create an Add-to Combo Box with a Data Entry Form. Access Archon #161 Creating an Add-to Combo Box with a Data Entry Form If you want to add new entries to a table that has more than one or two fields, a different technique is needed: opening up
How to get Access add-ins to work in Access 2007 running on Windows Vista. Access Archon # 162 Introduction I have add-ins that were originally developed in Access 97 that have worked in all versions up through 2003, and others that had features new to Access 2000 or Access
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 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
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 list detail items on a report in the order they were entered. Q: Scott Campos writes: “I want the invoice report to print in the same order as is entered on the order form. This makes it much easier to manually double check an order to make sure
Here’s an updated way for you to add backup capability to an Access database. Access Archon #151 Introduction A few years ago, in Access Archon #115, I described a way to create backups of the current database, using several objects that you could import into a database, to make
How to total a calculated field on a report. Q: Marie H. needs a total in a report group footer, based on a calculated field in the report detail section. =Sum([txtWeekTotal]) doesn’t work – how can this field be totaled? A: You can’t total a textbox, but you can total
How to use Access custom database properties to store information in a database, out of sight, but available to your code as needed. Access Archon #152 Introduction Sometimes you may need to store bits of information in a database, out of sight, but available to your code as needed.
Access Archon #152 The Sample Forms The sample database has two forms, frmGetFromDBProps and frmSaveToDBProps. frmGetFromDBProps has an Open event procedure that first clears and then refills a table with the current database properties, and requeries the cboSelectProperty combo box. The txtPropertyValue field displays the property value from the
How to filter a table-type recordset. Q: Mark Jackson writes: “Does anyone have a very complete example of how to open a table type recordset based on a table in the same database? I can’t seem to find what I am missing in my code. I was able to get
Making records appear in the order they were entered. Q: Frank Payne writes: “I would like the data in a particular table to appear in exactly the order in which I enter the records. I do not want it sorted in either Ascending or Descending order. I have deleted the
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,
How to filter a form from a listbox selection. Q: Martin later wrote with a related question: he is getting Runtime error ’13’: Type mismatch when running the following code (which is intended to filter the current form by the double-clicked item in the listbox): Private Sub lstSamtaler_DblClick(Cancel As Integer)
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
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
Tips for using dates in file save names. Q: Luis Pelaez writes to say that he is having a problem creating a document save name with a formatted date. A: You can have problems if you use slashes in file names, such as the standard mm/dd/yyyy date format. I use
A new ebook on using Microsoft Access to make great Word documents. Office Watch and Helen Feddema are delighted to announce the publication of a new Office Watch ebook especially for Microsoft Access users. Access Archon – Working with Word by Helen Feddema, editor of Access Watch. Like
How to use the Outlook View Control on an Access form When Office 2000 was introduced, and the Outlook View Control first became available, I tried it out, but found it so buggy and difficult to work with that I set it aside as unusable. Recently, I decided to try
More solutions to Access AutoNumber problems. I have received several more solutions to the AutoNumber problem discussed previously with the Access Archon article “Recovering from an AutoNumber Disaster.” With these solutions, and the ones in the last AW, you should be able to find some solution that works for you,
A look at the ribbons and menus in the next version of Access A look at the ribbons and menus in the next version of PPT. We’ve already looked at Word 2010, Excel 2010, OneNote 2010 and Outlook 2010 plus the new look Office button menu. These sneak peeks into the Office
