grahamhill
02-13-2002, 06:23 AM
is it possible to have a command button visible on a form only on a certain day (it's a 'backup' button, i want it to appear on fridays only)
|
View Full Version : make command button visible on day grahamhill 02-13-2002, 06:23 AM is it possible to have a command button visible on a form only on a certain day (it's a 'backup' button, i want it to appear on fridays only) David R 02-13-2002, 07:12 AM I believe you set this in OnCurrent. If(DatePart("w",Date()) = vbFriday) Then Me.button_Backup.Visible HTH, David R EssexColin 02-13-2002, 07:16 AM If you look up "day-of_week" formats in the access help, you can use the date format to decide what day it is, assign this to a variable say x. You can then add code to say if x = "Friday" then me.backupButton.visible = True end if Hope this helps Col |