Home About us Development Training Support |
Date formats used by Access SQLRegardless 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
AnyDate
As Variant) As String
SQLDate = "#" & Format(AnyDate, "mm/dd/yyyy") & "#" End Function Further information in the Microsoft Knowledge Base: Q149095 ACC |
Hints & tips
The textbox class in Visual FoxPro 9 has a new Autocomplete
property which shows the user the previous values that have
been entered in that textbox.
More...
|