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 [...]
Recently I had to create an Excel spreadsheet export for one of my clients using my Report Generator in Access, it was a thorny project since it wasn't a straight export from a query or table. I had to instead use vba to create the spreadsheet and place the values of each column and row into each ce [...]
One of the major issues with DoCmd.OpenForm is it doesn't close the form before opening it again. This can lead to unexpected behavior of your application, so of course I created my own open form code:
I use SQL in my code a lot, I'm not a fan of creating queries and then referencing them in my code since users may delete or change them. Often I build SQL strings and then I need to debug them in the query Access grid, in the past I would get the value of my SQL string in the immediate window and [...]
The TempVars collection has the ability to save developers time, improve the reliability of your programming and provide you with new ways to share information across your application. TempVars were introduced starting in Access 2007 and represented a major addition to the arsenal of tools for profe [...]
When your're ready to publish your Access 2007 database to your clients network you will most likely encounter those pesky security dialog boxes. They can be easily taken care of by clicking through the trust center and adding trusted locations, but what if you need to deploy to a lot of PCs? Are you going to go to each one and labor throug all those dialog boxes? Read on to discover Microsoft's Access Developer Tools
There are many ways to insert records and retrieve that record key value, this approach will probably be among the quickest since all the processing occurs on the server, not in Access. The technique uses ADODB recordsets to fetch records from SQL Server. CODE: Private Function CreateDatabaseRecord( [...]
We LOVE using SQL Server with Access! I frequently mention that SQL Server Express was the best thing to happen for Access, the two combined have the best 1-2 punch in the industry. I encourage you to explore using both technologies, or better yet, hire us to do the legwork. Here are some table desi [...]