Search results

arnelgp, Thanking you, Should be able to work something from this. Once again. Thanking you

Yes Majp – you have guessed correctly, and I must admit to a beginners’ error, but now we are where we are, some 2 decades later and as you can see from the relationship – I prefer the physical records as we would only have less than 1k records each year (Seniors Group of about 30 participants)...

arnelgp. Thanking You. Its a simple continous Form type as per attached

Isaac Thanking you. Simple Texrbox as per attached with Holes 16, 17 & 18 hidden.

Eljefegeneo, Thanking you, but I live in Ireland

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...

mjdemaris thank you for your response. I am trying to develop a Form for the entry of members to a club. The Form is required to search for the member whereby I use a QBR query which when a wildcard is used will show a number of possible member. Then I select the ID of the required member and...

Thanks Ranman256, Firstly, I don't understand your "other records", I was proposing to stack the cmdNextRecord on cmdPrintReport, but I must now interpret that what I had originally planned is not that easy? Thanking you Rayhogan

Thanks Ranman256. The Form is a little populated and its mostly for looks. You are correct if I choose to select cmdCloseForm, but would like to have if I choose cmdNextRecord. Thanking you Rayhogan

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...

OK - I have decided to allocate default date (#01/01/1900#) to all blank fields and IIF function seems to work. Thanking all for assistance Rayhogan

Thanks Jdraw. (1) MemDOB in tblMember is datatype Date/Time. (2) ran your code and get: testAgeAWF 15-03-1963 age is 52 Once again, thanking you Rayhogan

Jdraw I now attach some data and I have added MemDOB field from table tblMember MemFirstName MemSurname Age MemDOB Michael Butler 1960 08-05-1955 John Cox No Record Paddy Murray 1968 04-09-1947 Danny O'Connell 1952...

Thanks Jdraw. A few point; (1) I have tried Date() and it returns the same result as Now(). (2) I would be reluctant to convert all date formats to mm/dd/yy at this side of the pond. Could it be that I have some setting incorrect as it appears that my results vary in value i.e. different dates...

Thanks Minty. No this returns a Year value - for example 8/5/1955 is returned as 1960. The No Records is working OK and I should note that I am using Irish Date format Thanking you Rayhogan

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...