User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 403,097 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,168 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS Access and FileMaker Pro advertiser: Programming Forums
Views: 2930 | Replies: 0 | Solved
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.

DaniWeb MS Access and FileMaker Pro Marketplace
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes

Similar Threads
Other Threads in the MS Access and FileMaker Pro Forum

All times are GMT -4. The time now is 1:52 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC