Questions tagged [ms-access-2016]

Microsoft Access 2016 is a database management system and application development tool.

-1
votes
0answers
12 views

Access 2016 Navigation Form

I am having a problem with access 2016 Navigation Form and will appreciate it if you guys help me out. Here is what I want to do in the navigation form: I programmed the tab "Vendre" to open in dialog ...
-2
votes
0answers
19 views

Auto assign primary key for a table from another table [on hold]

I have two tables in the database 1. Main Table 2. Key Table I need to add new records in Main Table by import (from user uploaded data in the form of Excel). But the primary key for this table is to ...
1
vote
2answers
26 views

How to delete a column of an excel document created by exporting an access subform?

I am trying to delete a column from a excel file created by exporting an access subform. I use the following vba code to perform the export. The exported file contains are five column. Private Sub ...
0
votes
1answer
33 views

Requery Combobox in a subform contained within a tabControl from another form [on hold]

I am unable to locate the path to requery the combobox: Forms!frmMain.tabControl.Form!frmSub.subCombo.Requery I have a main form named frmMain that has tabcontrol named tabControl. Then I add a ...
0
votes
1answer
28 views

Variable in Dlookup in Access 2016 returns runtime error 13 - type mismatch

The logic isn't complex. The application uses a temporary table into which data for a report is appended. Once the report has been run, the data is cleared. Initially, the client told me that he would ...
1
vote
2answers
40 views

MS Access, getting total values from two tables

I am trying to get the total values from tables "sales" and "payment" where the customer_id in both tables match the customer selected from a combo box in a form. Table 1: Sales customer_id item ...
1
vote
2answers
41 views

How do I get my Access form to re-open to the last unbound text box entries?

I have created a form to update criteria in various queries in my database. I have 4 unbound text boxes. The user enters the new dates into the text boxes and I've added a button to run the queries. ...
0
votes
0answers
52 views

How to close forms from within a form event [closed]

I have some values stored in variables which can be updated during processing and when I detect that specific values are stored there, I need to have the user enter new values to continue processing. ...
0
votes
0answers
35 views

DSum query slow when it is a Make Table query

I am trying to capture which products account for 80% of sales and therefore need a way of having a running sum as well as a total sum for my data. The query runs relatively quick if it is just a ...
0
votes
0answers
11 views

Access Query Criteria Exclude Iif like

I have a query on a table of 10 possible results. C, D, E, EX, F, G, H, T, I or None Choices on the form determine which statements apply to the given product. Each result is tied to an image ...
0
votes
1answer
20 views

Error when runing query from form between two date from a form

