Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

Your profile

Tools

Authors

Main Categories

Search

XML Feeds

RSS 2.0: Posts, Comments
Atom: Posts, Comments

What is RSS?

Google Ads

Categories: Microsoft Access, Access Forms & Reports, Access VBA & Jet SQL

comments

Microsoft Access Wikis on LessThanDot

by remou on Nov 05, 2009 in categories Microsoft Access

Rate Post:

Currently 2.88/5
1
2
3
4
5
i

Here is a list of the wikis that refer specifically to Microsoft Access, however, a great many ideas from other areas, such as SQL Server, can be transferred to Access, so don't stop here! You can also post in our forums (Access VBA & Jet SQL, Access Forms & Reports), if you need any help, or would like to help others.

It is important to remember that Access uses the Jet database, for the most part, but both halves of this union, Jet and Access, can be ...

VB6 Remove date part of DateTime

by George Mastros on Apr 01, 2009 in categories Visual Basic 5 & 6, Microsoft Access, VBScript, VBA for Microsoft Office Products

Rate Post:

Currently 3.34/5
1
2
3
4
5
i

Have you ever needed to remove the time part of a date variable, or remove the date part of a date variable? I recently had a requirement to do this, and my first reaction was to use the format function because it is very flexible and quite simple to use. Unfortunately, it does't perform very well.

First, the format method for removing the time part.

Debug.Print Format(Now, "Short Date")
4/1/2009

Debug.Print Format(Now, "Short Time")
09:16

Seems simple enough to remove the date and/or time portion of a date variable, but is it the...

LessThanDot

LTD Social Sitings