Recent content by sandhurstUK

Cheers Minky, I forgot also to mention in my initial mail that I had installed Macafee at the same time as installing XP. It transpires that you need to update your POP3 mail accounts via the Mcafee software, and once this had been done it worked fine. WHY DON'T THEY TELL YOU THAT UPFRONT ...

Guys I really need your help, as this is doing my nut in !! Just to explain first - this is a stand alone home PC not connected to a network. I took the decision to move from Win98SE to XP, so reformatted my drive and installed XP no problem so far. Set up my email account in Outlook Express...

Cracked It I must remember to use the many examples in the search function where I found this, which works fine: =Format(Date()-[Birthday],"yy") Sorry for the bother

The following control source on a form field is designed to determine the age of a person: =DateDiff("yyyy",[Birthday],Date()) However, a person with say a birthday of 20/07/1944 (UK date format) who is currently 58 years old, returns an age of 59 due to the fact that the calculation of age is...

Cheers Rich Ah Ha - so it's a form based funtion and not the table that's the problem. Cheers Rich - Job jobbed !!

How can I stop a table displaying a blank new record? My problem is as follows: One of my tables contains the details of monthly expenses for team members, from which is driven a query and subsequently a form, which ultimately appears on my Contacts form, as a subform. With me so far? The...

Within the criteria of your query - select properties and then under the General Tab click in the Format field and select Fixed, and then in Decimal Places specify the number of places you require. The same goes for any field in a report - form - or table. Hopefully this is what you were...

Many Thanks Thanks for the response. When I saw the solution I knew what the answer to my question was, which incidentally I should have already known as I had a similar problem some time ago which was resolved using the Format function. Just couldn't remember where to look. Ian :)

I currently have a parameter qry which calls for the operator to enter the current month in order that the required records are returned, and am looking to automate the operation. What I need is for the qry to look at the 'system' month and return all entries between day one of the month and...

Derrrrrr Sorry folks, it was a bit early when I posted that. SELECT [Current NBIs Grouped qry].Surveyor, Min([Current NBIs Grouped qry].[Allocation Date]) AS [MinOfAllocation Date] FROM [Current NBIs Grouped qry] GROUP BY [Current NBIs Grouped qry].Surveyor; This worked fine. :D

Hi, The following code selects a list of surveyors and a list of dates. What would be the next line of code to select just the oldest date per surveyor? SELECT [Current NBIs Grouped qry].Surveyor, [Current NBIs Grouped qry].[Allocation Date] FROM [Current NBIs Grouped qry] GROUP BY [Current...

Hi, With reference to query by form - could anyone please explain how the Tag property works as I cannot make sense of the help file in A97. The following line appears in the tag property of a qbf form I am using, I know the function works, in that the correct data is returned, however I am...

Cheers Harry Job jobbed !! Ian

FAO - Harry, Your code works really well and gives me all the calculated data exactly right, except for when I change the Format in the SQL from "mm/yy" to "mmm/yy" to show the result as Sep/02 rather than 09/02. The results are then displayed in alphabetic order (Aug - Dec - Jul - Sept etc...

Crystal clear Many thanks Ian