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

Primary key violation triggers warning, but does not trigger error handler

I have a button on a form that runs an insert statement that takes data from some textboxes on the form and puts them in a table. In the event that the user enters duplicate information, in the primary key (a concatenation of 2 of the textboxes), I…
BSoD'n'Syntaxes
  • 35
  • 8
2
votes
2 answers

MS Access 2016 Can't export to pdf

screenshot of errorHaving an issue regullary that I can't export a report to PDF from print preview using Windows 7 & Access 2016. Get the following error: Microsoft Access can't save the output data to the file you've selected The file may be…
Cubitte
  • 21
  • 3
2
votes
2 answers

run a query that is based on the results of another query in Access

so I have a an Excel spreadsheet imported into Access as a table and I am wanting to search this table on different criteria via a search from. The search from needs to search for specific criteria using the AND function but also to perform a text…
renren
  • 21
  • 1
2
votes
1 answer

Add Max(Count(column)) in SQL MS Access

I have the following example dataset and as you can see the column X is the class ID, column Y is each class name, and finally column Z is the other universities class ID used for each subject. The goal is to get X, and Z with a grouping by X and…
Juan Espinosa
  • 33
  • 3
2
votes
1 answer

MS Access - References to a different database

In the VBA code of an Access database (the "CurrentDB"), I open another database (by Application.DBEngine.OpenDatabase(...)). and I'd like to update some library references within this second database. But as the References object is a property of…
Klaus
  • 31
  • 3
2
votes
1 answer

Difference between two dates in number of months and days SQL

I'm trying to display the difference between two dates in order to calculate the monthly rent, I'm expecting the exact number of months and days because the contract is "monthly" so if it is February, March or April, the monthly amount is fixed. so…
Osama
  • 21
  • 2
2
votes
3 answers

MS-Access: How to refresh a form after data was updated?

I have a query shown in a form as a table. Additionally I have a button which opens another form where you can manipulate saved data. As soon as this form closes I would like to have the query in the other form to be updated by a macro. I tried…
Peter
  • 579
  • 2
  • 7
  • 18
2
votes
2 answers

MS Access SQL convert Rows to Columns

I need some help with converting an MS Access table with data in Rows into Columns. Created some sample data table that suits my scenario. I need to convert "Table 1" to "Table 3". If possible using the "Table 2" to identify the column order of the…
Ravi
  • 55
  • 5
2
votes
2 answers

How to fix end of statement when trying to insert multiple values in SQL?

I just started a database course that is going over SQL using Access 2016. I am getting a End of statement error and I am unsure how to fix it. My table code is ` Create Table Pet_Owner ( OwnerID autoincrement Null, OwnerLastName Char(30) Not…
Eddie
  • 23
  • 5
2
votes
3 answers

Calling an Access VBA function with IF statement as an argument

Assuming I have the following MS Access 2016 function: Public Function TestFunction(ByVal strTest As String) As String Is there a way to call the function with something similar to: strReturn = TestFunction(If a = 1 Then "Apple" Else "Orange") I…
MiniG34
  • 312
  • 2
  • 12
2
votes
1 answer

Error The database you are trying to open requires a newer version of Microsoft Access

I have a 2016 access file, when I try to access this file with an SQL or Access datasource in visual studio I get the following error message: Database schema could not be retrieved for this connection. Please make sure the connection settings are…
Aseel Sakhnini
  • 21
  • 1
  • 3
2
votes
1 answer

MS Access Query does not differentiate hiragana and katakana with standard equality operator

I recently ran into a problem with an MS Access query where I was searching a table containing Japanese text. Japanese has two alphabets, hiragana and katakana, with the same sound value, but different characters. For example, あ (hiragana) and ア…
Lou
  • 2,200
  • 2
  • 33
  • 66
2
votes
2 answers

Problem with returning nth row from MS Access table

I'm trying to select the nth row of a table in MS Access (Office 365). I've seen both of the following solutions: https://stackoverflow.com/a/45031166/1907765 https://stackoverflow.com/a/44891583/1907765 And neither of them have worked for me. When…
Lou
  • 2,200
  • 2
  • 33
  • 66
2
votes
1 answer

Microsoft Access How to Count the Number of Times a Value and all Permutations of that Value is listed in a Field?

I have a Table and in that table a field named Results with values of 3 digit numbers. I have used the count function to report the number of times a value is repeated in said field with this query. SELECT [My Table].Results, Count([My…
Nate Born
  • 21
  • 1
2
votes
1 answer

How to recompile 32-bit MS Access file for 64-bit office

I'm working on a Windows 10 migration project and one issue I've run into is some of the end-users have 32-bit .accde files that cannot be opened in 64-bit Access. Target version is click-to-run Office 365, current version is Office 2010 running on…
Peter Bailey
  • 105,256
  • 31
  • 182
  • 206
1 2
3
…
98 99