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

Next Task Due using Access 2007 Form Controls

P: 4
Good morning!

I am working with Access 2007, creating a project tracking system for a group of Project Managers. For user interface, I'm using a series of forms.

One of the forms includes text boxes for tasks due (a label), their due date (a calculated text box) and date the task was completed (a text box formatted for dates).

At the top of the form, I want to have two additional (unbound) text boxes that will tell the user what their next task due is. It is simply to be used as a reminder tool so they know what is coming up next. Ultimately, I would like the text to turn to red if the date has passed, but I'm more concerned right now with just getting the date and the task due to show up in the text boxes.

I've searched the web and my resource books, and have come close but nothing that has given me a complete solution. I have some VBA experience but not a lot. However, if I have the proper code I can usually get it to work.

Can someone assist me with this?
Apr 7 '14 #1
Share this Question
Share on Google+
2 Replies


P: 37
You are asking for quite a lot here. Here are the basic steps you will need.
  1. Find the right record
  2. Get that information someplace useful
  3. Play with that information.
Finding the right record is general done using a query. Assuming you have the person entered you can build a query that has the person, the task name, and the 'due date.'. Your criteria will be the person. You will by due date descending and you will find the first (oldest) record only.
http://office.microsoft.com/en-us/tr...aspx?section=4
Now that you have the query built you will need to get that data someplace you can actually use it. Grabbing directly from a query a specific record can be done with a dlookup command.
http://office.microsoft.com/en-us/ac...001228825.aspx
After you have looked up the value the query is giving you, you can use the data to decide how to adjust your field.

I strongly recommend you break this into smaller pieces and search on bytes for how to do the smaller steps. Almost all the information you could ever want has been done by someone else. Good luck and welcome.
Apr 7 '14 #2

P: 4
Thank you for your reply. I will definitely give this a try. I didn't know if I would need to do a loop in VBA, or if using a query would be sufficient. VBA is a little more difficult for me so if it can work as you described, I'm much happier!
Apr 9 '14 #3

Post your reply

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