skip to main | skip to sidebar

My MS Access Blog My MS Access Blog

Tips, tricks, best practices and more about Microsoft Office Access and Visual Basic for Applications (VBA). Links to great articles and posts around the web plus some things I've learned that I'd like to share.

Tuesday, September 25, 2007

Using dates and times in Access

This article from Microsoft Office Online is a good round-up of date and time topics.

Table of contents:

  • What can you do with date and time values
  • Sample data for use with this article
  • Entering and storing data
  • Displaying dataFilter, sort, and group data on date and time values
  • Perform calculations that use date and time values
  • Additional resources

Also see all date and time topics on my blog.

Posted by Stephen at 9:00 PM | Permalink | I'm reading: Using dates and times in AccessTweet this! | Add This! | Blog This |  

Labels: Date and time

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Translate My MS Access Blog

Search My MS Access Blog

Post Tags

Tag cloud code courtesy of phydeaux3

Subscribe to My MS Access Blog


By TwitterButtons.com

  Subscribe in a reader
Subscribe by eMail:

Delivered by FeedBurner

Share or Bookmark MyMSAccessBlog

Add This!

Blog Archive

  • ►  2011 (2)
    • ►  September (2)
  • ►  2009 (29)
    • ►  November (12)
    • ►  September (4)
    • ►  April (8)
    • ►  March (5)
  • ►  2008 (72)
    • ►  October (4)
    • ►  September (6)
    • ►  March (12)
    • ►  February (26)
    • ►  January (24)
  • ▼  2007 (55)
    • ►  December (2)
    • ►  November (10)
    • ►  October (24)
    • ▼  September (19)
      • Access-Freak : Microsoft® Access 2007 Ribbon/Offic...
      • Microsoft Access Performance FAQ- Tony's Microsoft...
      • How to optimize Office Access and Jet database eng...
      • Allen Browne on Converting to Access 2007
      • Access Team Blog Posts On Working With The Ribbon ...
      • Microsoft article "Designing Your Database Applica...
      • Using dates and times in Access
      • Database normalization basics document from Microsoft
      • "Understanding Relational Database Design" document
      • Why would I want to use a class object in MS-Access?
      • Access Dynamic Reports
      • Allow or disallow shift-key to bypass startup options
      • Only let the user add one record
      • More subqueries
      • Subqueries
      • Visual Basic Programmer's Guide : Custom Classes a...
      • Programming the FileSystemObject
      • Forms: Refer to Form and Subform properties and co...
      • Excel won't close!

Access/VBA Links

UtterAccess.com UtterAccess is the web's leading help forum for Microsoft Access. The community of Access enthusiaists who post there provide help to newbies and veterans alike, always in a friendly and supportive manner.

Access 2003 resource Centre on MSDN

Access Developer Portal on MSDN

Allen Browne's tips for Microsoft Access Allen Browne is one of the web's leading authorities on Access. Several of his articles are the standard reference for the topic at hand. Allen is also the most often cited cataloguer of Access bugs and the related work-arounds.

The Access Web This site, established way back in '98, features tips and solutions from several Access MVPs. The code samples posted here are always clean and effective. Often you won't find a lot of text, but you will find code that works. The solutions here are cited all over the web as the best way to get things done.

Stephen Lebans' site is the authority on the web for some types of solutions. It's a site every Access developer should know. You'll find tips, plus downloadable working solutions ranging from zooming images in and out, to disabling the mouse scroll wheel, to a calendar, to creating PDF files. In particular I look to Stephen's site first for advanced topics related to forms and reports, especially interacting with the Windows API.

Candace Tripp's Utter Angel page is another often-cited resource. she posts simple working solutions for download. No Access/VBA links page is complete without Candace's page.

My Blog List

  • Access Team Blog
    Stay connected wherever work takes you
    8 years ago
  • Office Client Developer Content and Resources
    Get Office developer news at http://blogs.msdn.com/b/officedevblogs
    11 years ago
  • Clint Covington: Software design, Microsoft Office Access
  • Gabhan Berry: Excel Programming

My Counters

Page Loads to Date