Hello, I just discovered that you can use Dlookup function on a form. just not sure how to connect this for each button that was clicked which will run the queries associated for each buttons. I would like to be able to show a date and time each of these buttons were ran on the form, that way I dont have to repeat the same button. Normally, I go to the folder to see if the excel file has been updated but I prefer to have that kind of visibility on the Form itself next to the macro buttons. What do I need to type in the logic? Lets say the form has a button that says Accounts Receivables, my understanding is to type =dlooklup"[files last ran]","[Accounts Receivables"] but it does seem to work.
-
-
What do you have already to store these values? I assume you've given the question some thought already. -
I really don't understand your comment.Comment
-
You would like to display on your form information about when particular Command Button controls were triggered and the code behind them run. That information would need to be stored somewhere if it's to be displayed (unless the form remained open for ever and the data were part of the session data in your module). What are your plans for storing this data? You're working in Access so a good bet would be to store the info in a table, but what is the design of the table? Etc? Etc?Comment
Comment