Recently Active 'ms-access-2016' Questions - Page 5 - Stack Overflow

Questions tagged [ms-access-2016]

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

Filter by
Sorted by
Tagged with
-1
votes
2answers
49 views

Is it possible to us MSAccess to insert data through an external linked View in SQL Server? [duplicate]

I'm using MS Access 2016 and SQL Server 2012. I have single table with a schemabound view over the table. Our design was to allow our users to insert data through the view so we can do some id lookups ...
0
votes
1answer
239 views

To paste a macro from Stack Overflow into Access

My question seems to be very silly, but I haven't found solution myself. Is there a way to simply paste a macro (example) from Stack Overflow in Access? Or, alternatively, paste it from Access to ...
0
votes
1answer
30 views

MS Access 2016 left join creating duplicate records

I'm new to MS Access and need to add the Group Name field from table 2 to table 1 (see below). Table 1 lists all invoice line item transactions. Table 2 lists pricing categories by location and boat ...
0
votes
0answers
6 views

MS Access - Make different subforms appear or hide depending on a value in the mainform

I have an accounting database with a form for transaction entry. there is a field "type" for the type of transaction. I have different extra fields that need to be shown/editable depending ...
-1
votes
1answer
44 views

How to find top cpu utilized queries in MS Access database?

I want to find those queries in MS Access which are utilizing the CPU mostly and put them in a table in descending order. I have checked the system tables of MS Access database, but can't find any ...
1
vote
2answers
1k views

Starting Outlook 2016 from MS Access 2016 VBA triggers “another program is using Outlook” and dies

I use below code in MS Access 2016 to start an instance of Outlook 2016: Dim appOutLook As Object On Error Resume Next Set appOutLook = GetObject(, "Outlook.Application") On Error GoTo 0 ...
0
votes
1answer
46 views

MS ACCESS : On a subject form, how can I highlight a required control IF AND ONLY IF the user misses it (an error is thrown)

I have built a subject form and would like to find a way to highlight a textbox control that is required (it is paired to a required field) IF AND ONLY IF the user fails to enter it. I know that there ...
0
votes
1answer
114 views

Why does my VBA procedure sometimes stop in debug mode?

I have a button click event in an Access form that sometimes opens the VBA editor with the 'On Error...' line highlighted as if it is in debug mode. I can F5 to continue the rest of the procedure and ...
1
vote
2answers
869 views

Remove time from DateTime field

I am very new to access and have been trying to create what I am told is a pretty ambitious database, especially for a noob. My first problem is: After hours of searching, reading and not finding a ...
1
vote
0answers
27 views

Microsoft Access 2016 - Insert SQL query not adding in correct row count

I have a Query "NP_Compare_SPC" and a Table "NP_Compare_Table". NP_Compare_Table is currently empty and I am trying to insert the full contents of the query into the table. When ...
0
votes
1answer
53 views

Access VBA to import multiple csv files using import button

I am trying to create a form with a dialogue box, such that it allows users to provide the location of the file and import it to the database. I have provided the import specification as well as the ...
0
votes
1answer
60 views

Take list box selection, add value to other list box without allowing duplicates

I have two list boxes on a form I am making. The first list box is linked to a table with various company names. The goal I am after is after double clicking a companies name, the value is inserted in ...
0
votes
1answer
35 views

Access 2016 - Return TRUE if Item exists in Table, False if Item is Missing

Ok, I have two tables. 1 lists a bunch of courses and their details. 1 lists a bunch of curriculums and their associated connections. I need to create a query that will list the curriculum name, LIST ...
1
vote
1answer
18 views

Access Textbox control source outside current report

I am creating a Report in MS Access 2016. I want textboxes showing a summary of data from other tables - without actually showing rows of those tables (no subreports if possible). For example, I have ...
0
votes
1answer
36 views

How to make a summary of every duplicate value in a new column?

I need a column in my table (Microsoft Access) that has a summary of the ID of every duplicate value in the table. The table has a parent and child type, the parent type needs the summary of every ...
0
votes
0answers
35 views

MS Access report: Lines within Detail section not overflowing to second page

