Search results

Check out the DateDiff() function.

Storing calculated fields, in all but a small number of special cases is generally considered to be in breach of the rules of Data Normalisation. Generally if you can calculate the value at the time of input you can use the same method to re-calculate that value at any time you need to display...

Use the following as the Control Source of your unbound text box; =YourCombo.Column(x) Where x represents the column that hold the data you wish to display in the text box. The column must form part of the row source of the combo, but need not necessarily be visible. Also remember that the...

Strange; I've just had a play in my sand box DB, with Me.LastUpdated = Now() in the form's On Dirty event, the LastUpdated field gets gets updated as soon as you make a change to any field on the form.

Welcome to the forum What you are trying to do is a variation on the Cascading Combo Box theme. The difference being that you are using a text box rather than a combo to cascade from. The problem I see with this approach is that if your user miss-keys the user name your cascaded combo will be...

Perhaps the tutorial here will help you out.

Sound's as if your option group is unbound. Try binding it to the underlying table.

You should be able to use the DateSerial() function to convert the text to a date and you can then apply the Format (with Dates) function to convert that result to your preferred format. You may also find the discussion here to be of interest.

If you bind that field to the date field in the underlying table, and set the Default Value to Now(), any new records will automagically have the date time stored in that field. Be aware however that the Now() function includes the current time in addition to the current date, which can...

Storing calculated fields, in all but a small number of special cases is generally considered to be in breach of the rules of Data Normalisation. Generally if you can calculate the value at the time of input you can use the same method to re-calculate that value at any time you need to display...

For last viewed could you not simply use the following in the form's On Current event; Me.LastViewed = Now() and for last Modified the following code in the form's On Dirty event; Me.LastUpdated = Now()

If the students are simply flagged they can be filtered out when the user doesn't want/need to see them.

Your code might look something like; Dim LResponse As Integer Dim LResponse2 As Integer LResponse = MsgBox("Would you like to delete this file", vbYesNo, "Continue") If LResponse = vbYes Then LResponse2 = MsgBox("Are you sure? Deletion can not be undone!", vbYesNo, "Confirm") If...

Rather than moving students to a separate file, why not simply flag them as being delinquent?

Good Work :D

If no one chips in before I get home, I'll have a look when I have access to a newer version of Access.

What you are suggesting sounds to be rather de-normalised, so I would tend to avoid it at all costs.

Sorry Can't open your DB right now. Are you by chance using Table Level Lookups? If so this is likely what is causing your problem.

Welcome to the forum. When you are dealing with a sub form you need to get the correct syntax for referencing it. Probably something along the lines of; Forms!Mainform!Subform1.Form!ControlName

One would think so ;)