Recent content by kupe

Many thanks, GeoMetry. Would you bundle this into a Iif?

I have a list of email addresses. I want to take the name before "@" and divide it into two if there's a "." or "- " or "_". And to capitalise the first letter of both names. For example, rob-roy@hootsmon.com would be Rob Roy. Hope an expert would show me how. Cheers

Thanks, Simon_MT. Sounds as though that might be the way to go ... or do we just bite the bullet and buy Jeff's book. Perhaps the philosophy, if there is one, for the change is explained in there.

I think you're right, AccessJunkie. But with 2007, things are not where you expect them. I'm trying to find - as a for-instance - in reports, the charts wizard. I spent a good half hour last night looking for it. Things like that are really frustrating. Doesn't it mean, we have to learn a...

Any way of turning the clock back with my new 2007 so I can see the old or what might be termed the 'classic layout' of Access, please?

Brilliant, databasedonr, many thanks. Makes sense and works well. (Amazing how you - I - can forget simple things.) Much obliged.

A field in the table is hyperlinked. I put urls in, but obviously I have to do something else to tag on "http://". Alternatively, be pleased to know the code to concatenate "http://" onto the urls.

A field in the table is hyperlinked. I put urls in, but obviously I have to do something else to tag on "http://". Alternatively, be pleased to know the code to concatenate "http://" onto the urls.

A field in the table is hyperlinked. I put urls in, but obviously I have to do something else to tag on "http://". Alternatively, be pleased to know the code to concatenate "http://" onto the urls.

Cheers, Ethereal

Strings contain urls. Is there a simple way to trim a url out, please? For example, " www.zzuk.co.uk/cardiff/Ely - 17k - Cached - More from this site - Save " What I would like to be left with is simply "www.zzuk.co.uk/cardiff/Ely"

I asked in the VBA forum because - as you know - sql is an important part of VBA. Thanks very much for the direction, and the advice, Peter. Cheers

Cheers, Peter, but not much point to the forum if people don't ask for advice. Not only will every possible question about access et al have been answered on this very forum over the years, but every answer is in lots of books too. We have forums for the interaction - when it is helpful...

People have entered themselves in the db in lc and upper and a mixture of both. Is there a way when displaying the names, please, to say in sql that I want them to be 'normal' - ie Peter Plant, Sue Marris, etc even though they are entered as PETER plant and sue marris?

So I resized on that machine and it seems to work. Cheers, Col