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 to limit a table to 5 records with a certain field combination

I'm using MS Access 2016. Suppose I have a Student table, a Subject table (ie Geography, History etc) and a StudentSubject table that records which subjects each student has chosen. StudentSubject contains StudentId and SubjectId as foreign keys. No…
twisted
  • 742
  • 2
  • 11
  • 19
2
votes
1 answer

MS-Access VBA SQL, If condition in subquery, efficiency and improvement

I've managed to get my code to work, but it takes a very long time to execute. I use a series of open and close recordset statements to get the addr_ImportID I'm looking for before executing a final SQL statement and writing the row to a table. Is…
Jeffrey W
  • 33
  • 5
2
votes
0 answers

Quarterly Reports on Dates

I have a challenge ahead of me. I have looked at this for a couple of days now in a trial and error sense and am getting tired of not getting it… My SQL knowledge is very very basic. Each quarter I have to report on the questions below (of course…
Matt McKee
  • 21
  • 2
2
votes
1 answer

Cannot insert/update Long Text field in a table in an Access database using pyodbc

I have been using pyodbc to connect with a local Access database (.accdb file), but have been unable to update a Long Text field, if the string I am trying to input has more than 255 characters. The data type of the field (Description) is Long Text,…
user3187129
  • 25
  • 5
2
votes
1 answer

MS Access Multi-control KeyPress CTRL+A Handler

I have an Access database with 10+ text controls. I'd like to have some code to handle the CTRL + A KeyPress event. Normally, when pressing CTRL + A in Access, this selects all records. My end goal is to have CTRL + A only select that control's text…
Pat
  • 78
  • 2
  • 14
2
votes
5 answers

Prompt for User to Save a Form

I have one last question for the moment for my class database. For certain forms where a user can view data, I want them to be able to close the form and not be prompted if they did not make any changes. HOWEVER, if they chose to change some data…
Adam
  • 45
  • 5
2
votes
0 answers

What is 'PrimaryKey' converted to by SQL Server Migration Assistant for Access/SQL Server

I've put an Access database into SQL Server Migration Assistant for Access and created a report (I haven't sent anything to the server). I'm getting the following info msg: "A2SS0029: Primary key name 'PrimaryKey' was changed during conversion." I'm…
wazz
  • 4,953
  • 5
  • 20
  • 34
2
votes
1 answer

How can I add a "Calculated" field in a table that outputs the count of records in the subdatasheet for that record?

For example, The number of instances field shows "1" because there is one record in the subdatasheet associated with the main record. (I currently have the calculated field set to "1" for all records as a placeholder) Is there a way to have this…
RBuntu
  • 907
  • 10
  • 22
2
votes
1 answer

TransferText incorrectly imports strings like "FS###" as Currency

I am using the VBA DoCmd.TransferText command to import data from a CSV text file into a new table in my Access database. I have run into an issue where the text data in the first three columns in some of the files is imported as currency. I cannot…
J. Wiley
  • 23
  • 3
2
votes
0 answers

MS Access query on linked tables with multiple joins is very slow

I've a MySQL database and a MS Access front end. MySQL database tables are linked via ODBC connection to MS Access. ANY query with multiple joined tables will run extremely slow in case of having anything in "WHERE" (or "HAVING") clause. For…
David P.
  • 77
  • 7
2
votes
1 answer

MS Access Crosstab Query with Non-Aggregate Value Field

I work in a call center and am trying to generate a crosstab query in MS Access 2016 that will show sales conversion rates by month and by advertising source. In this query I want the columns to represent months, the rows to represent advertising…
Andrew Wetzel
  • 33
  • 6
2
votes
1 answer

An error occurred saving import/export specification ''

I am new to MS-Access. The title is the error I get when I try to import an excel sheet into a new table in Access 2016. Note the single empty quote is part of the error message. I've tried reinstalling, playing around with import options, importing…
ismail
  • 266
  • 2
  • 12
2
votes
0 answers

Query not allowing updates

I built a query based on a child table but the join is not the way I want it to be and it's not allowing updates. I have other similar queries based on similar child tables which are all one-to-one linked on the main table by a unique patient ID…
Jim Bray
  • 758
  • 8
  • 12
2
votes
1 answer

How do I make a button that runs an update query in Access 2016

I have an update query with the following SQL UPDATE UserListTest SET UserListTest.UserName = [forms]![EmployeeAdd]![NewFullName], UserListTest.AccessCode = [Forms]![EmployeeAdd]![NewCode] WHERE…
mikecal7
  • 95
  • 1
  • 2
  • 7
2
votes
2 answers

Access 2016 VBA TextBox is Null

I don't use VBA from long time....I have this form in Access 2016 When I try to access to the various TextBoxes through the Me.Controls Collection and convert it to a TextBox object, I get a Null reference but some its properties are valid (eg.…
Barzo
  • 1,039
  • 1
  • 11
  • 37
1 2 3
…
98 99