How to auto-populate City and State fields on a form when the user selects a Zip Code. Q: Joe O’Meara wants to auto-populate City and State fields on a form when the user selects a Zip Code. How can this be done? A: Here is a procedure that updates
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 wants to know if there’s a tool that sets up code for error handling. Q:Stephen Young writes to ask whether there is a tool for Access that sets up the code for error handling in a function or sub. A:There is no built-in tool for this purpose in
How to find Outlook mail messages from a specific sender. Q: Ray in New Zealand writes: “I’m trying to link my Access db (Accommodation) to Outlook. I receive accommodation bookings from guests and would like to be able to click on a button on the guest data form which will
Access Archon #170 Introduction Several earlier Access Archon articles have dealt with various aspects of mass emailings. In Access Archon #106 I described how to send mass emailings from an Access table, in Access Archon #135 I described how to send reports as attachments for a mass emailing, and in
Q: Sanjay Singal wants to know how to send an attachment generated from Access data in an Outlook email message. A: Access Archon #148 deals with this topic (creating and mailing attachments in an email message). In this sample database, the values of various email message fields are picked up
How to create an Add-to Combo Box with a Data Entry Form. Access Archon #161 Creating an Add-to Combo Box with a Data Entry Form If you want to add new entries to a table that has more than one or two fields, a different technique is needed: opening up
Tips for using dates in file save names. Q: Luis Pelaez writes to say that he is having a problem creating a document save name with a formatted date. A: You can have problems if you use slashes in file names, such as the standard mm/dd/yyyy date format. I use
How to display linked records before deleting them. Access Archon #147 — The VBA code for the command buttons is listed below: VBA Code frmOrderCleanup Private Sub cmdDeleteOrder_Click() On Error GoTo ErrorHandler Dim strPrompt As String Dim strTitle As String Dim intReturn As Integer
How to insert a progress bar into an Access application. Q: Martin Wichmand writes: “I looked in your site for at simple example with a progressbar – have you made one? You know like the progressbar fx shows how many days since current a day have until a deadline in fx
Shows some more options that are available to you when using the Printer Object. Access Archon #131 The AssignPrinter procedure given in Part 1 of this article will do fine if you need to ensure that a specific report will always be printed to a specific printer (especially if
How to convert Access data from a newer version so it can be viewed in an earlier version. Q: Linda Vazquez was sent an Access 2003 database, but she has Access 2000. Is there any way to open this database, even just in read-only mode? A: If you have Access
How to rename the column headings for combo box columns. Q: John V. wants to be able to give the column headings for combo box columns the names he wants – not just pick up the field names. A: This can be done by entering the column heading text you
How to make the cursor go to the first column in the new record row. Q: Henry W. writes that he needs to move the cursor to the first column in the new record row of a datasheet subform, from the AfterUpdate event of a combo box that assigns a
A reader wants to know how to get a report to display just the items related to a specific order. Q: George Adams is having a problem with getting a report to display just the items related to a specific order. How can this be done? A: You need
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
A reader wants to know why Access loses the paper size of reports if they are anything other than letter size. Q:Jericho Johnson writes: I would like to know why Access loses the paper size of reports if they are anything other than letter size. For Example: I create a
How to add and delete listbox items, and how to get the most out of the AddItem and RemoveItem methods. Access Archon #172 Introduction About six years ago, I wrote two Access Archon articles on working with listboxes, adding and deleting items from the lists. I used tables as
A great overview and comparison of Access, SQL Server, Visual Studio and the .NET Framework. From time to time I get a message from a client asking whether they should upgrade from Access to SQL Server, usually after seeing some presentation or ad for SQL Server. Sometimes this is appropriate
How to have a form open to the last record. Q: Manjit Lota writes to ask how he can have a form open to the last record. A: There are several ways you can do this. If you want to use the form for data entry, change the form’s DataEntry
Making records appear in the order they were entered. Q: Frank Payne writes: “I would like the data in a particular table to appear in exactly the order in which I enter the records. I do not want it sorted in either Ascending or Descending order. I have deleted the
How to create a date range filter. Q: Fredm writes: “I have a table that has two different date fields but I have linked them to one date table. I want to filter the results of the date to show records from now to 30 days before but find that
How to get a return value of the number of full years elapsed between two dates. Q: William Butler writes: “I have been working on this problem all day, writing an expression in a query to show the difference between today’s date and one that just passed. It seems it
Here’s a more streamlined method for backing up databases without exiting them. In Access Archon #115(WAW 5.16) I described a method (usable in database formats from 2000 up) for making a backup of the current database, without exiting the database. This is very handy when working on a database –