Michal Bar in Access
, 03-14-2018
This is a place to share ideas, news, discuss the product, promote Access events and engage with Access MVPs. In this community you'll also find the Access product blog, where we share updates from the Access team, customer success stories and MVPs articl ...
Read More
yes I canas soon I upgrade myself in this new network
Could you add the LinkeIn.com Professional Microsoft Access Developers Network group to your list here?
- Mark Burns
Michal: great to see access has a place again in the blogs.. I was a participant on 2 access dev kitchen and definetly want to be a part of the next developer event like t...
Read More
| |
Is there an Exchange Connector for Access or is there a way to use the Exchange Connectors from PowerBI and Excel in Access? Thanks in advance... -Todd
Todd, Microsoft Access provides several methods of importing from, exporting to, inspecting / automating via VBA, and creating Linked Tables to Outlook / Microsoft Exchang...
Read More
| |
Microsoft Office 2019 is out! Microsoft started the roll-out today of Microsoft Office 2019 for Windows & Mac – with major updates to Access, Excel, Word, PowerPoint, Outlook, Project, Visio, and Publisher – to commercial volume license customers. Microso ...
Read More
| |
Dear VBA/Access Guy when you leave outside of usa formatting date can be different . In USA the date are formatting like "mm/dd/yyyy". here in belgium, but for what I know same in France, Netherland or Spain (country where I used to work) we are on "dd/mm ...
Read More
Hi Anthony, Microsoft Access actually automatically displays dates in the dd/mm/yyyy format outside of U.S. However this is based on the region you have selected or overrid...
Read More
| |
Michal Bar in Access
, 09-21-2018
This is a unique opportunity to all Access developers in the Netherlands to network with and learn from local Access developers.
Please join me on October 10th 2018, in Amsterdam, for a full Access day.
Event details and registration
Event is hosted and ...
Read More
| |
Michal Bar in Access
, 03-14-2018
This is a place to share ideas, news, discuss the product, promote Access events and engage with Access MVPs. In this community you'll also find the Access product blog, where we share updates from the Access team, customer success stories and MVPs articl ...
Read More
yes I canas soon I upgrade myself in this new network
Could you add the LinkeIn.com Professional Microsoft Access Developers Network group to your list here?
- Mark Burns
Michal: great to see access has a place again in the blogs.. I was a participant on 2 access dev kitchen and definetly want to be a part of the next developer event like t...
Read More
| |
I have created form with several combo boxes. table is updated and getting all records. When I created query without any parameters i got all records. But when I am adding parameter like [Enter Company Name]. I am getting all fields blank Thanks
Read More
Usually if you give a parameter a query you also need to inform the database what you want done with that parameter eg re-query the data selecting only the submitted filt ...
Read More
Using parameters like this in a query is not a good practice. A better approach is to provide a form where the user can select the company name from a list (List box or C ...
Read More
We'd have to have more details. First, where are you trying to add this parameter? How? The best way to explain it is to show us the actual SQL from the query.
Read More
Hi Guys, Please somebody help me to solve this issue thanks
| |
How to convert 32 Database created with Access 2007 32 bit to Access 2016 64 bit? Manoj Kumar
How to convert 32 Database created with 32 bit to Access 64 bit?
First, let me make clear what I'm saying. Usually an ACCDE is created to protect the design of forms, reports, and VBA codein a database application. The ACCDE may o ...
Read More
| |
The windows API call AllocConsole no longer seems to work in VBA Access 2016 on Windows 10. It functions correctly on Windows 7 with Access 2016 and I've been googling for the past few days tring to find an answer. The code is a follows... Private Declare ...
Read More
This may be a long shot, but have you verified that this API is actually available on the Windows 10 computer?
I have a similar problem in my C# windows app where I allocate a console window. The console window shows, but the output stream and tracing no longer works on windows 10 ...
Read More
| |
|
| |
For those with an Access application that ties into a SQL Server backend, you might be interested in reading about considerations for designing a trigger. A follow up blog post on specific consideration for Access bound form will follow shortly. Designing a T-SQL Trigger
Read More
Thanks, Ben! Excellent tips regarding use of Set (vs. Row)-based Triggers attached to a View in SQL Server. I look forward to your follow-up article about using this with ...
Read More
| |
Luke Chung in Access
, 03-07-2018
Microsoft Access debuted in 1992 and recently celebrated its 25th Anniversary! Over the decades, Microsoft Access evolved with a large number of enhancements, database formats, and discontinued features.
It's hard to remember all the changes. We crea ...
Read More
Only one small error in this matrix... Access 1.0/1.1 were distributed as freebies in Office Suite boxes. I remember installing and using Access in 1993. I worked for an ...
Read More
| |
The most famous database of the world is the latest addition to Microsoft's Access Templates page. In Access forums a great many people have asked for an official download of the Northwind database as it wasn't available on their (often non-English) sy ...
Read More
| |
 techcommunity.microsoft.com My blog post about Access user groups and events had almost 1000 visits in the first week. That's fine but I would be interested in some discussion and information from YOU:
Are there Access user groups or events in your ...
Read More
There is a regular Access „Stammtisch“ in my area. - Big shout out to Martin Asal for relentlessly organizing it for 17 years now! However, I rarely attend in recent years ...
Read More
| |
Juan Soto in Access
, 04-27-2018
Today Microsoft announced all of the new features in the Windows 10 April update and one really caught my eye: Timeline. It pretty much allows you to backtrack and fine that latest email or file you were working on. In the past I’d just open the program i ...
Read More
Thanks for the heads up, Juan! I was wondering what the new Timeline feature was being advertised during update.
I've never used Task View much myself, but may be worth it ...
Read More
| |
The following has evaluated to null or missing:
==> reply.solution_data.accepter [in template "custom-message-list-view" at line 128, column 96]
----
Tip: It's the step after the last dot that caused this error, not those before it.
----
Tip: If the failing expression is known to be legally refer to something that's sometimes null or missing, either specify a default value like myOptionalVar!myDefault, or use <#if myOptionalVar??>when-present<#else>when-missing. (These only cover the last step of the expression; to cover the whole expression, use parenthesis: (myOptionalVar.foo)!myDefault, (myOptionalVar.foo)??
----
----
FTL stack trace ("~" means nesting-related):
- Failed at: #assign confirmedBy = reply.solution_... [in template "custom-message-list-view" at line 128, column 73]
----
| |
I have more than 10 Backend ACCDB's connecting to a single Front-end ACCDB. If you look at the above screenshot, it becomes very difficult to identify which tables are linked to which database. I would like to request the Access team to Group all tables t ...
Read More
| |
Hi, I am using the 'Services' template in office 365 to create my own database used for tracking quotes, invoices and clients.
The template already has the ability to create quotes and invoices and mark their status as paid, approved, expired, etc. Howeve ...
Read More
Hi, while it's possible someone will have enough spare time to do that, you're more likely to get support from an official contractual arrangement with a professional dev...
Read More
| |
Update on the devcon content: The Microsoft Access Team goes Hollywood and we will have the latest news in Vienna! They are going to provide us with an exclusive video sh ...
Read More
Can't wait to see everyone in Vienna!
| |
Juan Soto in Access
, 04-08-2018
As promised, the new SQL Server Native Client 18 is now available to download. Either Ben Clothier or I will be testing Azure authentication and other aspects of ADODB and be providing feedback soon! In the meantime, check out the announcement and other d ...
Read More
I'm glad to see a major update to the data access driver for SQL Server and Azure SQL for Microsoft Access (as well as .NET and elsewhere). This provides much-needed supp ...
Read More
| |
Juan Soto in Access
, 03-26-2018
Great news everyone! Via Klaus Oberdalhoff today I learned that version 7.7 now includes TWO versions to download, the 64 bit and 32 bit!
This is a major improvement, before it only included the 64 bit version, requiring additional steps to migrate your ...
Read More
Thanks for the heads up, Juan, and good news!
Bringing back 32-bit support for the SQL Server Migration Assistant will be definitely make it more practical to use in ma ...
Read More
Juan,
While this is great news, it is still not necessarily easy to know which version to choose. I have a 64-bit computer, but a Click to Run (Office 365) version of ...
Read More
| |
Access & Office Development Roadmap & Suggestions
In addition to summing up recent Access updates & resources (including those from Access), I've compiled some suggestions & questions for the Access & Office Dev Platform teams (ranging from PowerApps & Co ...
Read More
It was recently reported that Microsoft was reorganizing into just two major "uber-groups". I wonder what the implications may be for Access, Office 365/2019 and Office ...
Read More
| |
Armen Stein in Access
, 03-15-2018
At Access Day last week, Michal Bar from the Access Team offered the world's first glimpse of the new modern chart controls coming to Access! Check it out at the 7:00 minute mark.
Read More
Thanks Armen for organizing Access Day and sharing Michal's presentation. Exciting stuff!
At 27:55 in the video Michal says, "Access is added to the site
templates.office.com" but that's no true; the list includes Word, Excel
and PowerPoint
New Chart Controls! I see even less incentive to try Power BI out.
Great - but couldn't you publish it somewhere else? I'm not on Facebook and will not be.
| |
Juan Soto in Access
, 03-14-2018
A year ago Microsoft announced that Access Service in SharePoint will be discontinued. We hope you've had a chance to migrate your app, but if you haven't here are some of the platforms you can recreate your application into:
- PowerApps - Web App
- Microsof
...
Read More
I have written a series of blog posts on rescuing your data from its Soon-To-Be-Late AWA. If you haven't yet figured out how you're going to do that with your data, right ...
Read More
Best Response confirmed by Juan Soto (Occasional Contributor)
| |
|
| |
I am wondering if my access app will still function correctly after I export all the tables to sharepoint lists, while I'm developing flows before the list's are used as the live data.
Hi Michael
If the web app is hosted by Microsoft it may no longer work by April 1st, 2018, in which case you will need to migrate the code to either a Access solution o ...
Read More
Has anyone attempted using the migration tool ? Does the original app still work correctly ?
| |
Armen Stein in Access
, 03-14-2018
Are you attending one of the biggest and best Access conferences in the world? It's only 6 weeks away!
3 Days, 2 Nights.
14 Topics.
A beautiful natural setting near Salem, Oregon.
Evening social times.
Lodging and meals included.
Register now before it sells ou ...
Read More
Nice idea, but your holding it in the wrong place. Need to do it in the
tech center of the east coast - Raleigh/Durham/Chapel Hill (Reasearch
Triangle) of North Carolina!...
Read More
The PAUG is always a highlight of my year. Looking forward to a
recharge.
| |
So does any of the participants in the Microsoft Valuable Professional Summit at Microsoft Headquarters have anything to say about Access going forward?
Hi Giorgio,
most content of the MVP Summit is under NDA (Non Disclosure Agreement). That's nothing special, just industry standard. So MVPs can't discuss new plans, featu ...
Read More
| |
Rod Gordon in Access
, 03-15-2018
We are pleased to announce that the next Access User Group Conference will be held on Wednesday 18th April 2018.
To book a place simply email margaret@gordonassociates.co.uk
VENUE:
Hopefully our most mutually convenient location yet!
Pendley Manor Ho ...
Read More
Can't wait to see you all there!
Cheers,
Armen
| |
Today for the first time when I open anything from my main menu I cannot scroll down the page / screen. I can page up and page down, I can use the arrows, but if I try to scroll or use the side bar the screen dosesnt follow If I open tables from the navigat ...
Read More
I believe this issue was introduced in Office 2016 C2R (click to run, from Office 365) version 1707.
Version 1708 Build 16.0.8431.2215 resolves the problem. It was mad ...
Read More
| |
Users are experiencing errors when trying to enter data and run queries. Database has been running for months with no issues. 
Read More
| |
Dwayne Hing in Access
, 08-24-2016
Hi there Access Network! I have a client that is wanting to know if they can keep Access 2010 installed on their current machines and to install Office Pro Plus (to include Access 2016). Access 2010 is 32-bit and they want to install Access 2016 64-bit a ...
Read More
Best practice is to use a VM but I'm running both with no real issue
Hi there Dwayne, As far as I know newer and older versions of office can run side by side but only if the newer version is running in the "Click2Run" format and the older ...
Read More
| |
There is far more to EXCEL than what I want or need it for. I have been an Apple user and for years I have been using a very old Appleworks program to make charts of various business expenses for tax purposes. It has worked very well since 2000 ( yes I ...
Read More
| |
Sindre Kjær in Access
, 02-13-2018
Our team has been using Microsoft Access 2010 as a frontend for an SQL Server 2014, and are dependent on the Upsizing Wizard in Access to migrate tables from Access to SQL. From Access 2013 and onwards, the Upsizing Wizard is gone, and we are in need of ...
Read More
I've had to jump through some hoops to make this work on my system. this may help
...
Read More
| |
Philip Hou in Access
, 03-24-2017
Since transferring my Office Home & Student 2013 to a new laptop, the excel file when clicked to open, does not open. Instead only Excel program opens. Then I have go through File -> Open , then either Recent Workbook or Computer -> Documents. Kindly help ...
Read More
This is a group for answering Microsoft Access (the database) questions. It would seem this question should be in the Excel group or Office group. But maybe someone here ...
Read More
| |
Tom Koel in Access
, 03-21-2017
I'm having a terrible time figuring this out. Im trying to call Excel's function.ets function from an ms-access module. I can call other functions without a problem. I've got the arrays filled up and I've tried it a million ways, always with the same a ...
Read More
I am having the same issue, When I was trying out different combinations for the various non-default parameters, at just one point it worked, but when I manually refactor ...
Read More
| |
Does anyone know how we can access the Termstore of our Office365 subscription with an ACCESS Desktop application?
We use an access desktop application as frontend to read and write product master data (such as product name, material, color, net weigh ...
Read More
| |
I'm recently retired, and have time to kill. My ultimate goal is to create a Web based application to prevent me from having to answer my wifes constant question... "where is the?...". So, I've developed the basics in an Access 2016 database, and it is far ...
Read More
Hi Paul You are going the right direction. the only thing you need to ask yourself how much time do you want to spend in developing the solution. If you seeking for an f ...
Read More
| |
I have a current Access Web App that I'm working to recreate in either Access desktop (with the file saved on SharePoint) or in PowerApps. I'm still not sure what is the best solution. However, I would like test the eexport feature of AWA. My question is, ...
Read More
I have the same question and am somewhat surprised to see that a presumably simple yes or no question is yet to be answered by a Microsoft rep..? Despite having observed ...
Read More
| |
How can I create a query in Access Web Services where to columns in on field. Like I have the 2 columns “Street” and “Number” and I like to show on column “Street Number”. Thanks for your help Stefan
Read More
I need this because I can only show 4 columns on my view.
| |
One of my teams is experiencing an issue where a particular form is not loading after a long wait period. The following screen is displayed. Not very helpful as I AM the app creator... 
Read More
| |
Hi all when i trying to upgrade from Access 2010 to 365 the buttons of my equations not return any value ??
my last update is Access 2000
Did you make sure to enable or set a trusted location?
| |
Hi. From an AWB App, online, if you click the gear botton (top right) , there is a new command "Export to SharePoint Lists"  this creates a subside with the name as in App name, creates tables with relashionships as in AWA App, and copies (i think copies ...
Read More
I already tried what happens when you choose to run that function: It created a subsite and exported all the data into lists. Thats it. If you had a rich AWA where you put a ...
Read More
As it looks like Access Web Apps support is not enough for many use cases: You can keep your Access Web App tables or views (based on SQL Azure) connected and in sync (on ...
Read More
I did this now my access web app database is stuck in read only mode. Has anyone else had this problem?
| |
Yes, yes, I know AWA is going away--but until I'm able to develop a PowerApp, I'm stuck using this for the next 12 months. With that said, I'm trying to find a way to count the total number of records and the total number of records with a checkbox checke ...
Read More
| |
|
| |
Hello, This afternoon I went to submit feedback, but noticed that there is an extra 'Feedback' button that does not start any action: 
Read More
| |
Brian . in Access
, 03-23-2017
[This is an excellent 33-page paper on the subject.] The purpose of this white paper is to demonstrate that Microsoft PowerApps is an alternative tool to Access web apps and worthy of consideration for an Access power user and developer. Ben Clothier, And ...
Read More
| |
There is a situation where I am trying to find a count of how many unique values are associated with an item on a related table. How can I find this? Here's the scenario Business Opportunities 1 ACME Widgets Quotes Generated 1 Quote 1 for ACME Widgets by Pa ...
Read More
| |
thanks for sharing the links
| |
Hello Folks, Microsoft Acess with the integration that ir provides with SharePOint can be used to provide quite a lot of solutions to business problems. I have used this in the past to SYNC 2 sharepoint lists and to generate reports. I was wondering if ther ...
Read More
| |
Access Web Apps has been introduced in 2013 and we are nearly 4 years later without further developments, I only can count one or 2, and anyhow they are 2 years old. Microsoft Access (Desktop) has been preferred for small businesses since ages and the Acc ...
Read More
| |
