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 of my Working with Word […]
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 problem in Office Automation. Many […]
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 be fixed?A: This can happen […]
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 Format menu. But these features […]
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 this problem, make a calculated […]
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 standard Microsoft auto formatted table […]
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. That technique is still useful, […]
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 the Orders table. If the […]
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. Where is it?” A: For […]
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 make it look disabled by […]
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 Access to multiple worksheets within […]
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. That is the topic of […]
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 add-in that works in Access […]
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. SQL Backup and FTP lets […]
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 the web and turn it […]
How to enter accented characters, grave, circumflex, umlaut etc when they aren’t on the keyboard. Typing accented letters can be a chore and a mystery, especially for those of us unaccustomed to languages with the ‘extra’ letters. The keyboards don’t show accented letters and it’s not obvious how to type them. It’s good to get […]
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 Word, Excel, PowerPoint, Outlook, Access, […]
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 data from the report’s record […]
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 page using a HTML filter, […]
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 of the device – even […]
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 developers to make ‘solutions’ (aka […]
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 Word 2010 Word 2010 Word […]
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 to talk about the Windows […]
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) strRecordSource = Nz(cbo.Column(0)) […]
A look at a few of the embarrassing glitches in Word 2003’s in-built dictionary function. How do you spell ‘Barack Obama’? Maybe it’s ‘Barrack Osama’ ? Word 2003, Vista or Windows Server 2008 might tell you that. click here for more … See Also Why is an eighth grader smarter than Microsoft Word? Spell-checker pulps […]
Q: Fred Kerr writes that code for importing data from text files that worked fine in Access 2003 doesn’t work in Access 2007. Why? A: If you are using a saved Import spec, it won’t work in Access 2007. There was a significant change in Importing/Exporting in Access 2007; import/export specs are now saved in […]
How to show multiple lines of information about listbox items. Access Archon #164 Introduction Listboxes are a convenient way to select one or more items for action, such as creating Word letters or printing a filtered Access report. But sometimes you need to see more than a single line of information about an item, […]
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 came across a Microsoft document […]
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. This article tells you how […]
How to change the sorting order of a report. Q: Steve Rudder writes: “I have an Access report that the user would like to be able to change the sorting order. For example, some of the columns they’d like to sort on in the report are Start Date, End Date and a tracking number. Can […]
A reader has provided this helpful code that allow user’s to add multiple attachments. In response to my article on faxing with DDE in AW 5.12-5.14, Tim contributed some code for adding multiple attachments: ‘Add attachments Set rstAttachments = _ db.OpenRecordset(“Select * from tblBulkEMailMessageAttachments”) If rstAttachments.RecordCount > 0 Then With rstAttachments .MoveLast .MoveFirst Do Until […]
These are some different settings user’s can use to yield the week number in the format they want. Q: Terry Smith writes that the expressionFormat(Now(),”ww”) Which used to yield the correct week number, no longer does so (in early 2005). A: This is not a bug, but a result of the Format function using default […]
How to turn off the make-table query warning message. Q: Steve Mason wants to know how to turn off the warning message saying “X table will be deleted” before the query runs. A: Open the Options dialog (Tools|Options) and click the Edit/Find tab. In the Confirm section there are three checkboxes that control whether […]
Here’s a handy trick to move or resize a hidden control. Q: Sue S. writes: “Sometimes I need to resize or move a control that is hidden under another control, and it is a real pain to have to use the combo box to set focus on it. Is there an easier way?” A: Here […]
How to change multiple object icons to just one Access icon that represents the database. Q: Sally Q. writes: “I am using Access 2002/Windows 2000, and instead of a single Access icon on the taskbar, I see several different icons, apparently representing every open object in the database. This is confusing. How can I just […]
How to make a datasheet column invisible. Q: Mary H. has a datasheet column that is needed for doing calculations, but she doesn’t want it to show. She set its Visible property to No, but it still appears in datasheet view. How can the column be made invisible? A: The Visible property doesn’t work to […]
How to skip mailing labels in Access Reports. Q: Dan Holme wants to be able to print just a few labels on a sheet of labels, to avoid wasting a partially used page.A: There is a KB article on this topic — Q299024. I haven’t tried, it, though.
How to format a cell or row in a list or combo box using conditional formatting. Q:Dale Stark writes that he has Access 2000, and would like to make a row or cell in a list or combo box a different color or font based on some condition. He had heard that this was possible, […]
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 it doing it. I would […]
Information on an unpatched security glitch in Word 2002 (Office XP). Microsoft has disclosed a unpatched security glitch in Word 2002 (Office XP) only,click here for more …
