Custom OpenForm code – Close and open your form
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:
Code to help you debug SQL code – POPQuery
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 [...]
Maximize the use of TempVars in Access 2007 and 2010
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 [...]
Avoid Trust Center Issues with Developer Tools
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
Inserting a record in SQL Server and retrieving key ID
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( [...]
Tips for designing SQL Server tables for Microsoft Access
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 [...]
Map route on Yahoo Maps with Addresses in Access
Yahoo maps is great at mapping out a route you entered through the browser, but what if you need to map the addresses using a pre-defined route in Access? This tip will show you how to build the URL on the fly and then pass it along to the default browser on your PC. Note: for the same technique usi [...]
Map route on Google Maps with Addresses in Access
Google maps is great at mapping out a route you entered through the browser, but what if you need to map the addresses using a pre-defined route in Access? This tip will show you how to build the URL on the fly and then pass it along to the default browser on your PC. Here's the code: Private Sub cm [...]
Bug will occur when using datasheet view in a sub form.
Here's a bug you will come across when using a subform in datasheet view: "Property Not Found" Here is the code that will trigger the criptic message from Access: Private Sub MyField_BeforeUpdate(Cancel as Integer) if somecondition = True then Msgbox "Your message here, usually you can't save the re [...]
Access function to return day of the week
Sometimes you need the actual day name of the date and not the numeric equivalent, the following function will do that for you: Public Function MyWeekDayName(dteDate As Date) As String 'Will return "Monday", "Tuesday", etc. based on the date supplied MyWeekDayName = WeekdayName(WeekDay(dteDate), Fal [...]
Part 3: Why I grew to love Microsoft Access Data Projects
Note: This is part three of a series of articles on Access Data Projects, Click to see Part 1 Click to see Part 2 Why I learned to love Microsoft Access Data Projects As a seasoned Access programmer, it seams all I do lately is Access with SQL Server, in part because of the great combination of SQL [...]