VBA code convert to SQL

Wrox Programmer Forums

		Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
VBA code convert to SQL

Access VBA Discuss using VBA for Access programming.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

August 22nd, 2004, 06:14 PM

omnicap1

omnicap1 is offline

Registered User

Join Date: Aug 2004

Posts: 4

Thanks: 0

Thanked 0 Times in 0 Posts

Default

VBA code convert to SQL

Hi Can anybody lend me a hand on converting the following SQL into VBA?

UPDATE asset_master
SET name='new name'
WHERE ID=1

Old

August 23rd, 2004, 01:19 AM

Deepesh_Jain Deepesh_Jain is offline

Deepesh_Jain is offline

Authorized User

Join Date: May 2003

Posts: 62

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Explain me exactly what you want?

Deepesh Jain
VB,VBA & .NET Specialist
Wiley Support Team

Old

August 23rd, 2004, 03:03 AM

Ray Pinnegar Ray Pinnegar is offline

Ray Pinnegar is offline

Authorized User

Join Date: Jul 2003

Posts: 73

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Try:
strSQL = "UPDATE asset_master SET name='new name' WHERE ID=1 "

docmd.RunSQL strSQL

Cheers Ray

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Inserting variable into SQL in VBA Code	tcsodt	Access VBA	1	January 16th, 2008 09:39 AM
Code works in Excel VBA but not Access VBA	fossx	Access VBA	2	May 21st, 2007 08:00 AM
Help with SQL Insert statement in VBA Code	ausmoran	Access VBA	1	December 28th, 2006 06:16 PM
convert vba code to vb	tommy03	VB How-To	3	February 23rd, 2005 02:13 PM
Convert xls for vba	state	VB How-To	1	September 30th, 2004 06:29 AM