How to change the color of a specific control on a report. Q: Huber Stevan wants to know whether there is a way to change the color of a specific control on a report record by record, depending on whether certain criteria are met. A: For a report, this can
How to import the contents of a specific Word document into a Memo field on an Access form. Q: John Piper asks if there is a way to import the contents of a specific Word document, in a specific folder, into a Memo field on an Access form. A: The
How to get full justification in a Memo field on a form. Q: Bronwyn Pugh writes to ask if there is a way to get full justification in a Memo field on a form (no jagged right edge).A: From Access 2000 on, there is an alignment selection (oddly named Distribute)
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
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 create a query that returns the number of visitors (not the number of visits). Q:Adam Nims wants to create a query that returns the number of patients who have visited (not the number of visits). Each patient should be counted only once, regardless of the number of visits.
How to use conditional formatting to change the color of the highlighted record in a tabular form. Q:Ashjan Al Mahmeed wants to know how to change the color of the highlighted record in a tabular form.A:This can be done with conditional formatting (a feature added to Access in Office 2000).
Here are a couple of codes for passing parameter values to a query. Q:Michael O’neill Johnston wrote to ask how to pass a variable (created from a value in a table field) to a parameter query. A:There are many ways of passing a parameter value to a query. If you
How to print envelopes directly from Access. Q:Jim Coxon writes: “What I need to do is to print envelopes directly from Access. i.e. Customer rings up for tickets, agent enters details into Access using a form, form is printed, agent puts tickets into envelope. If we could print the envelope
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
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 add new color constants. Q: James T. writes: “I need to use certain colors for the back color of controls (I am changing the color from code on a report’s Detail section Print event procedure). The VB color constants enum only has a few colors (vbRed, vbBlue, etc.).
Option Explicit – to use or not to use? Q: Matt Perelstein writes: “I was wondering what you thought about using Option Explicit? It used to be a default, included with each module, but I noticed that in Access 2003, it’s not any more. I’ve used it religiously for years,
How to email attachments using the redemption library. Q: Mark Riddick writes: “Before OMG became an issue I used to email snapshots of Access reports using docmd.sendobject etc etc. How do I achieve the same thing using Redemption? The database in question is Access 2000.” A: OMG (the annoying Object
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
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
Some code or query expressions that were working have stopped – here are the updated applications. Recently, I have had to modify several Access 2000 applications that are currently running in Access 2002 or 2003 because code or query expressions that used to work have stopped working. The problems are
A reader’s having problems setting margins to very small. Q: Robert Byrne writes: “I am using Access 2000 to create signs. It’s similar to a mail merge. I have a database with product information and create signs 5.5 x 4.25. It all works great except Access won’t let me change
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
Using the Office Envelope Object in Office 2000 – what works and what doesn’t. Some readers have asked whether the Office Envelope Object (featured in Access Archon #122) can be used in Office 2000. Well, sort of. While writing the article, I tested the two procedures in Office 2000 and
How to make the combo box display the DistrictName value when the combo box is closed. Q: Mary V. writes: “I have a combo box that is bound to a DistrictID field, but the drop-down list shows a descriptive field, DistrictName. (The column widths are 0; 2). This works fine
How to export contacts from an Access table to an Outlook folder. Q: Farouk Dawood has written code to export contacts from an Access table to an Outlook folder, using the CreateItem(olContactItem) syntax, but it isn’t working – the new contacts are being created in the default local Contacts folder
Here’s the code to use to email Excel worksheets (using the Word envelope object). Access Archon #122 Access versions: 2002 and 2003 In Part I of this article I discussed how to use the Word envelope object to email Word documents and Excel worksheets, thus avoiding the pain of attachments
How to group database objects in Access 97. Q: Ron McIntire would like to be able to group database objects in Access 97, similar to the built-in feature in Access 2000 and higher. Is there any way to do this? A: This could be done (in a limited fashion)