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
-1
votes
1 answer

MsAccess get Forms Objects in Office 2016

In my MsAccess project I want to access the Forms,Reports and Tables objects. I need to check the forms fields their height and weight, Tables definition, Reports Queries and so on. Also I need to do this for MsAccess 2016/365 in C#. I tried…
user581453
  • 59
  • 1
  • 8
-2
votes
1 answer

MS-access append query for specific column

how can I use access append query for specific column for empty existing table contain same column and many other column include calculated columns ?
Mohamed Magdy Nasr
  • 1
  • 2
-2
votes
1 answer

create Query in access

Customer Table ECR Table I have two tables(they are related in cif) and i want to know how to create those two query first one to show all customer id as cif in my table (1) whose status= closed and they have ECRstatus from second table =…
Yehia Ahmed
  • 27
  • 3
-2
votes
1 answer

I am getting a VB error '2467' with this routine ONLY. Other routines using SAME principle recipe are working well

I am using MS Access 2016, and I have a form with a subForm. In other forms (8), I have created, with the same "recipe" - they work fine... subForm loads and receives data from the VBA query. In this case, I keep getting this - Microsoft Visual…
PaulW
  • 39
  • 10
-2
votes
1 answer

I'm using MS Access 2016 SQL to create a nested JOIN clause but I seem to get an error

SELECT (invoice.invoice_id) AS invoice_id, COUNT (line_item.code) AS code, SUM (price) FROM invoice INNER JOIN (line_item INNER JOIN (stock_item) ON line_item.code = stock_item.code) ON invoice.invoice_id =…
Vicsituma
  • 1
-2
votes
1 answer

Unrecognised database format (.accdb)

I have SQL Server (in AWS RDS) where there are huge data in millions. I’m running query to get data via SSMS in Windows server 2012. Those data needs to be analysed in Excel. From the query results( right click then “save results as...”), I am…
AskMe
  • 2,495
  • 8
  • 49
  • 102
-2
votes
1 answer

Trying to assign supervisors to employees in Microsoft Access, lookup is giving me numbers instead of names?

I'm somewhat new to VBA and Access, and yet I need to make an access database for work. I made the basic tables I need to track what we need, but I'm stuck trying to assign the supervisors to the employees. I have four tables, two of which…
jman07
  • 1
  • 1
-2
votes
1 answer

Storing calculated field in a Form for use in a Report

I wanted to store a Form calculated field somewhere so I can use it in a Report. I understand that it is not recommended to store calculated fields in tables because it breaks rules of normalization. My DB is basically a simple sum of debits, the…
ismail
  • 266
  • 2
  • 12
-2
votes
1 answer

Microsoft Access 2019 Report. Automatically Resize Image Control

Insert and resize a picture in an access report Solution by Ms Isabel Smit aborts at first line of code. My Report textbox [P1] populated by query has links to *.jpg files. But code, Me.Image46.Picture = Me.P1.Value does not work. Get error msg…
Selva
  • 11
  • 3
-2
votes
1 answer

Fire the Row Source (Pass through) query on request (Not on Load)

I am developing an application using MS access 2016. In my form I have a list with a "Pass-Through" query as the row source. The pass through query is fired when on load the form. But I want to load/display the data in the list only when the user…
Sahi
  • 1,454
  • 1
  • 13
  • 32
-2
votes
3 answers

populate text box on one form based on combo box selection on another form

I've been looking around and can't seem to find an accurate answer to at least steer me in the right direction. On form1 (Members) i have a button that opens another form (supervisor) with a combo. The combo has 3 fields and upon selection I want it…
user2002716
  • 120
  • 2
  • 11
-2
votes
2 answers

MS Access 2016 crashes on a certain linked SQL Server table

I imported MS Access tables into a SQL Server 2012 database. In MS Access, when I change the link to the SQL Server table, the database does not open (stops responding and closes). I change them back to the Access tables and they open fine. I then…
Michael M
  • 1
  • 1
-2
votes
1 answer

Multiple-step OLE DB operation generated errors. C# / MS Access

BEFORE you guys tell me that this is a duplicate, You should know that I have gone through almost every answer I could find. But still i have not been able to solve this issue. I have tried adding registry values in Computer\HKEY_CLASSES_ROOT\CLSID…
Sudeep Shrestha
  • 128
  • 2
  • 14
-2
votes
1 answer

Filter a Query based on multiple combo boxes but if combo box is blank show All records including empty,

I have a form and a list box what is filter with the criteria when the user is selecting from Combo Boxes. And the record source from the list box is a query so i want to filter the query I have used this code in query designer Like " * " &…
Benzion weberman
  • 7
  • 7
-2
votes
1 answer

Relational Database Design (Access)

I am attempting to design a DB that houses peoples time that is assigned to a project. So for example, Bill is assigned to 20 hours on project A, and 20 hours on project B for weeks 50-52 of this year. For weeks 1-9 of next year he is assigned to…
Isaac Brandstetter
  • 1
  • 3
1 2 3
…
98 99