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
7
votes
3 answers

Installing Access runtime 2016 along with Office 365

This is not a progrmaing question, but I am sure MS Access developers will soon hit this problem Situation : PC has MS Office 365 Installed (Home or small Business version) which does not include MS Access 2016. Try : Instating MS Access Runtime…
Adarsh Madrecha
  • 6,364
  • 11
  • 69
  • 117
5
votes
2 answers

Concatenating Title and Name Strings in Access

I'm trying to concatenate the title, first name, and last name of a contact into one string in an Access report. Currently I am using a text field with the control set to =[ContactTitle] & ' ' & [FirstName] & ' ' & [LastName] However, some…
Elizabeth Ham
  • 176
  • 12
5
votes
4 answers

MS Access 2016 Treeview error: "No object in this control element. Runtime error 438"

I have a problem to open the treeview in MS Access. I think it's since the last windows update. I'm getting an error message when I start the program: "There is no object in this control element. Runtime error 438: Object does not support this…
user3632242
  • 51
  • 3
4
votes
4 answers

Finding Version of OFFICE 365 Build version with MS-Access VBA

With Microsoft's latest forced update to Office 365 that broke so many Access databases using tables ODBC links to server databases, I've been trying to find a way to pull the Office build info while in MS-Access and display that info in a Main form…
dbmitch
  • 5,361
  • 4
  • 24
  • 38
4
votes
2 answers

How to set a reference to a running object in Access VBA

I try to open a form in another database by using GetObject. Unfortunately I have to open a second instance of the database, but I would like to use the active instance of that database instead (if loaded). TO accomplish this I need to set an object…
Art
  • 390
  • 2
  • 14
4
votes
2 answers

How to set a validation rule on a field in Access using SQL Query?

I am using MS Access 2016 (Office 365) and I am currently facing an issue. Below is an example demonstrating this issue. Here I created a Table named as NodeFamilyLink, which consists of two fields: NodeID and FamilyID as shown below. Now the…
KhiladiBhaiyya
  • 633
  • 1
  • 14
  • 43
4
votes
1 answer

Creating a Custom Aggregate Function for Access Queries

Most Common/Frequent/Dense Value I'd like to find (or create a custom) aggregate function for use in an MS Access query, that will return the most common value (ie, "most frequently occurring item") when grouped by a different field. Below is one…
ashleedawg
  • 20,365
  • 9
  • 72
  • 105
4
votes
3 answers

Select results from multiple subqueries

I am trying to make a single table from the results of 9 different subqueries. Here is my code: SELECT APR16 FROM( SELECT Sum(APR.[kwh]) AS APR16 FROM Peak_Times, Meter_Buckets INNER JOIN APR ON Meter_Buckets.METER = APR.meter WHERE…
Dustin Knight
  • 350
  • 1
  • 4
  • 17
3
votes
3 answers

TransferSpreadsheet Error 3251 Operation Not Supported

I have code to export MS Access (2016\2013) queries results into Excel spreadsheets that has worked for years. This is the code (not posting all variables definitions I've on top of it): strSQL = "select[query].* FROM [query] " Set qdf =…
Deltav
  • 33
  • 2
3
votes
3 answers

LEFT JOIN multiple sub queries

My intention is to create a table with the number of orders and revenue for two different years for every product. My idea was to use a double left Join but I don't understand why this query does not work on MS ACCESS. I decided to use LEFT JOIN…
ianux22
  • 405
  • 4
  • 16
3
votes
1 answer

Setting listbox.recordset to an ADODB recordset causes crashes when using the listbox

I am working in ms-access (office 365, v1808), and today my code suddenly broke down. I have not been able to pinpoint the problem specifically nor have I been able to find useful information on the internet. I'm retrieving a recordset with an…
Ayam
  • 169
  • 1
  • 12
3
votes
1 answer

"Error: System.Data.OleDb.OleDbException (0x80004005): The following query has been corrupted: ''

This morning the program stopped running with this error message. Only works on my machine, everyone else. This program has been running for two years and no such bug has occurred so far. What could be the reason? Nothing has changed since last…
Juhász Lajos
  • 129
  • 1
  • 2
  • 8
3
votes
1 answer

MS Access copy table to another table VBA code

I have a problem I need to create vba code for ms access 2016 which will copy the contents of table 1 to table 2 with If there are duplicates in Table 2, it displays a message about the duplicates and a question whether to continue or abort. I have…
Wojtek
  • 31
  • 3
3
votes
2 answers

How can I input data for a many-to-many table in Access?

I'm sure that this is a basic question but I'm struggling to get to grips with Access. In my case I have two tables: Student and Subject, linked by a junction table, StudentSubject. Student and Subject have a many to many relationship, as one…
Lou
  • 2,200
  • 2
  • 33
  • 66
3
votes
2 answers

How can I change the default datasheet font in MS Access 2016?

I'd like to change the default font that is used as for datasheet views in MS Access. Recently, I've upgraded from 2003 to 2016, and I can not find out how (via Google or otherwise) to change the default font that is used for displaying data in…
Emmanuel Millan
  • 411
  • 1
  • 4
  • 12
1
2 3
…
98 99