Stack Overflow
Stack Overflow

Questions tagged [ms-access-2016]

Microsoft Access 2016 is a database management system and application development tool.

Microsoft Access 2016 is a database management system and application development tool. It is included in some versions of "Microsoft Office 2016" and "Microsoft Office 365".

For more information on Microsoft Access, see http://en.wikipedia.org/wiki/Microsoft_Access

For more information on new features in Microsoft Access 2016, see: https://support.office.com/en-us/article/What-s-new-in-Access-2016-76454345-f85d-47af-ace1-98a456cb3496

Access Development - MSDN - Microsoft: https://msdn.microsoft.com/en-us/library/office/fp179695.aspx

1477 questions
2
votes
1 answer

How can I get a record to be counted in multiple columns of a Crosstab Query?

Background information: My company requires employees to maintain at least one certification (cert) on a position. There are a total of 17 different certifications that an employee can get. An employee can hold multiple certs. But on any one day…
JRID
  • 23
  • 3
2
votes
1 answer

Access 2016 tab control - tabs still clickable when hidden

I have a tab control object on my Access form and have changed the style to none so that the tabs are not visible, however when I click on where the tabs would be it still changes the pages like as if they were there. Is this normal behaviour and is…
Leroy
  • 634
  • 1
  • 8
  • 33
2
votes
1 answer

Query inside Access DB faster than external query with Excel (power query editor)?

I am supposed to optimize the performance of an old Access DB in my company. It contains several tables with about 20 columns and 50000 rows. The speed is very slow, because the people work with the whole table and set the filters afterwards. Now I…
Stefan L.
  • 65
  • 10
2
votes
1 answer

PYODBC + PYINSTALLER: EXE listing different drivers as compiler (PyCharm), 32 bit Access and 64 bit Python

I have 32bit Access and 64bit Python (on x64 Windows 10). I successfully run the following code to obtain table (or a query) from my .accdb database and get the desired outcome in my Pycharm. import pyodbc import pandas import os import sys sources…
user9799161
  • 123
  • 2
  • 14
2
votes
2 answers

Invalid field definition error when trying to link two tables

I'm trying to link the "Subject" table to the "StudentSubject" table in the image below, but I get the error "Invalid field definition 'SubjectID' in definition of index or relationship." when I attempt to do so. The end-goal is that I want to…
Lou
  • 2,200
  • 2
  • 33
  • 66
2
votes
1 answer

Missing: Outlook 16.0 Object library (msoutl.olb)

I'm running an MS Access database with VBA code that has libraries for Microsoft Office 2010. Currently, there are users that are upgrading their machine to Windows 10 running Access 2016. When the database is opened on a new machine running…
lunar8nrg
  • 111
  • 3
  • 14
2
votes
1 answer

Suffix Field Values based on number of occurrences in Table

I have a table in MS Access that has a field layout_desc. I need to create a query that changes each value in this field by adding how many times the value is repeated in the table. For example: Thank you.
ali
  • 31
  • 4
2
votes
1 answer

Activate an Open MS Access File to SendKeys With VBA

I am trying to send key strokes to an open Microsoft Acess file so that I can export data to an excel file via the toolbar. How can I activate the open Access file in VBA code so that it is the window of focus?
ElectroMotiveHorse
  • 426
  • 1
  • 6
  • 16
2
votes
2 answers

Access convert multi-valued field table

I've taken over a database that has a table with mutli-valued fields e.g I'm trying to convert this into a single-valued field table e.g. The number in both tables is just an ID that refers to a person named Contact_ID. I've tried doing this in…
TonyL
  • 35
  • 5
2
votes
1 answer

get custom database properties in vba

In ms-access-2016 in the info section of the File menu, there is a link to View and Edit database properties. When the link is clicked a box comes up with 5 tabs, the right-most one is Custom. This tab provides an user interface to add custom…
Perry Sugerman
  • 179
  • 1
  • 11
2
votes
3 answers

VBA-Web JSON Multiple Pages

I'm using the VBA-Web Library to process incoming JSON calls in VBA: https://github.com/VBA-tools/VBA-Web Here is a sample small response (1 page only): You can see at the bottom there's a "TotalPages" returned. Following is my VBA code: Set…
user10327557
  • 21
  • 2
2
votes
3 answers

Can not start your application The workgroup information file is absent or opened exclusively by another user

I am trying to run a query on an access database located on a distant server (my code is written in C#). I use the following code and connection string: public static string MadoneConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=…
mStudent
  • 1,568
  • 3
  • 15
  • 21
2
votes
1 answer

Access: Fill in data (date) from another when entered and empty

Working with MS Access 2016. I have a form with multiple textboxes. I want one of my textboxes (tbx_outTSDatum_BQC) to be automatically filled -if entered and empty- with the value of another textbox (tbx_inTSDatum_BQC). This code does…
Jens Wilken
  • 31
  • 1
  • 6
2
votes
1 answer

Custom ribbon does not display when database is opened from File menu

A custom ribbon is assigned to an (entire) database in the options for "Current Database" and displays when I open the database with a shortcut like this: "C:\Program Files (x86)\Microsoft Office\root\Office16\MSACCESS.EXE" D:\d\music.accdb However,…
Dale Thompson
  • 115
  • 1
  • 7
2
votes
1 answer

VBA data type equivalent to a long number access 2016

Access 2016 has added support for 64 integer (bigint) in tables and especially linked tables. But what is the best corresponding VBA data type. I hope it is obvious that I want to transfer values between variables and fields in the tables. Long is…
AndyDev
  • 21
  • 2
1 2 3
…
98 99