Minddumps
Registered User.
- Local time
- Today, 01:18
- Joined
- Jul 5, 2011
- Messages
- 73
How to auto find “When’s the next biweekly date?” -Access 2007
Currently, I enter biweekly dates (always on a Tuesday, unless Tuesday is a holiday, then most likely Wednesday) that I’m to send my media releases out in a table. The form then pulls those dates for a combo box. I select the next upcoming date I need to work on, which then loads the sub form. I input data using that auto matches that same date so that when it is mail merged into word it is easily filtered (by the date). DB attached.
It’s starting to get cumbersome as time goes on and there are needless steps. So this leads to my question:
How can I get the combo box (as an unbound text box pulling from a query, I imagine) to auto write the next biweekly date that I will need to send my media release on and thus auto embed that date into my sub form? Any help is greatly appreciated!
Currently, I enter biweekly dates (always on a Tuesday, unless Tuesday is a holiday, then most likely Wednesday) that I’m to send my media releases out in a table. The form then pulls those dates for a combo box. I select the next upcoming date I need to work on, which then loads the sub form. I input data using that auto matches that same date so that when it is mail merged into word it is easily filtered (by the date). DB attached.
It’s starting to get cumbersome as time goes on and there are needless steps. So this leads to my question:
How can I get the combo box (as an unbound text box pulling from a query, I imagine) to auto write the next biweekly date that I will need to send my media release on and thus auto embed that date into my sub form? Any help is greatly appreciated!
Attachments
Last edited: