This is the second part of a three part series on the Access IDE. Part I can be found here and Part III here. 10. Colored Command Buttons Call me a fashionista, but I'd love to have colored command buttons! 9. Collapsible Procedures Would love to have a "+" next to each procedure header to collapse [...]
This is part one of a three part series on the Access IDE. Part II can be found here and Part III here. I work in the Access IDE, (Integrated Development Environment), all day and it helps to know a few tricks or ten on how to take advantage of the environment. 10. Before you can fix your code you n [...]
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.
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 [...]
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 [...]
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 [...]
#AccessHelp can be another tool in your Access support arsenal, ready on to discover another great way to help and receive help with Access.
Some of my clients are experiencing terrible performance in Access when using Windows 7 64 bit.
All the information you need in creating connection strings for Microsoft Access and SQL Server.
Use CrossLoop to support clients remotely.
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 [...]