Connie-
I always use the Execute method to run "action" queries in code.
CurrentDb.Execute "INSERT INTO .....", dbFailOnError
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of mrsgoudge
Sent: Tuesday, October 25, 2011 8:11 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] rst.AddNew vs. sql Insert Into statement
John,
In inserting new records do you recommend one way over the other? I don't want
something screwy like this happening again.
thanks!
Connie
------------------------------------
Yahoo! Groups Links
Selasa, 25 Oktober 2011
RE: [MS_AccessPros] rst.AddNew vs. sql Insert Into statement
__._,_.___
MARKETPLACE
.
__,_._,___
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar