Recent content by pantera

Jeff, after posting my reply I visited your links. With high probability, I will buy your book Microsoft Access 2010 Inside Out.

Thanks very much, Jeff! :) I agree with you, and will use the BEFORE CHANGE event to make change in the same record. The Lynda video probably has been released with a beta version, like you say. I will write to the author, Alicia Pollock, telling her about the changes you mention in the final...

Thanks Bob! Yesterday night I tried the same thing, using the BEFORE CHANGE event, and it works. I don't know for what reason it is not working with AFTER UPDATE, like occurs in the Lynda video, but that is ok. Do you know a good book about Access 2010 that you could recommend? An intermediate...

Thanks John! :) Formating as double solve the problem.

Bob, the DEPT field is a TEXT data type. There is no lookup. Give a look at the database attached please. This database is the EXAMPLE FILE for the LYNDA.COM video course.

Thanks Bob! Pictures attached. The event is AFTER UPDATE. Still data macro is not working.

I'm following the lessons from LYNDA.COM video course ACCESS 2010 NEW FEATURES. The database is attached, already with the data macro. Open the table EMPLOYESS and in the TABLE tab click in the AFTER UPDATE button to see the code. I tried opening the database in another computer, with another...

This simple data macro is to update SALARY field everytime the DEPT field is filled with the words PURCHASING or MARKETING. (Delete the space in the link to see the image): ht tp://uploaddeimagens.com.br/imagem/ver/datamacro2.gif But it is not working, see the image bellow, where PURCHASING...

Hi, I am with the same doubt, and could not find the Article ID: Q142228 (I am new in the forum). Where is this article?