fields not updating after edit from sub form

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.

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/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources