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
The phantom breakpoint: what causes it and how to solve the problem. Q: Don R. writes: When I click a command button to print a Word letter (this button runs VBA code to create the letter from a Word template), the code stops on a certain line, which is highlighted
An easy-to-use form that applies either one or two filters to data on a form. Introduction In Access Archon #129(Fancy Filters), I described a form that allowed you to filter data using seven filters and two sorts. Some readers found the complexity of this form overwhelming, so in response to
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 synchronize Access and Outlook contact data. Access Archon #145 Introduction If you store contact data both in an Access table and an Outlook Contacts folder, it would be handy to be able to quickly switch from the Access contact record to the Outlook contact item, or vice versa.
Looks at playing media files in Windows Media Player. Access Archon #138 Playing Media Files After (optionally) selecting a Media Path, and selecting an audio or video file, you can use the cmdPlayAudioFile or cmdPlayVideoFile buttons in the form footer to play the selected file. To illustrate two different
How to compare actual files in a folder with files names in a table. Access Archon #128 Introduction Thanks to AW reader, Keith Hungate, for suggesting the topic of this article. He wrote to ask if I could suggest a method for comparing file names stored in an Access table
How to generate sequential dates automatically. Q: Richard Bryant writes: “I have made a diary in Access. I enter a month at a time from notes on my calendar. I have to enter each date of the month each time I make an entry. In Excel the dates can be
Several readers responded with their suggestions for determining if a database exists. Thomas Mount responded to my tip on finding out whether a file exists in WAW 6.07, with a more efficient method using the FileSystemObject: Function isFile(FileName as String) as Boolean isFile = _ CreateObject(“Scripting.FileSystemObject”).FileExists(FileName) End Function
How to document an application in Access. Q: Ashjan Al-Mahmeed would like to know what is the best practice of documenting an application in Access (using the documenter and other tools). A: I recommend Total Access Analyzer, which is available in versions for Access 97, 2000 and 2002. See the
A reader wants to know how to create a mask for a credit card. Q: Melody Overstreeet writes: “How do you create a mask for a credit card? I want the last for digits to show and the rest I want to be an *” A: I like to use
A reader responds to my tip on wrapping text values in quotes, suggesting a function to streamline it. In response to my tip on wrapping text values in quotes using the Chr$ function, Stuart R Ainsworth contributed a function that streamlines this process (I have modified it slightly, and split
A simple breakdown of the rather obscure XOR operator Help topic. The Help topic for the XOr operator starts out rather obscurely by explaining that the operator is used to perform a logical exclusion on two expressions. Then it goes from bad to worse: “If one, and only one, of
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)
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
How to get basic system specification info from the PC. Q: Briant Manix writes: “Do you know how to get basic system specification info from the PC? I would imagine that the function would either use a Windows API or e look up in the Registry. I want to get
How to sort Reports by date in Access. Access Archon #163 You might need to group records by date using another interval that is not available in the Group On list. If the interval is regular, you can create a query field, such as the Decade field in qryMembers: Decade:
A reader responds to the AW article on the new “save to PDF” feature in Access 2007. Tom Van Dam writes: just finished reading your latest Access Watch on the new PDF feature in Office 2007. I have often wanted to save files to PDF format for storage and later
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 back up database objects before making changes to them. Q: Jean H. writes: “I am constantly making changes to forms, reports and other database objects, and sometimes I find that a change doesn’t work, and I need to return to an earlier version. I do back up my
How to develop applications using Access and deploy them as standalone applications. Q: Kamlesh Chand wants to develop applications using MS Access and deploy them as standalone applications (i.e., applications that can be run on machines that do not have MS Access installed on them). How can this be done?
How to get text values from the user’s selection of an option. Q: Julia H. writes: “I have an option group with choices for different areas of the country, and when the user clicks on one, I want to get the name of the area. But I can only assign
How to add a specified number of records to a table. Q: Kacie Anderson writes: “I have two tables, one for Orders and one for Loads and both of which contain an OrderID field to link them together (the OrderID is autogenerated). For each order, there can be multiple loads.
How to link dBASE tables to Access tables. Q: Mark Kraus writes: “I have data on approximately 3,000 clients in a table developed in dBase IV. I am trying to load the data into an Access 2002 table and then use the Access table in an application I’m developing in
