Search results

Check this one out' code needs a reference to the dao object library Private Sub UnitKeyAddr_AfterUpdate() ' Find the first record that matches exactly ' the contents of control [UnitKeyAddr] With Me.RecordsetClone .FindFirst "[UnitAddr] = '" & Me![UnitKeyAddr] & "'" If Not...

At Stephen Leban's site you'll get support for animated GIFs. AnimatedGifPlayer HTH nouba

You could try using (make a backup first) a delete query. Put in the where clause your fieldname(s). All records which fullfill the condition (are empty) will be deleted.DELETE * FROM MyTable AS Q WHERE Q.EventDate Is Null hth nouba

try using # as date limiter instead of ('). hth nouba

You could use a query like the followingSELECT DatePart("ww", [EventDate], 2, 2) AS LastWeek , Q.EventDate , Q.Event FROM qselEvent AS Q WHERE (((DatePart("ww", [EventDate], 2, 2)) = DatePart("ww", DateAdd("d", -7, Date()), 2, 2)));it will give you the results for the last calendar week. It is...