Using MS Access/editing records using vb

Advertisement


Question
Hello,
The following vb code was running good
Dim db As DAO.Database
Dim rstRecord As DAO.Recordset

  Set db = CurrentDb
  Set rstRecord = db.OpenRecordset("Assets")
  rstRecord.MoveFirst
 Do Until rstRecord.EOF
       If rstRecord!Equipment = Forms!Assets!OldEquipment Then
         rstRecord.Edit
         rstRecord!Equipment = Forms!Assets!Equipment
         rstRecord.Update
       End If
rstRecord.MoveNext
Loop

But it do nothing when the table converted to linked sharepoint table.how could i solve this issue? Thanks

Answer
I would put breakpoint in to see if it really does absolutely nothing not even loop through the recordset. Or is the update that is not working?if it loops but the update is not working the record is probably locked. I can't test it on my side unless I had your SharePoint permission and password username.

Using MS Access

All Answers


Answers by Expert:


Ask Experts

Volunteer


Bob Heifler

Expertise

ALL MICROSOFT ACCESS DESIGN AND PROGRAMMING QUESTIONS 
Free Microsoft Access Tutorial Videos are available to you at my web site. Fifteen years of Microsoft Access experience allows me to answer most of your questions. Common question example files available here.

Experience

Microsoft Access programming since 1994. Support for all versions. www.myaccessprogram.com

Publications
My Microsoft Access articles are published at:DailyAccessTips.com

Education/Credentials
UCLA GRAD, Member of Association of Database Developers

Awards and Honors


Past/Present Clients
See some of my past clients here.

©2016 About.com. All rights reserved.