Back in Access 2003, you could easily change the font name and size for a datasheet form by clicking the square in the upper-left corner of the datasheet (in datasheet view), and selecting the font and size from the selectors on the Formatting toolbar, or by selecting Font from the
If you need to create a filter string for filtering by a person’s name, or a city name, you may run into this error: This is because single quotes are used as the delimiter for Text strings, and there is a single quote in the city name. To get around
Some great tips on table formatting. Joey Cherdarchuk has a nice posting on a very different table styling to the type that Microsoft prefers. Under the banner ‘Clear Off the Table’ he suggests getting rid of gridlines and colors to simplify the look of tables. In his example, Joey takes a
Access Archon Column #230 – Making Concatenated Strings from Linked Tables and Multi-valued Fields Access versions: 2007-2013 Level: Intermediate Introduction Back in 2001, I wrote an Access Archon article (#89, Flattening Linked Data) which showed how to create a string of concatenated data from values in a one-to-many linked table.
Access Archon Column #229 – Fixing Normalization Errors Access versions: 2002-2013 Level: Intermediate Introduction Sometimes when you take over an Access database created by an amateur (or at least, someone with a minimal understanding of normalization), you will find data such as employee names stored in a Text field in
Finding the location of the Office object model DLL Q: Frank H. writes: “I want to use the FileDialog object to create a browser for selecting a file, but it requires a reference to the Office object library, and I can’t find that library in the list of Microsoft objects.
Access: Disabling a Label control Q: I need to disable a Label control, for a consistent appearance with some other controls on a form. But this control doesn’t have an Enabled property. Is there some way I can do this? A: You can’t disable a Label control, but you can
Exporting Filtered Data to Excel Access versions: 2007 – 2013 Level: Intermediate In Access Archon #200 (Exporting Access Data to Excel), I showed how to export data to an Excel workbook, using various techniques. In this article, I expand on that theme, showing how to export filtered data from
By Helen FeddemaAccess versions: 2007-2013Level: Intermediate The main menu of the sample database for Access Archon #212 (A New Style Main Menu) has selectors for filtering a report by CustomerID or OrderNo. But sometimes you might want to print a filtered report right from the current record of a form.
by Helen Feddema I recently had occasion to set up a VM with 64-bit Windows 8.1 and 64-bit Office 2013, and I tested several of my add-ins in that environment, as well as Rick Fisher’s Find And Replace (the 64-bit version). I found that my Extras Plus add-in (an .mda
A simple way to backup your SQL databases and move them offsite. SQL Server from Microsoft has a built-in backup utility however it doesn’t compress the backup nor let you move it to another machine. That’s where SQL Backup and FTP comes in, a nifty add-on for a reasonable price.
How to get detailed SuperPAC donation and spending information into Excel. Today the US Federal Election Commission (FEC) is receiving and publishing details of the controversial SuperPAC’s showing who has donated and what they spent money on. It’s a good and timely example of how you can get information from
Free training manuals for Office 2007 and before plus Quick References for Office 2010. Mouse Training in the UK has released their training manuals free for all comers plus some Quick Reference Guides. The Training Manuals are for Office 2007, Office 2003, Office XP (2002) and Office 2000. They cover
There are several built-in ways to export Access data to Excel. There are several built-in ways to export Access data to Excel. You can use the Excel button on the Ribbon (or toolbar) to export a report (or other object) to Excel, or the TransferSpreadsheet method in code, to transfer
The distributable code for Access 2010 developers is now available, but beware bugs. The Microsoft Access 2010 runtime download is now available from Microsoft. There are two versions available – 32-bit and 64-bit depending on which type of Windows you have. The runtime download is freely distributable and allows Access
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 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 merge data from a recordset based on a query to Word documents. Access Archon #168 Introduction An AW reader wrote to me asking if the document properties merge code in my Code Sample #24could be modified to merge data to Word from a query, instead of selections
How to update Word fields in documents created from Access Mergee. Q: Richard Lally writes: I am very interested in trying the Mail Merge method you suggest but I am anxious about one thing. The templates include a number of fields that need updating when a document is created from
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 ensure leading zeroes are not discarded. Q: Albin Moroz wrote me to say that he is having problems keeping the leading zeroes in U.S. Social Security Numbers (SSNs). He was using the expression Format(Nz(patientRS(patient.SSN), “”), “###-##-####”) which discards leading zeroes. A: Instead of the # placeholder, which discards
How to export data that’s to be archived to an Excel worksheet, and then remove the exported records from the Access tables. Access Archon #143 The procedure that exports the data to be archived to an Excel worksheet, and then removes the exported records from the Access tables, is listed
A reader offers another method for automatically backing up databases, one which runs every time the database starts. In response to my update on backing up Access databases in AW 7.14, Wim Vermeer contributed his routine, which runs every time the database starts. It will make a backup folder (if
A reader’s method for calculating total hours. Bill Patterson responded to my request in Access Archon #129for alternate (possibly simpler) methods of calculating total hours. I used a series of calculated fields in a query to do the calculations; by contrast, the Nearest_Time function listed below does all the calculations
