Search results

  1. R

    Not Make Visible on Form

    Hi all, Have been away from Access for nearly 2 decades and hence need a little help. I have a Form for recording Golf Scores (local Society) and would like add option to enable just to record Holes 1 to 9, Holes 1 to 15 or all 18 Holes. Therefore, I just need for each competition (session) to...
  2. R

    Command Button .Visible

    Hi all, I have a Form on which I have 3 Command Buttons (1) cmdPrintReport (2) cmdNextRecord (3) cmdCloseForm. I have set both cmdNextRecord and cmdCloseForm to Visible = No and have on Exit from cmdPrintReport Private Sub cmdPrintReport_Exit(Cancel As Integer) Me.cmdNextRecord.Visible = True...
  3. R

    Help with IIf Function

    Hi I am new to this forum and would be pleased if you could advise why the following query will not give me the correct result. "SELECT tblMember.MemFirstName, tblMember.MemSurname, IIf(IsNull([tblMember]![MemDOB])," No Record",Year(Now()-[tblMember]![MemDOB])) AS Age FROM tblMember; Thanking...
Top Bottom