question

benuva avatar image
benuva asked

Hi, I am using SQL Server. I am getting the following error code in MS Access. How should I edit my code? I would appreciate your help. Runtime Error 3622

For x = 1 To LstCikisYapilanlar.ListCount - 1

t = t & "," & LstCikisYapilanlar.Column(0, x)

Next x

t = Mid(t, 2)

xSQL = "INSERT INTO [Log] ([BelgeId],[KullaniciId], [HareketId],[DepoId],[AracId]) " & _

"SELECT [BelgeId],'" & Me.KullaniciID & "', '" & Me.HareketId & "', '" & Me.DepoId & "', '" & Me.AracId & "' " & _

"FROM [belge] where ([Belge].[BelgeID]) In (" & t & ")"


CurrentDb.Execute xSQL

xSQL = "UPDATE Belge SET Durum = 2, HedefDepo = '" & Me.CboDepoId & "' where [BelgeID] In (" & t & ")"

CurrentDb.Execute xSQL

Me.LstCikisYapilanlar.Requery

Me.LstCikis.Requery

Me.CikisYap.Enabled = False



hata.jpgdebug-hali.jpgImage Caption


microsoft-accesserror message
hata.jpg (22.2 KiB)
debug-hali.jpg (73.1 KiB)
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.