Enter your email address:

Delivered by FeedBurner



Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word?
Home Page

Bloglines

1906
CelebrateStadium
2006


OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal












Subscribe here
Add to 

My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  Saturday, October 30, 2010 – Permalink –

Automatically Renumber Records

Been looking for this



What happens to a list when one record is deleted?

If you need to correct the numbering, see these instructions.

Automatically renumber the records in an Access table when one is deleted

from Martin Green - FontStuff.com

See all Topics

Labels: , , , , , , ,


<Doug Klippert@ 3:24 AM

Comments: Post a Comment


  Monday, October 25, 2010 – Permalink –

Send E-mail with Access

Automate the drill


You can use Access as a data source and use Word to merge to Outlook. Here, however, is a way to do it from Access itself.
"You can use the SendObject method to send a MAPI mail message programmatically in Microsoft Access. However, the SendObject method does not give you access to complete mail functionality, such as the ability to attach an external file or set message importance.

The example that follows uses Automation to create and send a mail message that you can use to take advantage of many features in Microsoft Outlook that are not available with the SendObject method.

There are six main steps to sending a Microsoft Outlook mail message by using Automation, as follows:

  1. Initialize the Outlook session.
  2. Create a new message.
  3. Add the recipients (To, CC, and BCC) and resolve their names.
  4. Set valid properties, such as the Subject, Body, and Importance.
  5. Add attachments (if any).
  6. Display/Send the message.

Use Automation to send a Microsoft Outlook message using Access

Access to E-Mail

See all Topics

Labels: , ,


<Doug Klippert@ 3:14 AM

Comments: Post a Comment


  Sunday, October 17, 2010 – Permalink –

New Line in Memo

Labels and Text boxes


When you're using a form to enter text in a memo field, pressing [Enter] within the text inserts a line break.

However, when you're working with a memo in a table's Datasheet view, pressing [Enter] moves the focus to the next field.

You can force line breaks when you're entering text by pressing [Ctrl][Enter]. This technique also works with text fields and can be applied when you're entering text in labels or text boxes on a form.

To permanently configure a text box so that pressing [Enter] inserts a new line, set its EnterKeyBehavior property equal to New Line In Field.



See all Topics

Labels: , ,


<Doug Klippert@ 3:11 AM

Comments: Post a Comment


  Friday, October 08, 2010 – Permalink –

Sort List Boxes

We must have order




"A nice way to enhance your application is to give your users the ability to sort the contents of listboxes.

If you have a listbox with many records, this feature could be much appreciated. It's easy to manipulate the listbox RowSource property to accomplish this.

A command button could be used to add an "Order By" clause to the SQL statement, and once the RowSource property is updated, the list is automatically sorted."


An example showing exactly how to do this is available for download as a Zip file here: Sortable Link Boxes

from Peter's Software

See all Topics

Labels: , , , , , ,


<Doug Klippert@ 3:21 AM

Comments: Post a Comment


  Monday, October 04, 2010 – Permalink –

Customize the FUI Ribbon

Let the add-ins begin


It is said that the Office 2007 Graphical User Interface Ribbon cannot be as easily changed or modified like it has been in previous versions.

This may be partially true, but not all is lost.

Here is some information from the equine's mouth:


Learn how to customize the Ribbon user interface (UI) in the 2007 Microsoft Office release. Also learn how new features in Microsoft Visual Studio 2005 Tools for the 2007 Microsoft Office System support RAD development of Ribbon customizations. (40 printed pages)

Customizing the Office (2007) Ribbon


Monsieurs MS also have a downloadable spreadsheets with the Control IDs. There are files for 2003 as well.

Lists of Control IDs


2007 Office System Add-In: Icons Gallery

See all Topics

Labels: ,


<Doug Klippert@ 3:02 AM

Comments: Post a Comment


  Saturday, October 02, 2010 – Permalink –

Properties Report

Record of Records



If you would like a report that includes all of the properties, relationships and permissions of the objects in your database, go to Tools>Analyze and choose Documenter...

Access will create a VERY detailed report.

Access Documentation


Ezy Documenter
See all Topics

Labels: , , , ,


<Doug Klippert@ 3:43 AM

Comments: Post a Comment