Search results for query: *

Thanks guys, I ended up using Tony's suggestion. I had tried possibly every combination of things except that. Cheers Matt

Hi guys, I have a query that requires distinct records returned. These records need to be ordered by how close their postcode is to a fixed value, hence: SELECT DISTINCT.....ORDER BY (ABS(3000-g.PostalCode)) (3000 is the fixed value - Aussie postcodes are generally 4 digits) I continue to...

I have Messenger working in my administrators profile, but in all other profiles, clicking on the shortcut or the app file produce no results. I gave another user administrative abilities, but still they cannot get Messenger up and running. I'm guessing it has something to do with group...

Thanks cwillsh I'll give it a try.

I am creating a web site in Australia for Australians, and require users to add their date of birth. Australian standard date format is d/m/y compared to US m/d/y. My site is hosted in the US, therefore the servers default settings are US and the access db looks at the regional setting for the...

Thanks Terry. The command line option actually turned out to be /user Administrator, but your help got me on the right track. Do you understand why Office XP (2002) default shortcuts have no information in their properties dialogues? It had be baffled. Thanks again. Matt

I have only just started using Access 2002. While investigating the User and Group Account information, I have inadvertantly removed the "Admin" default user from the Admins group. I have created a new user "Administrator" in the Admins group, but cannot figure out where to...