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