Back in 2002 I wrote an Access Archon article dealing with reference issues, among them the problem of certain references being upgraded when a database is opened in a higher version of Access, but not downgraded when it is again opened in a lower version. You might think that over
The two procedures will let you easily clear up redundant Word documents, and alphabetize lists of declarations. Access versions: 2007-2013 Level: Intermediate Introduction The two procedures described in this article will let you easily clear up redundant Word documents, and alphabetize lists of declarations. When working on the 3rd edition
Q: Susan H. writes that she has some standard code that creates a Word document and puts some Access data into it, using VBA Automation code. But sometimes the Word window is hidden behind other windows, either the Access window itself or some other window. A: This is a long-standing
Q: Lou writes that sometimes when he clicks on a label in Design view, in order to change the caption, it displays with a dark back color, which is disconcerting. The Label control’s BackStyle property is set to Transparent, so it shouldn’t be displaying as a color. How can this
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
How to index the code on ASP and ASP.net web pages with Windows Search A problem with Windows Search is the default treatment of web pages with programming code like PHP, ASP and ASP.net. The Windows Search indexing filter for these types only indexes the visible parts of the web
The new cover for third generation Kindle devices is very clever. I like the look of the new Kindle with WiFi only. Many people have never felt a pressing need to use the 3G service if only because it’s too tempting to make impluse purchases. It also reduces the battery life
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
From: Microsoft This is a direct copy of the Office 2010 pricing as presented by Microsoft with all the footnotes described as a ‘more detailed guide’. Microsoft Office 2010 Retail Pricing Comparison Chart January 2010 Office Home and Student1 Office Home and Business Office Professional Office Professional Academic Word 2010
Pity about the name but ‘God mode’ is a handy trick for Windows 7 and Vista. In fact you don’t need ‘God’ at all. Again, this isn’t MS Office but it’s too good to ignore … Given how sensitive some religious people can be, it’s little wonder Microsoft doesn’t want
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
Like almost any web site, we use technologies like cookies to store and/or access device information. We aim to keep that to a minimum. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions. We apologize for this box but it's legally required in some regions.
Functional
Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.