First time poster and I'll hopefully provide enough information to be able to get an answer that will help me. I'm using MS Access 2016 and generated a somewhat simple report from a table that is ...
0
votes
1answer
216 views

MS Access Displayed v. Saved Value in Combo Box

I have a simple database with two tables and one relationship between them:Employees, Managers, Relationship. Each employee has exactly one manager, but each manager can manage multiple employees. For ...
0
votes
3answers
789 views

VBA generating a random unique alpha-numeric string

I need to create a Unique-ID (string) for each record as I am developing an application which allows users to access a unique URL like: http://URL.com/BXD31F The code below works to create the ...
0
votes
0answers
18 views

How do I Resizie MS Access Form Textboxes and labels using VBA

I am working on a simple MS Access 2016 database. I have a form with many textboxes and labels and I would like all of the textboxes and labels to be the same size, respectfully. I would like to be ...
0
votes
1answer
1k views

Access form cascading combo box shows nothing in drop down menu

I am trying to create a data entry form with cascading combo boxes to limit the users options. I had it working for a bit, then it decided to quit. I could just be overthinking it all though. There ...
0
votes
2answers
141 views

Access 2016 - link table from Access 2019 failed: “Cannot read data in <table_name>”

I am developing an Access application on Access 2019. I have split my project into a frontend and backend. I am trying to deploy the application to a user that is using Access 2016. When linking the ...
0
votes
1answer
47 views

MS Access 2016 VBA Error “Invalid Operation” It is showing the error with the First IF statement in the second CASE

Option Compare Database Option Explicit Public Function Day1DU(InvFullBP As Single) As Single Dim Current_Frm As Form Set Current_Frm = Screen.ActiveForm Dim CalcDuAdjs As Double, HBCO As Double, HBP ...
0
votes
0answers
13 views

Access Charts New Page

First post here, hope I'm doing it right. I have looked everywhere on google, but I must be asking the question wrong. I have a fairly simple chart (screen shot attached), but I want each category to ...
0
votes
1answer
8 views

Update several Tbl Fields based on Start/End Dates

Good day to everyone! Hope all is well! I am looking to run an update query or a group of queries that looks at my Date_Start and Date_End to determine if the Units (quantity of the respective record) ...
0
votes
1answer
47 views

Error 424 when concatenating fields in a VBA SQL statement

I wrote the following SQL statement in VBA, but I'm getting Error 424 ("Object Required") when I go to execute this statement at the string variable strSQL3 (the VBA editor just highlights ...
0
votes
1answer
48 views

MS Access issue with subform not populating properly

I am having an issue with a subform that I am filtering with a Combobox. when I created my example with a blank form the setup works properly, but once I add the data source to the form the subform ...
0
votes
0answers
22 views

How to create sequential ID numbers in Access 2016 that will be continued from previous numbers of current data?

My data is being taken from Excel Tables and a messy Access Database. I have cleaned up the data using PowerQuery in Excel. As such the information going into the creation of a new functional ...
1
vote
1answer
24 views

SQL string in access VBA not behaving as expected

I have a bit of access VBA that for the life of me, I cant work out what is wrong. First off, here is the offending section of code, and I'll explain what I want and what it's doing below. ...
0
votes
0answers
66 views

How to stop MS Access 2016 form text box scroll bars from resetting to the top when clicking on another object?

First post woo! I am working in MS Access 2016 and have forms with various text boxes and subforms. The text boxes are intended to contain paragraphs of text. I use the information in the text boxes ...
0
votes
0answers
19 views

Trying to append data that doesn't exist in one table and into another in VBA and getting a syntax error

I am trying to use VBA to run an INSERT INTO ... SELECT query to append data that is not in one table and put it in my destination table. I tried running the following query, but I'm getting a rather ...
2
votes
1answer
121 views

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

Access: How to sum up fields of multiple tables in a query?

I have a mother table (tblMother) which consists of these fields: id, text And I have multiple child tables: tblChildOne: id, motherID, value tblChildTwo: id, motherID, value tblChildThree: id, ...
0
votes
1answer
144 views

How to convert recordset.field to a string

