892 questions with Access Development tags

Sort by: Updated
Updated Created Answers
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.
892 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,213 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.
892 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 114.6K Reputation points MVP
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.
420 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.
892 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,846 Reputation points
0 answers

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.
892 questions
asked 2024-12-02T17:17:17.8866667+00:00
William Sessums 0 Reputation points
edited the question 2024-12-09T13:39:37.74+00:00
William Sessums 0 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.
420 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.
892 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,846 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.
892 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
2 answers One of the answers was accepted by the question author.

Modifier LISTE SHAREPOINT depuis MS ACCEESS

Bonjour, j'ai une liste SHAREPOINT que j'alimente/consulte, etc... sans problème depuis Microsoft ACCESS 2019. Mon problème est le suivant: Quand je lance une requête de MISE A JOUR pour mettre à jour ma liste SHAREPOINT ou une requête de SUPPRESION pour…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
420 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,999 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.
892 questions
asked 2024-11-29T13:16:59.3866667+00:00
Youssef Taoudi 45 Reputation points
answered 2024-12-02T14:51:51.5333333+00:00
Youssef Taoudi 45 Reputation points
1 answer One of the answers was accepted by the question author.

SHAREPOINT and MS ACCESS 2019

Hello, I have a SHAREPOINT LIST that I feed/consult, etc... without problem since Microsoft ACCESS 2019. My problem is the following: When I launch from ACCESS an UPDATE query to update my SHAREPOINT list or a DELETE query to empty my SHAREPOINT LIST,…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
420 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,999 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.
892 questions
asked 2024-11-29T13:21:18.3333333+00:00
Youssef Taoudi 45 Reputation points
commented 2024-12-02T01:22:19.9766667+00:00
AllenXu-MSFT 22,156 Reputation points Microsoft Vendor
2 answers

Can't update table that use large number data type in VBA

I have enabled large number data type in access , So I can store number that larger than long type. This is my test code. Private Sub test() Dim rs As New ADODB.Recordset Dim size As LongLong rs.Open "Select * From LocalFiles ", _ …

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.
892 questions
asked 2024-11-26T12:46:10.83+00:00
Chokchai Te 0 Reputation points
answered 2024-11-29T15:47:32.4833333+00:00
Chokchai Te 0 Reputation points
0 answers

My microsoft365 develop account is can’t sigin

My microsoft365 develop account is can’t sign in ,because the device system used for 2FA verification is damaged, and I had no choice but to reinstall the system. My 2FA verifier is also lost, so I hope you can help me set up a new 2FA…

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.
892 questions
asked 2024-11-29T11:55:09.65+00:00
你太美 鸡 0 Reputation points
1 answer

Add Control in Code

How we can Add New Control in VBA Code in MS Access

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.
892 questions
asked 2024-11-24T10:55:24.35+00:00
hamid reza motamedi 0 Reputation points
answered 2024-11-24T18:13:24.9366667+00:00
Karl Donaubauer 2,056 Reputation points MVP
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.
892 questions
asked 2021-02-10T08:49:04.73+00:00
MS-LovesAccess 101 Reputation points
commented 2024-11-18T05:12:27.7733333+00:00
kalpesh italiya 0 Reputation points
0 answers

Change in VBA library for Excel.workbook?

I have an Access DB developed over several years in which there is a VBA module for exporting selected tables to a single, multi-worksheet Excel file. After a Windows update this morning, the VBA module fails with a compilation error over this code…

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.
892 questions
asked 2024-11-13T17:50:24.2933333+00:00
Mike Surridge 0 Reputation points
commented 2024-11-15T12:34:32.4566667+00:00
Mike Surridge 0 Reputation points
1 answer

I can't access my student/business account

I recently lost access to the device where I had Microsoft Authenticator installed and configured for my business account. With a new device in hand, I tried to configure this account again on this new device, and then the problems started. I can no…

Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
3,292 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
874 questions
Windows 365 Business
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.
892 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
22,645 questions
asked 2024-11-11T12:10:21.0066667+00:00
Eduardo S.Ferreira 0 Reputation points
commented 2024-11-15T10:45:11.9933333+00:00
BANDELA Siri Chandana 770 Reputation points Microsoft Vendor
1 answer

How to view .SNP file

I have a number of files in .SNP format, which originally could be opened with the Microsoft Snapshot Viewer which was part of Microsoft Access. I cannot find a safe version of that program to download. How can I view these .SNP files now or convert them…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
420 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.
892 questions
asked 2024-11-02T12:44:18.7533333+00:00
Philip Cox 5 Reputation points
edited a comment 2024-11-02T16:39:36.0466667+00:00
Viorel 118.6K Reputation points
3 answers One of the answers was accepted by the question author.

How do list results of a column in a table in one field separated by commas in MS Access

I would like to know how to get a column into a query field. Similar to how in Access if you use the multi-value field in MS Access. However, i do not wish to use the mutli-value. For example, if I had a table column1 with A C D F G (one…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
420 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.
892 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,215 questions
asked 2024-10-16T18:48:02.2+00:00
imodett 61 Reputation points
edited the question 2024-11-01T07:32:19.25+00:00
Emi Zhang-MSFT 26,606 Reputation points Microsoft Vendor
2 answers

Two finger scrolling not working in Access

Two-finger scrolling on a touchpad is not working on an Access form. It works OK in Excel, so it's not the computer or the mouse/touchpad drivers. It's also fine on the Navigation Pane in Access. If I open a table, it does scroll but is jerky and…

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,373 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.
892 questions
asked 2023-03-29T10:34:43.46+00:00
john fallows 15 Reputation points
commented 2024-10-31T22:15:28.35+00:00
SonofTheAlmighty 0 Reputation points
0 answers

Access to Word Document

Office 365. I have an Access report with one image (logo) and 4 subreports as a Print Preview. I need to save it as a Word .docx.  Would it be best to just use the export to word command on the Print Preview tab or should I try to set it up as a merge…

Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
908 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.
892 questions
asked 2024-10-31T13:47:49.46+00:00
Maxine Nietz 1 Reputation point
2 answers

For MS Access Error Message: ODBC call failed. String or binary would be truncated #8152

Dear all, I have a MS Access DB Form (mask) and a "comments" field in the mask connects to a SQL Server db table field of 2500 length. I extended the length to 3000 char as per request and refreshed the connection, but the user still cannot…

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.
892 questions
asked 2024-10-11T11:50:23.4233333+00:00
Carrera_Carazas,Luis_Felipe (GBS GES) BIG-DE-I 0 Reputation points
answered 2024-10-11T18:54:03.47+00:00
Tom van Stiphout 1,696 Reputation points MVP
3 answers

How do I fix the OLE Object in Access Error 3118?

Cannot join on Memo or OLE Object <name>. (Error 3118)

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
420 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.
892 questions
asked 2024-10-03T17:53:14.9933333+00:00
April Kurtz 0 Reputation points
edited an answer 2024-10-05T15:32:38.2266667+00:00
Ken Sheridan 2,846 Reputation points