Greetings All!
We have a simple Access Table filled with data from an Access Form. Two of the fields are "Start Time" and "Stop Time". These fields are formatted Date/Time.
We want to link these fields to the computer's clock so they will update automatically until we "freeze" them.
Access...
Intention---This little macro is supposed to run down a column of dates. Where there is a #N/A, it changes the cell to TODAY(). It is supposed to stop when it hits the blank cell at the bottom of the column of dates.
Action---When stepped with F8, the cursor moves directly from "Do Until...
I have three open workbooks. I want to cut and paste different pieces of data from Book1 to Book3. The macro recorder writes
ActiveWindow.ActivateNext
as the code to advance to the next workbook in response to my Ctrl-Tab sequence on the keyboard.
That's fine but it requires that...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.