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

Flag future date for form completion

P: 184
Hi all

Right, I dont know if this is possible in Access (2007) or not but here goes.

I want to create a form for a vehicle delivery where a user completes say half of it before delivery of the vehicle, set a future delivery date and then save it.

When this future date is then due, I would like Access to flag up to the user that this specific form requires completion to enter the rest of the delivery details.

Hopes this makes sense and if possible.

Thanks in advance
May 10 '07 #1
Share this Question
Share on Google+
2 Replies

Expert 2.5K+
P: 3,532
I can think of two possible approaches, depending on the number of records involved. DueDate is the Delivery Date and FieldToBeCompleted is any field that would only be filled in after the DueDate has arrived. If the number of records are limited enough that the user can navigate thru them all searching for the "due" records, then this code in the FormCurrent event would do it:
Expand|Select|Wrap|Line Numbers
  1. Private Sub Form_Current()
  2.   If (Me.DueDate <= Date) And IsNull(Me.FieldToBeCompleted)  Then
  3.     MsgBox ("This record needs to be completed!")
  4.   End If
  5. End Sub
If there are too many records for this method to be feasible, then you'd need to have a separate form that could be opened daily for completing these records.

1) Copy your current form, placing a label in the header and/or changing the background color to distinguish it from the original form so the user won't be confused as to which form they're on.

2) Copy the query the original form was based on and in the Criteria field in the Query Grid for the "DueDate" field place <= Date.

3) Set the Criteria for one of the fields that still needs to be completed to IsNull

4) Go into Form Design View of the new form and change its RecordSource to the new query

5) When this new form is opened only records whose "DueDate" is on or before the current date and whose still to be completed field is Null should show up. The "before" part is necessary in case your user should be sick or have a day off and get behind, so to speak.

Good Luck!
May 12 '07 #2

P: 184
Howzit missinglinq

Thank you very much for your reply. I will go through it in detail and see if this will work for me and then get back to you if I have any probs.

Thanks a lot
May 15 '07 #3

Post your reply

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