Drag and Drop In MS Access and Conditional Sorting Drag and Drop In MS Access Doug was on a roll in January of 2004 when he wrote his article on drag and drop in MS Access. He tested it now using Access 2016 and it still works. This article shows you how to add drag-and-drop to your Access applicati [...]
Official Microsoft Access Tech Blog is Now Online! Official Microsoft Access Tech Blog Launches! In addition to the blog on the Office site, the Access team has started a technical blog here. The new Access Tech Blog will be more technical in nature and oriented towards technical users instead of re [...]
Learn How to Spawn Forms in Memory (Yes, You Heard That Right) Hi Everyone! This Tuesday I’m going to demo an amazing concept: How to spawn multiple copies of the same form in memory. Have you ever wanted to display multiple orders or invoices in your databases in separate forms using the same form [...]
MayBeSQL Coming to Microsoft Access! In a stunning development, Microsoft Access will debut a new version of SQL called MayBeSQL, in response to the market clamoring for more NoSQL solutions. Originally, NoSQL meant "No SQL" but in more recent iterations, has come to mean "Not Only SQL". The change [...]
Exclusive! Join us With Our Guest Michal Bar, Access Program Manager Exclusive! Join us on Tuesday March 14th at 6.30pm CST with our guest Michal Bar, Microsoft Access Program Manager at Microsoft! Learn about the future of Access, see demos on new features the Access team has worked on and get answ [...]
Microsoft Access DevCon in Vienna Austria April 1st - 2nd, 2017 This year Access MVP Karl Donaubauer has invited me to speak at his first Access DevCon in Vienna on April 1st and 2nd 2017. Karl has many years of producing similar events in German but this time around it's in English and I'm really e [...]
If you Could Ask the MS Access Team Any Question, What Would it Be? Next month Ben and I are once again traveling to the MVP Summit at Microsoft headquarters for our annual pilgrimage to the mothership. It's a wonderful affair were we get wined and dined and fawned over by Microsoft, and of course m [...]
dBase Support is Back in Microsoft Access! After an overwhelming outcry from the user community, Microsoft has again added support for dBase import into Access! The feature will only be for Office365 users but they plan on rolling it out to everyone eventually. Check out the official announcement he [...]
Find All Queries That Use a Particular Table We just completed a massive 39 database conversion to SQL Server for a client in Tennessee which was quite challenging, we had to not only upsize all the tables, but switch the system from importing/exporting between databases to using linked tables inste [...]
Insert CreatedBy and CreatedOn in Any Missing Data Tables in SQL When we design Access with SQL Server solutions we almost always add CreatedBy and CreatedOn to all of our tables, allowing our clients to see who created records in the Access frontend. Script to add CreatedBy and CreatedOn Automatica [...]
Count All the Objects in Your Database The other day our company was tasked to convert a lot of Access databases to multiple SQL Server backends. To get a sense for the tasks involved, we needed a way to count all the tables, queries, forms and macros in each database. I did a quick Internet search [...]