like2innovate (2/22/2010)

---

BOL seems to be a pretty intense resource, but you know, as a newbie, I found it to be more like a technical manual than an explanatory textbook. Made...

Hi like2innovate,

As far as books go, I definitely recommend "Microsoft SQL Server 2008 T-SQL Fundamentals" by Itzik Ben-Gan. You'll need to understand how to write - and at the...

Hi sqlserver12345,

Are you sure that you're not losing the first character from the forename (FirstName field) as opposed to the surname (LastName field)? It'd be easy to get mixed up,...

Cheers grovelli! 🙂

I thought I'd worked out how to use the formatting on the board, but I've just copied the code from the message into a module and it ended...

I'm probably not the first person to have had some bad Ikea-experiences, but the benefit of them has been that I've learnt the hard way that I should always read...

Hi keywestfl9,

If you haven't already, then consider having a look at the SSMA (SQL Server Migration Assistant) for SQL Server 2005. I've only had the opportunity to use the...

Hi brandonmooreis,

I'm moving up to SQL Server from MS Access, so posts like yours really help me in realising the potential pitfalls I might have to face.

I can't offer...

Hi GSquared,

The "Select Case When Exists..." query in T-SQL is lovely and it holds a special place in my heart. It's absent from MS Access's SQL, but I...

Hi Frances L,

As metra-905617 rightly says, you need to find the first instance of a space and then take the characters before it to get the forename or initial, but...

I've only just noticed you originally asked:

There's a really important function in VBA called "IsNumeric"; you pass...

Hi All,

Before replying to my above post please read this apology for answering a non-SQL Server related question!

These are my first two posts, and I couldn't find a specific board...

Hi Ritesh,

This really isn't a forum for MS Access VBA questions, and there's lots of more specialised forums that you should use that will be able to help you. ...