Solved

Change a value in a table using Access 2010 macro.

Posted on 2013-12-06
2
1,731 Views
Last Modified: 2013-12-08
I want to use a macro to open a table, go to a record and then enter data in a field. Below is a picture of my macro up to the point where the record is selected.

Now which action can I use to give a value to a specific field in that record. The fieldname is "Note" and I want to enter "This is the new value." in that field.

Applicable picture
0
Comment
Question by:Fritz Paul
2 Comments
 
LVL 15

Accepted Solution

by:
JimFive earned 500 total points
ID: 39702243
I don't think you can.  Is there a reason you want to use a Macro instead of an update query?
0
 

Author Closing Comment

by:Fritz Paul
ID: 39704267
Thanks, You'r right. I read more about update queries and understand the limitations of macros vs update queries better now.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now