Please support our MS Access and FileMaker Pro advertiser: Programming Forums
Views: 1935 | Replies: 1
 |
•
•
Join Date: Feb 2008
Posts: 1
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Can Access update the currnet record or multiple records using a macro? Okay, this is the situation. We are trying to set up a database where we input individuals for their personnel evaluations. We created a button in the form window and linked it to a macro that updates the "Date Due" block based on the date in the "Date Completed" block plus 18 months. So far this button seems to calculate the correct date and places the new date in the form window when pressed BUT it ONLY updates the FIRST record in the database.
HOW THE HECK DO YOU GET IT TO UPDATE THE RECORD YOU ARE CURRENTLY EDITING IN THE FORM WINDOW?!?! We would at least like to get the macro to update ALL records but Access has a restriction on how many times you can loop a single macro!!! The macro actually worked on the first 20 records in alphabetical order (we're not using a primary key for each record) but nothing beyond that because Access won't loop a macro more than 20 times.
PLEASE tell me there's a simple solution for this. Oh, and before you say "Visual Basic works much better and works a lot faster" let me tell you, none of us know how to use Visual Basic so we're stuck with these crappy macros provided by Access.
Any Help?
HOW THE HECK DO YOU GET IT TO UPDATE THE RECORD YOU ARE CURRENTLY EDITING IN THE FORM WINDOW?!?! We would at least like to get the macro to update ALL records but Access has a restriction on how many times you can loop a single macro!!! The macro actually worked on the first 20 records in alphabetical order (we're not using a primary key for each record) but nothing beyond that because Access won't loop a macro more than 20 times.
PLEASE tell me there's a simple solution for this. Oh, and before you say "Visual Basic works much better and works a lot faster" let me tell you, none of us know how to use Visual Basic so we're stuck with these crappy macros provided by Access.
Any Help?
Last edited by JGinside : Feb 1st, 2008 at 11:01 am. Reason: Spelling error in thrid paragraph
•
•
Join Date: Apr 2005
Location: Dundee, Scotland
Posts: 13,409
Reputation:
Rep Power: 33
Solved Threads: 330
yes in that you can get it to run an query
you can use SQL (query language) to do things like update records
this small sample adds $1 to all prices in the products table where the price is greater than $1 to begin with
for dates you need to use # around the date
you can use SQL (query language) to do things like update records
UPDATE products SET price = price+ 1.00 WHERE price < 1
this small sample adds $1 to all prices in the products table where the price is greater than $1 to begin with
for dates you need to use # around the date
Last edited by jbennet : Feb 1st, 2008 at 5:44 pm.
TRY MY SUGGESTIONS AT YOUR OWN RISK
Master of puppets Im pulling your strings, blinded by me, you cant see a thing. Master! Master!
Master of puppets Im pulling your strings, blinded by me, you cant see a thing. Master! Master!
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
