822 questions with Access Development tags

Sort by: Updated
Updated Created Answers
0 answers

Access 2016 Public Sub error - User Defined Type Not

Upgraded from Access 2013 to 2016 which uses a custom ribbon. In the Main Module, I declare a Public Sub as follows which bombs out right from the get go saying User -Defined Type Not defined. Any thoughts? 'Callback for Form OnButtonPress Public Sub…

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.
822 questions
asked 2021-02-23T20:53:17.353+00:00
Ladydraper 21 Reputation points
0 answers

DLookUp() in query with criteria matching a field of the queary

Is it possible to use DLookUp inside query and have the criteria match a a field in the query.? The field being a string.

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.
822 questions
asked 2021-02-23T03:21:01.233+00:00
imodett 41 Reputation points
1 answer One of the answers was accepted by the question author.

Exporting an XSL, XML file formats from Microsoft Access to Visual Studio IDE

I may have successfully exported a Microsoft Access form file into an XSL, and an XML file (two files) to be exact. What's next is that I want to import them into the Visual Studio IDE using C# programming techniques. Can that be done? If it can…

Windows Forms
Windows Forms
A set of .NET Framework managed libraries for developing graphical user interfaces.
1,831 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,268 questions
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.
822 questions
asked 2021-02-21T03:52:28.673+00:00
JohnCTX 636 Reputation points
commented 2021-02-22T02:29:22.253+00:00
Albert Kallal 4,651 Reputation points
1 answer One of the answers was accepted by the question author.

Exporting Access Forms to Microsoft Visual Studio 2019

I want to know currently, if it is possible to Export an Access Form along with its controls to Visual Studio 2019? If it is possible then can it be done using C#? Regards, JohnCTX

C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,268 questions
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.
822 questions
asked 2021-02-21T02:40:10.893+00:00
JohnCTX 636 Reputation points
accepted 2021-02-21T14:46:07.137+00:00
JohnCTX 636 Reputation points
9 answers

Why doesn't Access quiery work for the year 2021?

I have an access query that I need to pull all the records for a certain month and year. It works fine for all years that are on the list of records except it will not query for the year 2021. Why?

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.
822 questions
asked 2021-02-05T18:07:19.883+00:00
kidsvavo 1 Reputation point
answered 2021-02-19T17:27:03.637+00:00
kidsvavo 1 Reputation point
2 answers One of the answers was accepted by the question author.

Pass-thru query ODBC error

I have a DSN that connects my Access database to a SQL Server database called "Hotlist". I then created a pass-through query that works fine when I apply the DSN interactively, but throws an ODBC-Connection Failed error when I run the same…

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.
822 questions
asked 2021-02-14T17:12:28.873+00:00
Darrell Burns 141 Reputation points
commented 2021-02-15T20:36:07.65+00:00
Darrell Burns 141 Reputation points
5 answers One of the answers was accepted by the question author.

MS ACCESS Report Design Detail Section

Hi Experts I am designing an invoice in MS Access. I need to make the height of detail section fixed so that the height remains same. Mainly i want the report footer to be positioned a little below. Currently if there is one row the detail section…

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.
822 questions
asked 2021-02-10T08:49:04.73+00:00
MS-LovesAccess 96 Reputation points
answered 2021-02-15T06:14:54.75+00:00
MS-LovesAccess 96 Reputation points
0 answers

Access 2019 Date function problem

The Access 2019 fail to using date function, such as date(), year(), month(). Is it some I missing or needed attention?

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.
822 questions
asked 2021-02-14T06:59:59.507+00:00
Mr. LAI Long Chau Vitus 1 Reputation point
commented 2021-02-14T20:02:14.517+00:00
Albert Kallal 4,651 Reputation points
0 answers

Query search problem in Access 2019

When I create a new file using query search by current date or by year function in Access 2019, there’s a pop-up window immediately came out. The meanings something like : Visual Basic Module contains a syntax error. However, when I use old version file…

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.
822 questions
asked 2021-02-12T08:47:47.727+00:00
Mr. LAI Long Chau Vitus 1 Reputation point
0 answers

Creating a Family Tree with photos in MS Access Report or Form

Has anyone ever created a MS Access Report or Form that has a family tree hierarchy with photos and text? I can do it with a tree view without photos, but to arrange the photos between lines with levels of descendants is eluding me. Any help would…

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.
822 questions
asked 2021-02-11T02:06:51.587+00:00
Jeff Harding 41 Reputation points
0 answers

MS Office with Access on Remote Desktop Server

Hello, A Customer asked to install a Remote Desktop Server, but MS Office must have Access included. Could the Volume License "Office Professional Plus" (79P-05729) be a solution ? And which Office 365 subscription could be a suitable…

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.
822 questions
asked 2021-02-09T17:48:30.063+00:00
Bernard Coudron 1 Reputation point
commented 2021-02-10T02:07:20.727+00:00
Eleven Yu (Shanghai Wicresoft Co,.Ltd.) 10,681 Reputation points Microsoft Vendor
3 answers

Log in form in visual basic 2019.

I want to create a login form in access database program which allows each user to create his username and password and resetting password via forgot password link.

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.
822 questions
asked 2021-02-03T13:23:11.517+00:00
Sheelnath Kekre 121 Reputation points
answered 2021-02-05T12:55:46.88+00:00
Sheelnath Kekre 121 Reputation points
1 answer One of the answers was accepted by the question author.

MS Access Date Format

Hello everybody, I have a simple selection query with just two fields: 1) Date (dd/mm/yyyy format), 2) # of Items (net daily increase) and I need to add a third field with the cumulate # of items up to that date. Using the DSum() function 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.
822 questions
asked 2021-02-04T09:40:02.637+00:00
GMax64 96 Reputation points
accepted 2021-02-04T10:04:38.963+00:00
GMax64 96 Reputation points
2 answers One of the answers was accepted by the question author.

Microsoft Access 2016 syntax error when openining Design View in queries

Dear All, I have the below error messages when I try to open a Design View in a few Queries. I tried to repair Office 2016, uninstall and reinstall with no avail. I copied the Access program to another compter and run it. Everything…

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.
822 questions
asked 2021-01-29T16:07:55.79+00:00
William 361 Reputation points
accepted 2021-02-03T09:07:50.74+00:00
William 361 Reputation points
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.
822 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.
822 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.
822 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.
822 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 4,651 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.
822 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,621 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.
822 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 4,651 Reputation points