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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
If your database contains an email field, you can easily modify your form so that users can single click to create an email in their default email program. First, modify the control's Display as Hyperlink property to Always, second, modify the control's on click event with the following code: If [...]
Note: This is part two of a series of articles on Access Data Projects, Click to see Part 1 Click to see Part 3 Access ADPs can provide you with the flexibility and power only a direct connection to SQL Server can provide, but a major drawback to a developer is the login box that will always show u [...]
Note: This is part one of a series of articles on Access ADP projects. Click to see Part 2 Click to see Part 3 Where and Filter Clause do not work when using DoCmd.OpenForm Statement One of the issues you will find when working with an Access Data Project, (ADP), is the lack of functionality in the [...]
Office 2007 will allow you to easily create PDFs from any Word Document using the output menu on the Office button, (Access does too with Reports), but recently I had to create a procedure for a client that wanted to convert Word docs to PDF, email them and do it all from Access. Note: To make this [...]
If you're using a SQL Server database with an Access frontend, then this article is for you. Leveraging the power of Stored Procedures from Access has numerous benefits: your server can perform transactions that would take far longer in Access. Recently I came across the following issue when working [...]
SQL Server views are one of the best tools a Microsoft Access programmer can use to limit exposure to data and improve Access performance. Unfortunately, you can't modify data in a view unless it has an unique index, read on if that is the case for you. (You can create indexed views in SQL Server, t [...]