Docmd.RunSQL

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

To update some records I am calling following querry, which is working OK :

UPDATE Microwave
SET Far_RAUType = Forms!frmEditMicrowave!Near_RAUType
WHERE Microwave!Far_SiteID=Forms!frmEditMicrowave!Near_SiteID
AND Microwave!Near_SiteID=Forms!frmEditMicrowave!Far_SiteID;

I have tried to to use RunSQL instead of it under On_Event :

DoCmd.RunSQL "UPDATE Microwave " & _
"SET Far_RAUType = Forms!frmEditMicrowave!Near_RAUType" & _
"WHERE Microwave.Far_SiteID=Forms!frmEditMicrowave!Near_SiteID
AND Microwave.Near_SiteID=Forms!frmEditMicrowave!Far_SiteID;"

but it does not work.

Does anyone have some solution?
 
Try this instead

DoCmd.RunSQL "UPDATE Microwave " & _
"SET Far_RAUType = " & Forms!frmEditMicrowave!Near_RAUType & _
"WHERE Microwave.Far_SiteID= " & Forms!frmEditMicrowave!Near_SiteID & _
"AND Microwave.Near_SiteID= " & Forms!frmEditMicrowave!Far_SiteID & ";"

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


To update some records I am calling following querry, which is working OK :

UPDATE Microwave
SET Far_RAUType = Forms!frmEditMicrowave!Near_RAUType
WHERE Microwave!Far_SiteID=Forms!frmEditMicrowave!Near_SiteID
AND Microwave!Near_SiteID=Forms!frmEditMicrowave!Far_SiteID;

I have tried to to use RunSQL instead of it under On_Event :

DoCmd.RunSQL "UPDATE Microwave " & _
"SET Far_RAUType = Forms!frmEditMicrowave!Near_RAUType" & _
"WHERE Microwave.Far_SiteID=Forms!frmEditMicrowave!Near_SiteID
AND Microwave.Near_SiteID=Forms!frmEditMicrowave!Far_SiteID;"

but it does not work.

Does anyone have some solution?
 
Much better, but still might need a couple of spaces...

DoCmd.RunSQL "UPDATE Microwave " & _
"SET Far_RAUType = " & Forms!frmEditMicrowave!Near_RAUType & " " & _
"WHERE Microwave.Far_SiteID= " & Forms!frmEditMicrowave!Near_SiteID & "
" & _
"AND Microwave.Near_SiteID= " & Forms!frmEditMicrowave!Far_SiteID &
";"

Cheers...

Try this instead

DoCmd.RunSQL "UPDATE Microwave " & _
"SET Far_RAUType = " & Forms!frmEditMicrowave!Near_RAUType & _
"WHERE Microwave.Far_SiteID= " & Forms!frmEditMicrowave!Near_SiteID & _
"AND Microwave.Near_SiteID= " & Forms!frmEditMicrowave!Far_SiteID &
";"

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


To update some records I am calling following querry, which is working OK
:

UPDATE Microwave
SET Far_RAUType = Forms!frmEditMicrowave!Near_RAUType
WHERE Microwave!Far_SiteID=Forms!frmEditMicrowave!Near_SiteID
AND Microwave!Near_SiteID=Forms!frmEditMicrowave!Far_SiteID;

I have tried to to use RunSQL instead of it under On_Event :

DoCmd.RunSQL "UPDATE Microwave " & _
"SET Far_RAUType = Forms!frmEditMicrowave!Near_RAUType" & _
"WHERE Microwave.Far_SiteID=Forms!frmEditMicrowave!Near_SiteID
AND Microwave.Near_SiteID=Forms!frmEditMicrowave!Far_SiteID;"

but it does not work.

Does anyone have some solution?
 
Thanks a lot

It works OK.

Previous example works well when updateing existing record, but how to
create new record with the same line of code?
I would like that when there are no records which satisfies the rule, to
create them.

So if there is no record :

"WHERE Microwave.Far_SiteID= " & Forms!frmEditMicrowave!Near_SiteID & "
" & _
"AND Microwave.Near_SiteID= " & Forms!frmEditMicrowave!Far_SiteID
&
";"

to create one.

Thanks

Chris
 
The syntax for an insert query is:

INSERT INTO TableName (Field1, Field2, Field3...)
Values (Value1, Value2, Value3...);
 
Back
Top