902 questions with Access Development tags

Sort by: Updated
Updated Created Answers
0 answers

I cannot see my certification appointment in credentials in my profile.

Hi, I have schedule the certification exam on 11/05/2025. I cannot see my certification appointment in credentials in my profile. I want to reschedule it.

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.
902 questions
asked 2025-05-11T09:38:27.3966667+00:00
Pravalika Varikolu 0 Reputation points
1 answer

How do I fix my access form display

I can open a form in design mode and all the fields look great. When I switch to form mode I get a dark green overlaid and I do not see any of the fields

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.
902 questions
asked 2025-05-10T02:23:07.32+00:00
Francis Phelan 0 Reputation points
answered 2025-05-10T04:07:36.66+00:00
DBG 2,376 Reputation points
0 answers

How to work with Attachment data type in VBA

Is it possible to view the size of an attached file in a field of an Access table? For example, using <field>.FileName or <field>.FileType I can view the name or extension of the attached file. Is there a similar feature for file size?

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.
902 questions
asked 2025-05-01T13:44:49.0766667+00:00
Sidnei Botelho 0 Reputation points
4 answers

ACEOLEDB.DLL from Microsoft 365 Apps crash with Exception code 0xc0000005

ACEOLEDB.DLL from Microsoft 365 Apps (at least versions 16.0.14228.20248, 16.0.14430.20006, 16.0.14701.20040 in "C:\Program Files\Microsoft Office\root\VFS\ProgramFilesCommonX64\Microsoft Shared\OFFICE16\") appear to cause an application crash…

C++
C++
A high-level, general-purpose programming language, created as an extension of the C programming language, that has object-oriented, generic, and functional features in addition to facilities for low-level memory manipulation.
3,929 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.
902 questions
asked 2021-12-29T20:18:30.603+00:00
Jmenninkainen 31 Reputation points
commented 2025-03-31T10:36:28.31+00:00
Jmenninkainen 31 Reputation points
2 answers

CopyFromRecordset Automation Error

ExcelSheetPopulate.txtI had been running Office 2016 MSO (16.0.12624.20278) 32-bit for several years. I've been using the attached code in MS Access for the past 5 years without any issue. Suddenly, getting Error 430, 'Class does not support Automation…

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
4,350 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.
902 questions
asked 2025-01-20T15:49:08.4033333+00:00
AlphonseG 216 Reputation points
commented 2025-03-10T14:35:52.7933333+00:00
George Hepworth 10 Reputation points
2 answers

I CANNOT CREATE CALCULATED FIELD BECAUSE OF PROBLEM WITH MaxLocksPerFile

N° Fields I have a database in Access with about 130 fields. ACCESS and LOCATION The Access file is in a shared folder, just because it really is, but only I use it, no one else goes in. PROBLEM When I want to create a calculated field the following…

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.
902 questions
asked 2025-02-18T00:22:04.7733333+00:00
Luis Angel Ñañez Llanos 256 Reputation points
answered 2025-02-19T09:55:06.2533333+00:00
Karl Donaubauer 2,056 Reputation points MVP
1 answer

Use VBA to delete all appointments in a day of Outlook

From MS Access 365 I need to use VBA to automatically delete all appointments for a specific day in the Calendar of Outlook. I can access the specific Calendar using the following command Set nsCalendar = nsMAPI.Folders("Specific Outlook…

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
5,772 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.
902 questions
asked 2025-02-15T07:19:55.55+00:00
John Papaioannou 21 Reputation points
commented 2025-02-17T12:27:57.65+00:00
George Hepworth 10 Reputation points
1 answer

How to fix Automation error Object is not connected to server

I have an MS Access database with a table that has an OLE Object type field. The field stores a PowerPoint slide associated with the rest of the data in the record. I have a form with a bound object frame for the OLE Object field. There is a Button on…

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.
902 questions
asked 2024-12-02T17:17:17.8866667+00:00
William Sessums 0 Reputation points
answered 2025-02-03T18:50:56.7466667+00:00
Courtney Owen 0 Reputation points Microsoft Employee
2 answers

How to program with Edge navigateur object?

How can we use the Edge Navigator control to send a message to copilote and save the information?

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.
902 questions
asked 2025-01-30T15:44:58.8666667+00:00
NGUYEN Alain FG/DACRG 0 Reputation points
answered 2025-01-31T13:23:07.38+00:00
George Hepworth 10 Reputation points
2 answers One of the answers was accepted by the question author.

how to fix "Failed to load microsoft.date.sqlclient version = 5.0.0.0 file or assembly..."

I tried to recreate projects, installed the access engine, added microsoft.data.sqlclient through nuGet, installed various database extensions, watched a lot on the Internet, nothing helped. I need to add an access database. What should I do?

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
423 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.
11,452 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.
902 questions
asked 2025-01-28T12:32:37.71+00:00
Efrem 20 Reputation points
commented 2025-01-29T11:29:53.3633333+00:00
Efrem 20 Reputation points
4 answers

Microsoft Access - Sytax Error in JOIN operation

I am struggling with an access database. I cannot figure this out. I keep getting a "Syntax error in JOIN operation" error. Can someone please help me? Below is the SQL data. SELECT Courses.course_name ,Venues.venue_name …

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.
902 questions
asked 2025-01-26T22:49:43.7733333+00:00
Harley Kronikxz 0 Reputation points
edited a comment 2025-01-28T16:47:56.3233333+00:00
Ken Sheridan 2,851 Reputation points
1 answer

How to set up client permissions on secure shared database

Hi. I am building a database for a person who audits hospitals and so the database is shared, between her and another lady, on a very secure site. The problem we are having is when I program it to do something, like show P1 from a checkbox to say P1 or…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
423 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.
902 questions
asked 2024-06-21T14:37:39.87+00:00
CC 0 Reputation points
commented 2025-01-28T15:16:53.07+00:00
George Hepworth 10 Reputation points
2 answers

CodeContextObject / Converted Macro

I receive the following error: Run-Time error 2467 The Expression you entered refers to an object that is closed or doesn’t exist. And the following line is highlighted in my code: Set objCurrent = CodeContextObject Can anyone assist with me with…

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.
902 questions
asked 2021-03-31T17:47:13.377+00:00
imodett 61 Reputation points
answered 2025-01-19T16:58:23.1033333+00:00
Gustav 717 Reputation points MVP
2 answers One of the answers was accepted by the question author.

Is it possible to connect a Google Forms to a linked Microsoft Access table using VBA code?

Is it possible to connect a Google Forms Survey (URL website) directly to a linked table in a Microsoft Access database and pull the respondents' responses directly into a linked MS table using VBA code? Currently, when respondents submit their responses…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
423 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.
902 questions
Microsoft 365 Publishing
Microsoft 365 Publishing
Microsoft 365: Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.Publishing: The process of preparing, producing, and releasing content for distribution or sale.
688 questions
asked 2023-11-22T14:21:09.4966667+00:00
wire_jp 216 Reputation points
edited the question 2025-01-16T17:35:53.3533333+00:00
TP 118.8K Reputation points Moderator
1 answer

my script is not visible anymore in VBA Access

I do not have access to my own script anymore which I have made for various Access programs. I have carried out a complete virusscan but nothing detected. When I copy my DB file to another computor I can see my code again. How can I solve this problem

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.
902 questions
asked 2024-12-25T10:54:16.24+00:00
Jantje 21 Reputation points
answered 2024-12-26T11:52:30.1666667+00:00
Jantje 21 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.
902 questions
asked 2021-02-05T18:07:19.883+00:00
kidsvavo 1 Reputation point
commented 2024-12-24T00:46:11.9833333+00:00
Warren White 0 Reputation points
3 answers

I need help understanding what this sql query is doing

I am trying to help fix this database but I do not understand what this SQL query is doing. It should be updating the field "Supplier Part Number" in the table "tblSpend" but it isnt doing that. SQL: UPDATE tblSpend SET [Supplier…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 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.
902 questions
asked 2024-12-11T18:17:24.9666667+00:00
Lopez, Ahiezer 236 Reputation points
commented 2024-12-12T22:13:55.6866667+00:00
Erland Sommarskog 120.4K Reputation points MVP Moderator
2 answers

Hello Everyone, I am unable to figure out the difference between ComboBox LimitToList property and ShowOnlyRowSourceValues property in Microsoft Access.

I mean, Is it not true that only what's in the Row Source can be seen in the List? How can you make display something that's not in the Row Source? Thanks for your assistance in advance!

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
423 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.
902 questions
asked 2023-08-24T01:02:04.94+00:00
Shreyas 0 Reputation points
answered 2024-12-12T00:09:18.42+00:00
Ken Sheridan 2,851 Reputation points
1 answer

How to create an access database with photos across multiple years?

I am very new to access and have tried to learn the basics of creating tables, forms, reports etc. I need to create a database with photos. My table contains coordinate points and other info about each point. I have data spanning across years, each…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
423 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.
902 questions
asked 2024-12-05T23:36:49.4633333+00:00
Van 0 Reputation points
answered 2024-12-06T15:19:29.32+00:00
Ken Sheridan 2,851 Reputation points
4 answers One of the answers was accepted by the question author.

How to see more columns in the diplay of a combobox

in an acces form I have a combobox with 5 columns of which one is the bound colomn. In the pulldown menu I see these 5 columns. if I click I only see one column item in the display. How can I see more columns? Maybe the textcolumn property should be…

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.
902 questions
asked 2024-12-04T11:58:49.2966667+00:00
Jantje 21 Reputation points
answered 2024-12-04T20:20:42.2366667+00:00
Jantje 21 Reputation points