fbpx

Opening or Linking Text or Excel as Data Sources in Microsoft Access

Opening or Linking Text or Excel as Data Sources in Microsoft Access   Access is a phenomenal tool for working with many data sources. You may have long known that you can easily import or export data in a wide array of formats. However, we had a scenario where we needed to process data from ex [...]

Opening or Linking Text or Excel as Data Sources in Microsoft Access2021-06-11T04:52:20-05:00

RESOLVED: Microsoft Office 365 Version 2009 May Break Your Database Application

Microsoft Office 365 Version 2009 May Break Your Database Application   Microsoft has reported that they've disabled the feature which should then avoid the need to rollback the version. The new feature will be made available in version 2010, planned for end of October 2020. In meanwhile, it wi [...]

RESOLVED: Microsoft Office 365 Version 2009 May Break Your Database Application2021-06-11T04:55:49-05:00

Preview Documents in Microsoft Access Form

Preview Documents in Microsoft Access Form Project Scope We recently added a document center to a project which allows users to attach documents such as pdf, word, txt and images to a project.  In addition they will have an automatic process set up to read incoming emails and save the email attachme [...]

Preview Documents in Microsoft Access Form2021-06-11T04:59:27-05:00

Join Us for an Intro to Access with SQL Server

Join Us for an Intro to Access with SQL Server   On Tuesday September 8th, 2020 at 6:30 PM CST we are back from summer vacation to start the new season! We will start with introduction to Access with SQL Server, you can learn more at https://accessusergroups.org/sql-server-with-access/event/375 [...]

Join Us for an Intro to Access with SQL Server2021-06-11T05:03:15-05:00

How to Consistently Earn a Microsoft Access MVP Award

How to Consistently Earn a Microsoft Access MVP Award   I often get asked, "how does one become an Access MVP?" 9 Years of MVP Awards When I first started nine years ago, we had over 30 MVPs. Now we have less than 20. Each year, I need to compile my accomplishments and submit them for review, [...]

How to Consistently Earn a Microsoft Access MVP Award2021-06-11T05:04:24-05:00

Alternative Solution to DCount and DLookup with MS SQL Server Backend

Alternative Solution to DCount and DLookup with MS SQL Server Backend   One of the major issues we have encountered with Access is the use of DLookup and DCount when using SQL Server tables.  We recently worked on migrating a pure Access solution to SQL server and encountered delays on the load [...]

Alternative Solution to DCount and DLookup with MS SQL Server Backend2021-06-11T05:05:57-05:00

Search Microsoft SQL Server Database for Stored Data

Search Microsoft SQL Server Database for Stored Data   Have you ever had to decipher a database and identify which column has the data you need? I recently had to work with extracting data from a SQL database to use in Microsoft Access and Power Bi, unfortunately the naming structure of the dat [...]

Search Microsoft SQL Server Database for Stored Data2021-06-11T05:14:00-05:00

How to Fix the New Data Type That is Causing Problems to MS Access

How to Fix the New Data Type That is Causing Problems to MS Access   [UPDATE: now with Access team link to fixes] Recently the Access team starting working on a new data type called Date & Time Extended, here’s Ebo Quansah, Access program lead: Very soon, we will ship a new data type, known [...]

How to Fix the New Data Type That is Causing Problems to MS Access2021-06-11T05:15:14-05:00

Free Field Hospital Database to Fight the COVID-19 Pandemic

Free Field Hospital Database to Fight the COVID-19 Pandemic Field Hospital Inventory System During these grave times we see field hospitals going up everywhere: Central Park in New York, churches, gyms, parking lots, and more. The COVID Supplies Database is our way of helping humanity in this time o [...]

Free Field Hospital Database to Fight the COVID-19 Pandemic2021-06-11T05:17:54-05:00

Curious About the Latest Microsoft Access Features?

Curious About the Latest Microsoft Access Features?   If you're on Office365 you have a choice in regards to how often you see new features, (some refer to these as rings): Semi-Annual: You get new features every six months, we recommend this channel to all of our clients Semi-Annual Targeted: [...]

Curious About the Latest Microsoft Access Features?2021-06-11T05:18:54-05:00

Access Experts’ View on the 2020 MVP Summit

Access Experts' View on the 2020 MVP Summit   Last week we had our virtual MVP conference, where I huddled with MVP’s from around the world as we heard and gave feedback to the Access team. Here are some takeaways: I miss sharing with friends I only get to see once a year, but being virtual did [...]

Access Experts’ View on the 2020 MVP Summit2021-06-11T05:20:26-05:00
Go to Top