What is the syntax for inserting a memory variable dimmed as Date into a table.
For example:
Number = " & numvar & "
Text = '" & textvar & "'
Date = ????
My statement is similar to the following:
Dim mvar1 as Integer
Dim mvar2 as String
Dim mvar3 as Date
mvar1 = Me!text1.value (Number of Cycles)
mvar2 = Me!text2.value (Part #)
mvar3 = Me!text3.value (Production Date)
Insert into mytable(fld1, fld2, fld3) values(" & mvar1 & ", '" & mvar2 "', ????
Any help would be appreciated
Here's to alcohol...the cause of ... and solution to ... all of life's problems - - Homer J. Simpson