I have a form called FirstInLastOut which looks as the image below. Based on Name or badge number I want to search between two dates. I am using the following criteria on the query: >=[Forms]![...
1
vote
0answers
43 views

MS Access - Criteria being added to a Query after the Query has run

I'm new to Microsoft Access, I have created a Database to store data in relation to workers and their expertise in specific tasks, the industries they cover and the Geographic area they work in. I'm ...
1
vote
1answer
47 views

Create only non-duplicate records using SQL queries in Access-VBA

Issue detail: I have spent nearly two full days and I am still unable to find solution to this issue: Step 1: I have a table named “table1”. It has three fields which are already populated. I created ...
1
vote
1answer
34 views

Missing: Outlook 16.0 Object library (msoutl.olb)

I'm running an MS Access database with VBA code that has libraries for Microsoft Office 2010. Currently, there are users that are upgrading their machine to Windows 10 running Access 2016. When ...
0
votes
1answer
34 views

MS Access 2016 TransferSpreadsheet Import Error 3274: Not in the expected format

I'm trying to set up a macro using VBA in MS Access 2016 to import a number of .xls files into my table. I was able to run this macro on 13 of the files, but after the 13th file, every remaining ...
0
votes
1answer
16 views

Display different values based on dates stored in a table in Access [duplicate]

I have a set of data, orders from customers on every date. I use seasons in my company to compare sales. The seasons are not defined by the year but from certain dates ie. Season 2019 - From: 01/05/...
1
vote
1answer
78 views

Microsoft Access APIs?

I've been digging through Microsoft's API pages (both the REST APIs and the Graph APIs) - but I'm having a hard time finding out if there is any way to access Microsoft Access through an API. I'd ...
1
vote
1answer
30 views

Query to get Total Purchases and Closing Stock for Period

My current setup: Products Table UPC(Number) PNAME(Text) Purchases Table purDate(Date) PNAME(combo box) Quantity(Number) Closing Stock endDate(Date) PNAME(combo box) Quantity(Number) I want to ...
2
votes
1answer
23 views

Suffix Field Values based on number of occurrences in Table

I have a table in MS Access that has a field layout_desc. I need to create a query that changes each value in this field by adding how many times the value is repeated in the table. For example: ...
0
votes
0answers
42 views

Why do I keep getting this error 'Could not find installable ISAM.' when trying to open a connection to a access database using vb?

Database name = LogIn.mdb When code is executed in a button click event, I get an 'Exception Unhandled' error popup pointing to the line conLogin.Open() saying System.Data.OleDb.OleDbException: ...
0
votes
2answers
75 views

Access 2016 - RecordsetClone Error on a form constructed with a virtual recordset opens “Select Data Source” dialog

I've seen a number of posts trying to describe this bug but they haven't framed the problem correctly to be reproduced... or not set the scenario in the way that I've experienced the bug using a ...
1
vote
1answer
68 views

How can I get accurate totals from a subform when in splitform view, currently each record needs to be selected before the total is correct

I am setting up a system for the reconciliation process of accounts payable. I set up a few tables for inputting the groups of tickets that we get every day to log them before we get in the invoices. ...
-2
votes
1answer
21 views

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 ...
-1
votes
0answers
10 views

Autoincrement of primary key on existing data in access using Dmax + 1

I'm hoping some bright spark can help me out here. I am an Access novice. I have an access database and I have imported existing data into it. The primary key needs to be a sequential number. I need ...
0
votes
1answer
18 views

access vba docmd.applyfilter for dates

I am running a code based on a week number to filter for work order dates that match the week column and are greater than the WODate Column. My code gives me a "Syntax" Error for the second ...
-4
votes
0answers
22 views

How to connect web service to Microsoft Access 2016

I want to recieve data from a web service in MS Access 2016 and I know I should import it using the External Data tab, in the Import & Link group, and click More to drop down the list of options ...
0
votes
1answer
38 views

MS Access query: Merge multiple columns from multiple rows into single fields [duplicate]

I have one table in MS access 2016. If the ID is same for two rows, I want to merge the Code & Course columns into single columns. So the output should be I have tried functions like STUFF, FOR ...
0
votes
2answers
26 views

Calculated Columns in Access

I have two columns in a table (Access DB): Open_DATE Closed_Date I would like to define a third column in a table which calculates the difference in days taking the difference between the above ...
0
votes
0answers
10 views

Deleting A Data from a query and adding the deleted data to another table in access 2013

I created a table for booking some offerings to my temple. The offerings start from a particular date and end at a particular date. After ending, the data of that offering will be deleted from the ...
0
votes
0answers
21 views

MS Access: Chart in report blank when underlying query has a parameter

I have a report in MS Access 16 with a chart in the Report Footer. The chart and the report have the same data source - a query ("Pipeline Query"). One of the criteria in Pipeline Query refers to a ...
0
votes
1answer
32 views

MS Access VBA, efficient way to enable a button only after all required textboxes contains valid data

My code is working, but I just want to know if there is a more efficient way to achieve the same effect. I have this layout in a form: In my effort to foolproof the record creation process, I would ...
-2
votes
0answers
14 views

Adding button value to listbox in ms-access

my question on the photo and the listitem is the listbox in msacess 2016 and other question how to save changes to the listbox when the end user print the invoice(report)
0
votes
1answer
17 views

Prevent MS-Access from displaying or allowing user to go back to previous record

I have an ms-access form in which the user enters assembly information (component serial numbers, measurements, print revision...etc) I have the form set as: Data Entry = Yes Allow Additions = Yes ...
0
votes
1answer
59 views

c# Login form ( get the information form the sign up form )

I am trying to create an application for a market. I want it to have a sign Up form for normal users so they just can see the products so I want a sign form to insert the users information. Then ...
1
vote
1answer
35 views

Record search in MS Access with recordset.findfirst throws error 3070

I'm trying to build an MS Access database. One of the elements is an autofill in a record management form. Form layout: Note that the Battery ID & Model Number is in one table (referred as ...
0
votes
1answer
31 views

Access report text box only displays 255 characters of a longer query result

I have what seems to be a common issue but the specifics are a bit different than other questions available. Working in a MS Access 2016 database on Windows 10. I have a query performing a UDP ...
0
votes
2answers
23 views

Matching values between 2 tables using IN against a Long Text field

I am currently using Access 2016 and am trying to create a query that is pulling in a different query and a table as its 2 source elements. Below is an example of the structure table: entity ...
1
vote
1answer
34 views

Allen Browne's ConcatRelated() Error 3061: Too few parameters

I am trying to create a list of products at a given warehouse. Allen Browne's ConcatRelated() function seems to be the tried and true method to create lists using when a linked variable is the same, ...
0
votes
0answers
42 views

Microsoft Access Database Engine 2010 Redistributable has to be installed on every machine?

I have created an clickonce application in visual studio 2010. When i publish this so other machines can use it, it comes up with an error message that "The 'Microsoft.ACE.OLEDB.12.0' provider is not ...
0
votes
1answer
45 views

Changes in MSAccess VBA coding

I have been coding in MSAccess since the Win95 days. Over the years, these apps have been upgraded to the latest versions of MSAccess. I am guessing that the change occurred sometime after Access 2003....
0
votes
2answers
30 views

MS Access using Access sql - Null function

Using Null function in access. I have four different reports. All have order numbers in it. Populating Order number in the report A where Order number matches in report B, C & D in separate ...
-2
votes
3answers
34 views

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. ...
0
votes
1answer
38 views

Activate an Open MS Access File to SendKeys With VBA

I am trying to send key strokes to an open Microsoft Acess file so that I can export data to an excel file via the toolbar. How can I activate the open Access file in VBA code so that it is the window ...
0
votes
0answers
16 views

Access 2016 Security Warning Issue

Microsoft Access 2016 Security Warning Disable I am having trouble disabling the Access Security warning Message when a new user is using the database. The concern/issue i have is the login box can ...
0
votes
2answers
29 views

DLookup: Criteria returning blank values

I am trying to create an expression in Access 2016 to return a value from another table when a key is matched from the current table. I am sure it is syntax related, but am at a loss.... I want to ...
0
votes
1answer
36 views

Subform not displaying filtered results initially

I have a form with 2 sub forms: Main form: PaymentDetails Subform 1: UnreleasePayments Subform 2: ReleasedPayments The idea is that the user is able to move payment records between subform 1 and ...
0
votes
0answers
20 views

How do I move a text box in front of a listview control?

I am trying to allow a textbox to expand and cover other features on my form when a user clicks a button (the form itself has most of its real estate taken up so a second click of the button would ...
0
votes
0answers
37 views

Populate list field from multiple tables in Access

I have a Database with the tables "users" and "departments", they are linked by the field "department_ID" in "users". When I create a query "a" to show all users with their department name, it works ...
2
votes
1answer
37 views

Prevent remote users opening database via VPN

I have a client with an ms-access 2016 database split into a front end (each user with their own copy on their machine) and a back end (on the server). Remote workers can successfully use the ...
0
votes
0answers
34 views

Generate an Excel report from the result of an SQL query from a MS Access database

I have a MS Access database and I want to generate a report for each individual customer and all the items that are on loan to that customer. My database is simple. Here are the following tables with ...

http://mssss.yulina-kosm.ru