848 questions with Access Development tags

Sort by: Updated
Updated Created Answers
1 answer

Refresh Report within Form

I have a form with a few data entry fields, with a report below. The idea is that as the user enters data, the report gets updated with the new records. I am having difficulty getting the report to "refresh" after the user selects a "Save…

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
848 questions
asked 2021-01-29T20:09:06.13+00:00
Kris Schmidt 1 Reputation point
answered 2021-02-02T23:23:56.593+00:00
C Data 6 Reputation points
2 answers

New to SQL in Microsoft Access and having major issues

I am tasked with tracking Overtime hours worked by Department/Employee. Our work week is 35 hours, first 5 additional is Straight Time, any additional is OT (at time and a half). Tables collect Week of Date, Employee, # of OT Hours and Department. I…

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
848 questions
asked 2021-01-31T20:49:37.337+00:00
Mark Davis 1 Reputation point
answered 2021-02-02T23:13:20.447+00:00
C Data 6 Reputation points
3 answers One of the answers was accepted by the question author.

Data type mismatch when querying Tax ID

I've created a simple query to look up customers by Tax ID. Since the users don't always insert the hyphens in the right place, I strip out the hyphens using the REPLACE function. But the query throws a Data Type Mismatch error (see example). I've tried…

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
848 questions
asked 2021-01-26T18:02:38.297+00:00
Darrell Burns 141 Reputation points
accepted 2021-02-02T11:57:36.587+00:00
Darrell Burns 141 Reputation points
1 answer

Can't Open ACCDE made with Access 2016 (32-bit) | Eine mit Access 2016 erstellte ACCDE (32-Bit) lässt sich mit Access 2019 nicht öffnen.

I made an Access application (ACCDE) for a user using Access 2016 (32-bit) that uses VBA and connects to an MS SQL-Server database on our network via ODBC. It used to work, but the user can no longer open it. The first error message the user reported is…

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
848 questions
asked 2021-01-29T16:45:19.677+00:00
Bryant, Curtis 1 Reputation point
answered 2021-02-02T02:29:06.203+00:00
Albert Kallal 5,226 Reputation points
1 answer

accessing adobe acrobat dc

i want to open a pdf in adobe acrobat dc with a link from access vba, but it opens in edge. is it possible

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
848 questions
asked 2021-01-30T11:49:55.847+00:00
Griet De Groote 1 Reputation point
answered 2021-01-30T14:48:14.807+00:00
Tom van Stiphout 1,701 Reputation points MVP
2 answers

ACCESS VBA - "DoCmd.RunCommand acCmdNewObjectAutoReport" doesn't add all fields to Report

Hi, I have been trying to create an access report from an existing table using below VBA code. It creates the report successfully, But the issue is it doesn't add all the fields from the table to the report created. It is adding only 15 fields. I am…

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
848 questions
asked 2021-01-28T15:01:40.57+00:00
Vikhanasa Manojav Agnihotram 1 Reputation point
commented 2021-01-29T01:09:42.287+00:00
Albert Kallal 5,226 Reputation points
0 answers

How To Reference Hidden Field in Combo Box using VBA

Hello: I have an Access form with a combo box. It has two fields, a product ID and a Product name. The Product Id is hidden from the drop-down. How can I access the hidden field using VBA? Thanks, Rich Locus

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
848 questions
asked 2021-01-25T21:20:32.303+00:00
Rich Locus 61 Reputation points
commented 2021-01-27T01:38:53.207+00:00
Rich Locus 61 Reputation points
1 answer

How to write access VLOOKUP formulas as field default value based on another table

For example, I have two Access tables (backend database): TableUser and TableWorkingHours For TableUser, Username is unique. I understand that I should not have FirstName and LastName in TableWorkingHours. For some reasons, I don't feel…

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
848 questions
asked 2021-01-23T17:07:33.7+00:00
VAer-4038 761 Reputation points
answered 2021-01-23T17:46:54.527+00:00
Tom van Stiphout 1,701 Reputation points MVP