Querying SQL Server DateTime Fields in Access
When querying SQL Server date fields in Access, you may need to use the time specification to get all of the records in your date range.
DSN-less Connections and AD Security
Over the weekend I had the great pleasure to participate in SQL Saturday #73 in Orange County California, my two sessions were well attended and I had a lot of interest from SQL Server professionals on how to maximize performance between Access and SQL. Why I won't post my presentation I received nu [...]
SQL server heaven online web presentation April 11
When: Monday, Apr 11, 2011 6:30 PM (CDT) Where: Hinsdale, IL *~*~*~*~*~*~*~*~*~* CCS West Suburban Access Developers, Tomorrow's presentation by Juan Soto at Mary Sue's will also be webcast via LiveMeeting. This email should contain the details needed to connect to the webcast. Here is the informati [...]
Apply conditional formatting using code
Conditional formatting is a great feature introduced in Access 2000, it allows you to apply different formats to records on a form based on values and formulas you setup. In this example, I'm going to build on an article by Microsoft you can find here. Colors are better for some... My client wanted [...]
Twitter hash tag #AccessHelp
#AccessHelp can be another tool in your Access support arsenal, ready on to discover another great way to help and receive help with Access.
Issues with Access and Windows 7 64bit
Some of my clients are experiencing terrible performance in Access when using Windows 7 64 bit.
SQL Server Connections Strings for SQL Server
All the information you need in creating connection strings for Microsoft Access and SQL Server.
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 [...]