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 [...]
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 [...]
Access with SQL Server is a great combo, but you do need to be aware of certain issues and optimize the relationship to make it a rewarding experience for your users. This article will talk about the steps you need to take and how to avoid some pitfalls.
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 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 [...]
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 [...]
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 [...]
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 [...]
IIF can be used in a wide range of situations: when building complex strings or invoking commands.
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 [...]
There are a number of great reasons why I wanted to learn .net: I envy the tools available: Microsoft is committed to providing .net developers with the greatest and sexiest development tools, every year they roll out new ones that make their jobs easier. Us Microsoft Access guys? We're stuck with t [...]