Date formats used by Access SQL

Regardless of the regional settings of your PC, you must provide dates in US format for SQL statements in VBA. Use the following simple function to convert a UK date into a US-format date:

Function SQLDate (ByVal MyDate As Variant) As String
SQLDate = "#" & Format(MyDate,"mm/dd/yyyy") & "#"
End Function

Further information in the Microsoft Knowledge Base: Q149095 ACC

Scope of a FoxPro command

Using While and For to control the scope of a FoxPro command

Full outer join in Access

Creating a full outer join in Access SQL

Calculate - a native FoxPro alternative to SQL

The FoxPro Calculate() function - an alternative to SQL

July 2010

A plea to all lone developers to document their projects. We're trying to maintain an old system but we've been sent hundreds of source files and nobody knows which combination of these files make up the system that's running. References within the code point to directories and drives that no longer exist. It's going to be quicker to start again.

Date formats used by Access SQL

Scope of a FoxPro command

Full outer join in Access

Types of SQL join

Calculate - a native FoxPro alternative to SQL

FoxPro Gotcha

July 2010

Database development and training for Birmingham and the midlands

Specialists in Microsoft Access and Visual Foxpro training and development

Phone us on 0121 445 1300, email sales@alvechurchdata.co.uk , or use our contact page