Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 fields not updating after edit from sub form

Author  Topic 

osupratt
Posting Yak Master

238 Posts

Posted - 2014-12-24 : 16:57:51
i have syntax error when trying to update an integer field in a back-end sql table......

Dim dbCMC1 As DAO.Database
Dim strSQL1 As Integer
Set dbCMC1 = CurrentDb
strSQL1 = "UPDATE dbo_SOBatchIDTbl " & _
"SET dbo_SOBatchIDTbl.Latitude = '" & Forms!EditLease.Lat & "' " & _
"WHERE dbo_SOBatchIDTbl.Lease = " & Forms!EditLease.LEASE___WELL & "'"
Debug.Print strSQL1
dbCMC1.Execute strSQL1, dbFailOnError


i get the 'type mismatch' error.

osupratt
Posting Yak Master

238 Posts

Posted - 2014-12-26 : 16:47:32
please disregard this post as I figured out my problem. thanks.
Go to Top of Page

FrankGarza
Starting Member

1 Post

Posted - 2014-12-31 : 07:20:36
Awesome! Thanks for sharing!
Seriously though, this is good sound advice and I would add that it’s also nice when bloggers reply to comments.

_________________________________
http://www.millercollege.edu/
www.test-king.com/onlinecourses/TEAS.htm
http://www.ltu.edu/
http://test-king.com/cert-PRINCE2-Foundation.htm
http://www.fmuniv.edu/
Go to Top of Page
   

- Advertisement -