June 2009 - Posts
A question came in today from Michael about terminal services scale: I have been using the Access 2003 runtime in conjunction with the sagekey scripts for a couple of years. My deployments have had pretty light concurrent user counts, 10-20 is typical.
Read More...
Today’s guest blogger is Michael Groh, co-author of the popular Access 2007 Bible . The VBA language is not, by default, case-sensitive. A statement such as CBool("XYZ" = "xyz") will always return True. You might come across
Read More...
Today’s guest writer is Garry Robinson, Access MVP and proud new owner of past Smart Access journals. I asked him to tell the community about the new home for Smart Access. Hello Clint and Microsoft Access lovers, I am happy to announce that my company
Read More...
The folks @ UtterAccess have produced an useful article titled The Beginner’s guide to ODBC . This is an attempt to equip the developers who want to use Access as a front-end client to any RDBMS (Relational DataBase Management System) backend (ie, SQL
Read More...
About a month ago, we posted a Power Tip from Edwin Blancovitch about creating shortcut menus by using VBA . However, if for some reason you’re not interested in cracking open the Visual Basic Editor, there is a way to create shortcut menus (the menus
Read More...
Once of the most interesting trends in the web application space has been a refocus on user experience improvements. Often times Access gets a bad reputation for not keeping up with the times from a look and feel perspective. Our good friend Brandon from
Read More...
Recently Maarten a blog reader asks: TempVars (introduced with Access 2007) are great! But I have some problems in using them. I created a query with a TempVar as criteria. When I run the query it shows the correct data. But when I open the query in VBA
Read More...
Today’s guest blogger is Vinny Malanga. Vinny is the CTO of IMI Software, Inc. , which specializes in software development for the property management industry. I recently received a call from a client asking for help on how to use the SQL Server bigint
Read More...
Sal Ricciardi of the Access Developer Documentation team has produced a couple of articles for MSDN that address two commonly-asked date-related questions about Access: Using Excel Date Functions in Access 2007 shows how to use Excel’s NETWORKDAYS function
Read More...
Today’s guest writer is Shawn Sullivan from the Office Shared team. I have asked him to talk about the work he has done to help organizations move to newer versions of Office. In March, we made a post about Office Migration Planning Manager (OMPM), which
Read More...
Last week Joel Graff shared his story on how he used Access to track salt usage for the Illinois Department of Transportation. Some of you wanted to know more about the custom class that he uses to ease the creation of similar forms. Joel has agreed to
Read More...
Access Training writer Colin Wilcox has just finished up a series of query courses, available for free on the Access 2007 training courses page on Office Online. Here’s the whole set: Find answers with queries Course What you'll learn Queries I: Get started
Read More...
Today’s guest blogger is Michael Groh, co-author of the popular Access 2007 Bible . I think it's safe to say that anyone who's worked with really large Access databases (like, in excess of 50 or 100 megabytes) has encountered slow compact and repair cycles.
Read More...
