Insert Into Table Field

[Traveler]

Hi,

I have a table named GrandPrix with field named RaceTrack. When a condition
is met I want to insert a text string in RaceTrack field. How can I do that
using DoCmd.runSQL.

 

[Tom van Stiphout]

On Tue, 26 May 2009 21:05:01 -0700, Traveler

I'm not following. Does tblGrandPrix only have a single field?
Also, what kind of condition are you thinking of?

-Tom.
Microsoft Access MVP

 

[John W. Vinson]

Hi,

I have a table named GrandPrix with field named RaceTrack. When a condition
is met I want to insert a text string in RaceTrack field. How can I do that
using DoCmd.runSQL.

With an Update Query (if you mean to update one or more existing records in
the table):

UPDATE GrandPrix SET Racetrack = "Saline Speedway" WHERE <some condition>

Create a new query based on the table and use the Query Type menu option to
select Update.

 

[Traveler]

John,

That looks like it might work. I'll try it when I get home. Thanks a
million.

-T

 

[Traveler]

Awesome dude, took some tweaking but it worked. Thanks much!