Can anyone help

[plans01275]

Hi im trying to create a macro to change data in a table field can anyone help me please

 

[Mike375]

Use the SetValue macro action. You enter the field reference in Item and enter what is required in Expression. The Expression can be another field or textbox reference on the forum, calculation or a text entry.

A form needs to be made based on the table, if not already done.

When you have completed your macro it can also be saved as a Module and that will let you how it is done in VBA (code)

 

[plans01275]

hi Mike but i dont have SetValue in the macro commands im using access 2007

 

[Mike375]

I have not used A2007 but SetValue will be there but perhaps under a different name.

SetValue and its counterpart in VBA would be one of the most common actions used in Access. Try a Google search on Access 2007 macro SetValue.

Alternatively, repost your question in either the Forms, VBA or General section of this site as most members are not active in the Macro forum of the site.

Give the thread a more meaningful title than Can anyone help

 

[Mike375]

I just did the Google search under the parameters I suggested and this was the first.

http://msdn.microsoft.com/en-us/library/bb177384.aspx

Appears to be A2007

 

[plans01275]

Hi mike i dont have setvalue in the action list

 

[Ron_dK]

You might try Setproperty in lieu of setvalue.

 

[plans01275]

Thanks for the help but i cant make the macro to as i dont know how to program macros

 

[Mike375]

Thanks for the help but i cant make the macro to as i dont know how to program macros

Search on Google for Macro Access. One you make a few then you can save them as modules to see how the same action looks in code VBA

You can do lots of things with VBA that can't be done with macros but a powerful DB can be made using only macros. Possibly the main shortfall of macros as compared to VBA is you can't use macros to make Access communicate with Word.

But a DB that does not use macros or VBA will be extremely limited.

 

[plans01275]

thanks for your help but i have never used macros or VBA before so i dont know what i am doing sorry to be a pain, all i want to do is change all records in a field from a table . i can get the macro to open the table and select the field but can't get the macro find the word yes and replace with the word no.