I am currently attempting to compare certain values in a column from a query in access to a vector of strings to look for a match between any two values. I used recordset.fields("column1") ...
0
votes
0answers
20 views

Dragging to reposition or resize controls in design view not behaving with a smooth effect

I have a form which holds a few textboxes and labels. I am trying to improve the design of the form in design view but: When I copy and paste a control in the same form, the control jumps to a ...
0
votes
1answer
242 views

Access VBA code to go to a specific record on another form via selecting it in a list drop down combo box

I have a form with a combo box with a list of jobs located on a different form all with their own unique record. I would like to be able to click the drop-down of the combo box, select a specific ...
0
votes
1answer
22 views

Access/SQL: How can I check if in a table all duplicates (same date) have a value of 0 except one?

I have a table in Access (tblExample) which consists of the fields ID, tripID, day and value. This table is edited by a form. When the user closes the form Access should validate the entries made. It ...
0
votes
1answer
47 views

Single form to create multiple SKU's from user options

This is complicated and difficult to explain, but here it goes. I have created a db that works just fine. It is a time saver, but not efficient for the user. I have a form for the merchandise where ...
0
votes
0answers
14 views

How to store image path in ms access and fetch image in c#.net picturebox

I have created an Employee Management System in C#.NET. I want to fetch images and display them in a picturebox and store the path of the images into a Microsoft Access 2016 database. I want to ...
0
votes
0answers
71 views

How to set column defaults for linked tables?

In my access 365 database, I am linking some tables of my sql server 2017. An example table in SQL Server: CREATE TABLE pet ( ID INT NOT NULL, name VARCHAR(255) DEFAULT 'noname', age INT ...
-1
votes
1answer
25 views

Update query - Find the youngest date and update another value

I have an access table tblExample with these fields: ID, tripID, dates, value. Now I am looking for an update query in SQL which achieves this: Take the records where tripID = 2. From all of them take ...
1
vote
1answer
30 views

How to encrypt Access with password using code?

I created a Deploy Access file which I use to deploy my production Access file. This re-links tables to production SQL server, incorporates disabling use of Shift, add new version number.... I need ...
-2
votes
1answer
42 views

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

DoCmd.TransferSpreadsheet acImport in MS Access issue

I'm using DoCmd.TransferSpreadsheet acImport to import numbers to access table. The range of numbers: from 0 to 5000. The numbers are different, it could be 0.00034 and 1000.001 so I put the Double, ...
0
votes
0answers
46 views

Problem Converting Fiscal Year to Calendar Dates

I need help using a query to convert Fiscal year to Calendar Year. For Example, I have the Fiscal_Year column and Fiscal_Quarter Column, as shown below Fiscal_Year Fiscal_Qtr Calendar_Year FY21 ...
-2
votes
1answer
25 views

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. ...
-4
votes
2answers
278 views

Where is code I get in MS ACCESS in MDB or MDE file extension [closed]

I m newly to the MS access, I didn’t getting where is the code see and edit. So I can login to my application. When try open the my application in .MDE in MSAccess I am getting authorisation error->...
0
votes
1answer
26 views

access 2016 append multifield to one field

[![enter image description here][1]][1]good day to you all. I have a table with some field like attached file T_Jadwal2.jpg. https://i.stack.imgur.com/mPuBg.jpg I need the the table insert to other ...
0
votes
1answer
16 views

MS Access Combobox Row Source Issues

Have not been able to find an answer to this issue... This is my Value list Row Source Homeroom;Period 2;Period 3;Period 4;Period 5;Period 6;Period 7;Advisory When I open the form...Only every other (...
0
votes
0answers
8 views

MS Access Query returning items sold one year from purchase date

I need help writing a query in access that will return name of the merchandise sold in less than a year from the date they were purchased for sale. Below is part of the data I'm using. Brand Price ...
0
votes
2answers
25 views

Delete query in SQL (Access) in conjuction with dependent data?

I know this is a very basic question but I am unable to get it done. Just started to learn more about databases. I have two tables: tblFoodAllowance and tblTravelDays. tblFoodAllowance consists of ID, ...

1
3 4
5
6 7
25