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

1183 questions
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
  • 166
  • 10
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
5
votes
4 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
  • 2,897
  • 9
  • 45
  • 79
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
  • 12
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…
WarWithSelf
  • 565
  • 1
  • 10
  • 36
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
  • 17,207
  • 5
  • 53
  • 80
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
  • 139
  • 10
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
  • 109
  • 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
  • 2
3
votes
1 answer

How to implement multi-select?

First of all, I need to say that I never worked with Access or any other databases before. I'm trying to understand how it works and picked "Students" template for this task (see step 0). Now, let's start. i. Creating the base from the template and…
john c. j.
  • 490
  • 1
  • 20
  • 59
3
votes
2 answers

Issue with form property in expression builder - MS Access 2016

We have a form where one of the fields needs an expression. When we are building that expression, actual need is to select the column name, but we see that there is a property coming up along with the column name with the same name. Even if we…
Raj Kumar
  • 943
  • 8
  • 18
3
votes
1 answer

Using MS Access VBA to insert a row into a .xlsx file... how to avoid corrupting the file?

In MS Access, I am writing a small piece of code to insert a row into a .xlsx file. Both files are local. The code runs with no errors, but, each time it runs, it renders the .xlsx file unreadable. Here's a step-through: (1) I have the simple .xlsx…
Vexen Crabtree
  • 340
  • 3
  • 14
3
votes
1 answer

Creating Multiple Links in an Access Textbox

I have a form in Access 2016 with a textbox in which I need to have multiple, semi-colon delimited hyperlinks (which will be dynamically created). What I've decided to do is create a "hyperlink construction string" in VBA, then assign them to the…
Christine
  • 694
  • 6
  • 19
3
votes
1 answer

Access 2013/2016 does not support treeview control, giving error message "User defined type not defined"

I have a VBA project which runs perfectly upto windows 7 (both 32,64 bit) and upto office 2010. But when i try to run it on office 2013 or 2016. It does not load treeview control and gives error at: Private SelectedNode As MSComctlLib.node The…
yogeshgirnar
  • 29
  • 1
  • 3
3
votes
1 answer

VBA fails when Task Scheduler is set to "Run whether user logged on or not"

I have an Access VBA macro that generates a report, saves it in .pdf and then sends it by e-mail using CDO. Everything works fine if I run it manually or if I set it to be run on Task Scheduler with the security option "Run only when user is logged…
Francisco Cruz
  • 195
  • 2
  • 12
1
2 3
…
78 79