Suiting Access 2007’s Navigation Pane display to your liking. Q: Gordon Rennie writes: “Now with Access 2007 the database window has disappeared and been replaced with a stupid list at the side that only shows one item per line. Is there any way to get the database window back? or is it a matter of […]
How to open a form when making a selection from a listbox on another form. Q: Martin wrote to ask if I could help with code to open a form to a specific record when the user makes a selection from a listbox on another form. A: This is easy to do, at least if […]
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, which are only viewable by […]
A reader offers some further information about the CreateMonthList function. José Dumoulin wrote in response to the CreateMonthList function in the sample database for Access Archon #146: For us, Europeans, it is necessary, in this line, to replace commas by semicolons: strMonthList = strMonthMinus3 & ” ” & strYearMinus3 & “; ” _ & […]
How to display an ID field in a closed combo box but hide it in a drop-down list. Q: Rich writes that he needs to display an ID field in a closed combo box, but doesn’t want it to appear in the drop-down list. The field is the first one in the combo box’s row […]