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

Types of SQL join

Types of join in a SQL query

Using cursors in FoxPro

Using a FoxPro cursor in a combo box

Using a cursor to fill a combo box or list box in FoxPro

September 2010

Microsoft's LightSwitch is supposed to take us back to the days when business users could quickly put together a simple database to meet their immediate needs. I'm just taking a look at their beta version.

FoxPro and Access database support from Alvechurch Data

Access and FoxPro development from Alvechurch Data

Date formats used by Access SQL

Scope of a FoxPro command

Full outer join in Access

Types of SQL join

FoxPro cursors

Using a FoxPro cursor in a combo box

September 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