RSS Forums RSS
Please support our MS Access and FileMaker Pro advertiser: Programming Forums

Access macros

Join Date: Mar 2004
Posts: 15
Reputation: sgtrock40 is an unknown quantity at this point 
Rep Power: 5
Solved Threads: 0
sgtrock40's Avatar
sgtrock40 sgtrock40 is offline Offline
Newbie Poster

Access macros

  #1  
Sep 12th, 2005
Okay, another easy one, but I can't remember how to do it. I have a table that I want to be able to update multiple records in. I thought I could just run an update query, but I have 2 yes/no fields and one text field that I want to be able to choose from for updates. Example: I have 745 different tools in one toolkit. If that tool deploys to Iraq or Afghanistan I would check the appropriate yes/no. If it deploys to another location, I would have to write that location in the text box. Instead of checking or writing this 745 x's, I want to select a specific box # (from 15 choices) and then just check one box, or enter into one field and update all of the records in that kit. My guess was a macro, but I can't remember how I would do that. Any advice?
As Americans - We Wept
As Americans - We Mourned
As Americans We Stand United and Strong
AddThis Social Bookmark Button
Reply With Quote  
Forums | Blogs | Tutorials | Code Snippets | Whitepapers | RSS Feeds | Advertising
All times are GMT -4. The time now is 4:03 am.
Newsletter Archive - Sitemap - Privacy Statement - Acceptable Use Policy - Contact Us
Forum system based on vBulletin Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC