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
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.
  • 725
  • 5
  • 28
  • 81
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
  • 953
  • 1
  • 8
  • 19
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
  • 339
  • 3
  • 16
3
votes
3 answers

Create loop to open and export reports

Background: I have a database I am in the process of making for the school board. I am in the final stages and have never had a loop that I couldn't figure out...except for this one. Setup: Here is the SQL on the query that runs the report…
Jöel Dahl
  • 35
  • 4
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
  • 4
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
  • 314
  • 3
  • 13
2
votes
0 answers

referring to nvarchar(max) in stored procedure parameter in Access VBA

I'm using Access and SqlServer. I had a table field "inv_base64_code" and type nvarchar(max) cmd.Parameters.Append cmd.CreateParameter("@p_inv_base64_code", adVarChar, adParamInput, 500, Nz(!inv_base64_code, "")) How could I refer to max length in…
A.J
  • 45
  • 5
2
votes
1 answer

MS-Access UPDATE statistics per person

Ive got this update query that uses employee activity stored in two tables (Beldata_filter & Urenlog_filter) to create a performance analysis per employee in another table (Bellers_filter). however, i cannot get my query to update the performance…
wobbe vdpas
  • 21
  • 2
2
votes
1 answer

Subform showing up blank after code executed

My goal is to change the SourceObject of a subform. I can do this manually by going into design view selecting the subform object and changing SourceObject and removing the master and child links. I save changes and reload into form view and all…
Gilford423
  • 21
  • 2
2
votes
1 answer

Access VBA Filtering form and charts by a combo box list

I have a form that has charts and textboxes and a list, the form has no control source. and I have one combobox that has date list, based on that list I want to filter the data on the form and reload the charts and text boxes to view the filtered…
Zyarat
  • 21
  • 1
2
votes
0 answers

Access 2016 DB in Trusted Location still showing security warning for path location

Been puzzling over this for a few days. I install a compiled Access 2016 database (accde) into a %localappdata% program subfolder and add that folder to an Access Trusted Location. Kind of following @Gustav's post to use that folder. Yet it…
dbmitch
  • 5,361
  • 4
  • 24
  • 38
2
votes
1 answer

Button for editing / lock editing data in Access 2016

I am blocking users from accidentally editing datasets. They have to hit a button to edit stuff. This button sets the "AllowEdits" setting of the form to "true" which is "false" by default. It also changes the caption of the button accordingly. My…
Guido Gallenkamp
  • 169
  • 6
2
votes
1 answer

Select top n (variable) for each criteria in a table based on another table

I want a VBA code to make a query to show Equip with Top ActiveTime for each ModelID (from 1st table) based on TopN for each ModelID (from the 2nd table), I know i have to use QueryDef and Sql VBA but I can't figure how to write the code Just and…
MMN
  • 23
  • 4
2
votes
2 answers

Set default value in a Microsoft Access combo box to current month

I have a column "Month" in my MS Access 2016 Database Record whose month value say "January" or "February" should be entered using a combo box with the following; Row Source Type: Value List Row Source:…
Clyde Mulenga
  • 77
  • 6
2
votes
2 answers

How to return instances where all members of GROUP BY equal a certain value?

I have the following table structure: Essentially, I need to return the rows where ALL VALUES of that grouping are FALSE for LeadIndication. I am using GROUP BY on the Parent column but having trouble getting the instances where ALL records in the…
chrtak
  • 43
  • 6
1
2
3
…
98 99