RSS Forums RSS
Please support our MS Access and FileMaker Pro advertiser: Programming Forums
Views: 3177 | Replies: 0 | Solved | Thread Tools  Display Modes
Reply
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  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.



Similar Threads
Other Threads in the MS Access and FileMaker Pro Forum
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes
Forums | Blogs | Tutorials | Code Snippets | Whitepapers | RSS Feeds | Advertising
All times are GMT -4. The time now is 4:08 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