By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,828 Members | 2,241 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,828 IT Pros & Developers. It's quick & easy.

Dlookup function for each query ran

P: 13
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.
Jan 5 '12 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 15k+
P: 31,489
What do you have already to store these values? I assume you've given the question some thought already.
Jan 5 '12 #2

P: 13
I really don't understand your comment.
Jan 5 '12 #3

Expert Mod 15k+
P: 31,489
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?
Jan 6 '12 #4

Post your reply

Sign in to post your reply or Sign up for a free account.