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
| |
JFM_12 in Access
, 12-14-2018
Hello Which are the possibilities to open an access db. We are running 32bit Office ProPlus on Windows 10 but need 64bit driver. Microsoft is not advising it. Are there any 3rd party drivers or ODBC Configurations. The only ODBC drivers are: - ODBC Driver 13for ...
Read More
| |
KerryF in Access
, 12-13-2018
I've spent HOURS searching for answers / examples on how to control how my data is displayed on my report. ANY help here is greatly appreciated. I have a db that tracks patiets with multiple medications. I have my report that displays these patients who ...
Read More
| |
tonyv in Access
, 12-13-2018
Hello, I'm working on a database Form where the user wants to enter currency for purchases in a hobby shop. They would like to enter it numerically only, starting in the second decimal (i.e. penny) position, and then filling from right to left - that is, ...
Read More
| |
DCBCSM in Access
, 12-12-2018
I have connected an Access table to a table in SQL server and the table values can be updated without any problems in both SQL and Access. However, when I try to add a new record in Access, I get the error: "[SQL Server] Cannot insert explicit value for id ...
Read More
| |
pweber in Access
, 12-07-2018
Hi everyone. We are a company who currently uses Access for a lot of our reports and setting up and tracking jobs. All of our office computers are setup on a central server (we are not cloud based). We are looking into the possibility of adding tablets to ...
Read More
You can setup **VPN access** for your Windows tablets and place the Access database file on a **shared folder** to enable multi-user Access up to 255 simultaneous connect...
Read More
| |
miranda1780 in Access
, 12-11-2018
I am an accounts receivable clerk for my city, part of my job is issuing business licenses to businesses within the town. I currently use filemaker pro, which I don't really like, Is there a way to create a database of the businesses and have a template t ...
Read More
| |
Hai Friends, I am a fresher in Access data base program I want to a chart based on mark . Total 8 fields But I can't accommodate only 6 numbers
| |
 Registration for the 3rd Access DevCon Vienna (April 27/28, 2019) is open now. The preliminary agenda will be completed in the next weeks but already has a variety of advanced topics and an intercontinental team of presenters.
The goal of the event is to ...
Read More
| |
Hi, i have 4million of row in my Access database. I want to export subsets of my data to excel. i want to export as per below Numb. Of subset Start row End Row
1st 1 ...
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
Hi, I just installed Office 2019 click to run.
I am astonished, very bad experience.
First of all I run the installer and nothing happens, I got any message of installation ...
Read More
Hi Dan could you tell me if access 2019 has backward compability with access 2016 and access 2010.
really thanks !!!
So no Mac version of Access? Thanks.
| |
ktesler in Access
, 11-20-2018
I have an Access Database that was designed and working fine in Windows 7 with Access 2010. It has a form that allows you to drag a file from the desktop (such as a pdf file) and load the path on the form for further action in order to transport the file ...
Read More
UPDATE... So I am able to drag and drop a file and this is what I did. I had to click in the form a few times first and then I can drag the file over the form and it wi ...
Read More
| |
 You can watch the video of Microsoft's Michal Bar presenting news on Access 2019/365 at AEK 21. There are also some pictures showing the two conference weekends with 210 Access developers and a page with details in wonderful German. ;-)
Karl
Read More
| |
jiri in Access
, 11-14-2018
Dear experts, my simple question: Is possible to use runtime for split db (files accde + be.accdb)? Back - end file is located on network disc. If you run accde from PC - full Access 2016 (no runtime) everything is OK. Otherwise from runtime error mess ...
Read More
| |
null null in Access
, 11-09-2018
We have a set of tables: Customers, Orders and Order Items. Each Customer has only one Order and each Order has one or more Order Items. The Order Items table has a column for the ID of the Order. We are able to create a report that groups by the Customer ...
Read More
| |
troy miller in Access
, 11-01-2018
I ended up supporting a 2005 Access database then converted to 2016. I noticed the tables and querys did not export. I set the new references and still get the following error. attached (input) is the error I receive when opening the database. No table or ...
Read More
| |
I have a field in a table titled Description that has a mix of words and numbers. The numbers can be found anyplace and combination with the text. Is there a function or query that I can run to extract the numbers? Example - Smith Pass 321 Regular
- 73 Pass S
...
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
| |
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
| |
|
| |
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
| |
