Use CrossLoop to provide support to your clients, or your Mom
Use CrossLoop to support clients remotely.
Great backup tool for SQL Server Express
SQL Server Express has no automated backup tool, you must do all backups manually or use scripts to automate nightly backups. (You do backup your production databases every night right?). SQL Backup and FTP SQL Backup and FTP is a program I've been using on my Production Server for the past month, a [...]
SQL Server + TSQL Deep Discussion on February 24th
On Thursday February 24th I'll be presenting at CAUG, (CAUG.com) the following topic, if you're in the Chicagoland area please join us or you can tune in via the web: SQL Server Express has been the best thing to ever happen to Access, the two make an unbeatable combination! But to maximize the rela [...]
Gain more space in your reports – Use a new date format
Dates on reports can be a pain, you have to leave enough space for the worst case scenario, usually 12/12/xxxx, if you have a lot of date columns all that space can add up. Instead of using Short Date in the format field of the report's format tab, use mm/dd/yy instead. It will guarantee all months [...]
Easy ADODB Recordsets and Commands in Access
Using ADODB recordsets and command objects in your Access code can be daunting, but you can greatly simplify it by using the code in this article.
Amazon $25 Gift Card!
Amazon $25 Gift Card Hello there, I have a free $25 Amazon gift card for my subscribers! All you have to do is leave a comment below, any comment really but if it's Access related then all the better! I will pick one comment at random for the winner, contest ends January 19th and only one comment [...]
Multi-Session Global Variables
Global variables are a wonderful way to make your code consistent, powerful and easy to use, but the native Access global variable, one declared in a stand alone module has a critical flaw: it will reset if there is a problem in your code, and it does not retain it's value once you close Access. Use [...]
A new focus for my blog: More code and techniques!
I'm switching gears on my b log to less commentary and more code in 2011! (I guess this post is considered commentary so it's going to be the next blog post when I switch gears). It's not to say I won't comment on the state of Access consulting, SQL or other topics, but rather I want to keep you g [...]
SQL Query vs. Access Query – Pros and Cons
The other day I was trying to link two tables using memo fields, (don't ask why), using an Access query, that's when I realized it can't be done in Access. Since the data was hosted in a SQL Database, I tried the same thing in a SQL query using SQL Server Management Studio, (SSMS), and viola, no p [...]
Using IIF examples and tips
IIF can be used in a wide range of situations: when building complex strings or invoking commands.
Great Links to Help you with MS Access and SQL Server
As you may already know, my specialty is Microsoft Access with SQL Server, I LOVE the combination of the two! On 12/2/10 I had the chance to present at Chicago's SQL Server User Group. The topic was MS Access tips, insights and strategies with SQL Server. During the presentation I made mention of MS [...]