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
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
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
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
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
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
How to find the Set Control Defaults in Access 2007. The handy Set Control Defaults command on the Format menu in Access 2003 (and earlier) can be hard to find in Access 2007. It is in the Controls group of the Design Ribbon, with a crossed tools and disc image:
In response to my tip on Updating Word fields in Documents Created from Access Merge in AW 9.11, Peter writes: Note there is a significant issue in the section mentioned above. The code shown does _not_ update fields in headers or footers. Word doesn’t make it easy to work with
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
