#89596 - 2002-11-19 12:07 AM
Re: Access table
|
Howard Bullock
KiX Supporter
Registered: 2000-09-15
Posts: 5809
Loc: Harrisburg, PA USA
|
See the DB* UDFs from Sealeopard. [ 19. November 2002, 00:22: Message edited by: Howard Bullock ]
|
Top
|
|
|
|
#89604 - 2002-11-23 06:01 PM
Re: Access table
|
Kdyer
KiX Supporter
Registered: 2001-01-03
Posts: 6241
Loc: Tigard, OR
|
jose3,
Looking at some old Access code I had lying around.. The INSERT Statment is not the traditional ANSI SQL:
This is in VBA:
code:
DoCmd.RunSQL "INSERT INTO ErrorLog ( TStamp, Loan, ErrorMessage ) SELECT Now()," & Chr(34) & loan_nm ' Split & Chr(34) & "," & Chr(34) & oDTrac.ErrorMsg & Chr(34) & ";"
HTH,
Kent [ 23. November 2002, 18:02: Message edited by: kdyer ]
|
Top
|
|
|
|
Moderator: Shawn, ShaneEP, Ruud van Velsen, Arend_, Jochen, Radimus, Glenn Barnas, Allen, Mart
|
0 registered
and 507 anonymous users online.
|
|
|