Search results

I'm comtemplating the move, because I think it will do the following: Centralise the reports Be easier to produce PDFs Produce HTML for when we want to report directly to the web Perform better Be easier to manage reports individually I could probably do all that with MS-Access but SSRS seems...

This is a useful trick: If you use a + to concatenate strings then it propogates nulls, if you use a & it doesn't... So in the expression: rec![LastName] & (", " + rec![FirstName]) If rec![FirstName] is Null then the expression (", " + rec![FirstName]) will be too, but the rec![LastName] &...

I've known for a while that ADODB uses the TSQL syntax when it comes to wildcards i.e. % to match multiple characters and _ to match a single character. Just found out that it still uses the DAO syntax when it comes to negative character ranges do you need to use the DAO ! rather than the TSQL...

Ok perhaps I have brain fade but here is a problem I've been having this afternoon. New blank database Create a form Create a module Save everything type Me.Name in the immediate window Now I've been using access since V1.0 and I'd expect it to return something like Form1 as the default name...