Power Tip: Automate an update query

Power Tipster Justin Farrell has posted a new Access tip on his blog, showing how to create and execute an update query by using a form and a small amount of Visual Basic for Applications (VBA) code. After following his tip, you'll be able to update a large number of records just by opening a form, typing or selecting a couple of values, and then clicking Update! See Justin's post here.

Justin Farrell is a freelance Access developer and offers more tips at his Access Tips Blog, as well as a great Access 2007 Tutorial.

--Chris Downs

 

Office Blogs Comments

Comments: (3) Collapse

  • Here's a related paper I wrote on  Dealing with Non-Updateable Queries and the Use of Temporary Tables in Microsoft Access. Useful when you get the error message: This Recordset is not updateable.

    www.fmsinc.com/.../index.html

    Hope this helps.

  • Thanks for the comment and the additional info, Luke!

    --Chris

  • Nice post Chris.

    How about having a Rollback/Undo button the changes. It will throw open the possibilities of enhancing the form

    Cheers

    Shasur

Comments

Comments: (loading) Collapse