395 questions with Access tags

Sort by: Updated
1 answer

How to suppress a dialog box, shown below

Office 365. Have a word doc that is merged to a query in access, using the command: MergeSingleWord "C:\Users\nevadamax\OneDrive\Documents\BudgetCorp\NewBudgetCorpDocs", True Where MergeSingleWord is a procedure: Public Function…

Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
859 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
395 questions
asked 2024-10-10T18:35:50.56+00:00
Maxine Nietz 1 Reputation point
commented 2024-10-21T02:32:56.1133333+00:00
Jiajing Hua-MFST 10,155 Reputation points Microsoft Vendor
1 answer

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.
395 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.
879 questions
asked 2024-10-16T18:48:02.2+00:00
imodett 41 Reputation points
answered 2024-10-16T20:24:14.0433333+00:00
Karl Donaubauer 1,816 Reputation points MVP
0 answers

I am trying to fill up fields on a document in word from my access database and I keep getting errors. I have added an image that shows me an invalid merge field. Kindly assist, as this is quite urgent ans important. Any help is appreciated. Thanks!

I am trying to fill up fields on a document in word from my access database and I keep getting errors. I have added an image that shows me an invalid merge field. Kindly assist, as this is quite urgent ans important. Any help is appreciated. Thanks! I…

Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
859 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
395 questions
asked 2024-10-15T20:59:13.9266667+00:00
Jan Banker 0 Reputation points
commented 2024-10-16T06:48:03.83+00:00
Emi Zhang-MSFT 25,156 Reputation points Microsoft Vendor
0 answers

What can I do if there is no answear after submitting the verification form? How can I get back my account?

My hotmail account is blocked by Microsoft. I have submited the form for verification. It was promised that the result will arrive to my contact e-mail account in 24 hrs. It was 3 days ago, but no answer. What can I do if there is no answear after…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
395 questions
asked 2024-10-12T19:07:20.1766667+00:00
TamTamTam1 0 Reputation points
0 answers

Column Designation error

I have a list box (ERPNewOrderList) on a form (AddNewOrders). The rowsource for the list box is a query: Column(0): SONo: [SalesOrderID] & "." & [SOLineNbr] where [SalesOrderID] datatype is ShortText and [SOLineNbr] datatype is Number…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
395 questions
asked 2024-10-11T21:13:09.46+00:00
Maxine Nietz 1 Reputation point
0 answers

Error Message: Grant Access - Additional Permissions are needed to access the following file

The last update of Microsoft 365 has screwed up my computer and I cannot access the files that I have created with Word. Please help! I am using version 16:89.1 of Office.

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
395 questions
asked 2024-10-05T17:18:19.36+00:00
Dick Cain 0 Reputation points
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.
395 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.
879 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,841 Reputation points
2 answers One of the answers was accepted by the question author.

Access error "This database is in an unrecognized format"

When open a Access file, get the error "This database is in an unrecognized format". Can anybody help?

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
395 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,156 questions
asked 2024-09-30T15:39:00.43+00:00
88 903 140 Reputation points
accepted 2024-10-02T00:12:09.06+00:00
88 903 140 Reputation points
1 answer

graph.microsoft.com api to raise group access request that can though myaccess.microsoft.com approval process

I want to use myaccess.microsoft.com programmatically. but it do't have apis, it say that i can use graph.microsoft.com api . but when i am using graph.microsoft.com api , it give below error. i want to use graph.microsoft.com api to raise group access…

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
12,115 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
395 questions
asked 2024-09-17T20:49:55.56+00:00
Garothaya, Sanjay 0 Reputation points
commented 2024-10-01T09:37:48.44+00:00
CarlZhao-MSFT 42,051 Reputation points
4 answers One of the answers was accepted by the question author.

How do I close orphan database connections?

The last step in my Access application (before DoCmd.Quit) is to close the connection to the backend database on the network drive, as follows: This has always worked until one of the workstations was upgraded to Windows 11. Now when that workstation…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
395 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.
879 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,156 questions
asked 2024-09-08T16:49:41.33+00:00
DarrellDoesData 20 Reputation points
edited the question 2024-10-01T07:20:27.4666667+00:00
Emi Zhang-MSFT 25,156 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

MS Access 2021 not reading DSN Entries from 32 bit ODBC

I have created a few DSN using the 32-bit ODBC app located in C:\Windows\SysWOW64\odbcad32.exe Now I open a new MS Access 2021 file and intend to link database tables using the ODBC DSN. However, when I use the Menu Options New Data Source->ODBC Data…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
395 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,156 questions
asked 2024-09-09T15:08:10.2966667+00:00
Sumeet Gupta 20 Reputation points
edited the question 2024-10-01T07:19:29.12+00:00
Emi Zhang-MSFT 25,156 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

Within Microsoft Access 2019 is there a way to see or script out all Tables definitions keys/constraints/indexes, etc...?

Hello, within Microsoft Access 2019 is there a way to see or script out all Tables definitions keys/constraints/indexes, etc...? Was given an Access DB and need to migrate and need to know if they are all simple straight forward stand alone Tables or if…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
395 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.
879 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,156 questions
asked 2024-09-11T18:02:58.09+00:00
techresearch7777777 1,861 Reputation points
commented 2024-10-01T07:04:13.33+00:00
Emi Zhang-MSFT 25,156 Reputation points Microsoft Vendor
1 answer

Cannot Access Admin Account

Hi I have an Organization and an Admin account here. I just pick up my wife from School and when I got back. I have logged out to my Admin account but the users I created using that account are still accessible. Please let me know how can I get back…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
395 questions
asked 2024-09-30T12:19:08.7833333+00:00
Deane Marwa 0 Reputation points
answered 2024-09-30T13:35:55.0866667+00:00
NoOneCan 250 Reputation points
1 answer

Importar datos - Opción desaparecida de Excel y Outlook - Microsoft Office Profesional Plus 2019

Hasta ahora no me había percatado que en OUTLOOK ha desaparecido la opción de IMPORTAR DE OTROS PROGRAMAS O ARCHIVO, los archivos de ACCESS y en EXCEL ha no está la opción de OBTENER DATOS desde un documento PDF

Outlook
Outlook
A family of Microsoft email and calendar products.
3,901 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,919 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
395 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,156 questions
asked 2024-09-19T16:03:58.1433333+00:00
Angels Ferrer 0 Reputation points
commented 2024-09-30T01:23:04.1766667+00:00
Joan Hua-MSFT 2,405 Reputation points Microsoft Vendor
0 answers

MS ACCESS 2021

/ functions in MS Access Filed properties in tables and most useful / important features

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
395 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.
879 questions
asked 2024-09-26T04:13:47.1466667+00:00
Saleem2148 0 Reputation points
commented 2024-09-26T04:15:23.8166667+00:00
Saleem2148 0 Reputation points
1 answer

showing coonection string window

how can i connect MS Access database file, why i am getting this type of window while adding data base connection. there is no browse button to connect my file.

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
395 questions
asked 2024-09-23T16:20:59.6733333+00:00
Abhijeet Todkari 0 Reputation points
commented 2024-09-24T19:01:10.8133333+00:00
Abhijeet Todkari 0 Reputation points
0 answers

there is no browse button to link the data base file

why i am getting this window while adding MS access database file, there is no browse button to link the data base file, please help.

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
395 questions
asked 2024-09-23T16:35:11.7133333+00:00
Abhijeet Todkari 0 Reputation points
edited the question 2024-09-24T03:33:39.83+00:00
Anna Xiu-MSFT 29,096 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

index or primary key cannot contain a null value!

Hi, I'm just trying to update a previous table from a query and I'm getting the above mentioned error. What should I do? Best, Nash

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
395 questions
asked 2023-05-26T17:43:52.9166667+00:00
Nagesh Aragam 20 Reputation points
commented 2024-09-23T17:51:02.04+00:00
Nackalea Smith 0 Reputation points
2 answers One of the answers was accepted by the question author.

Error - Requested session access is denied

I'm having trouble logging into my virtual machine using an authorized local user account with all the necessary permissions. I keep receiving the error message "The requested session access is denied". However, I am able to log in successfully…

Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,927 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
395 questions
Remote Desktop
Remote Desktop
A Microsoft app that connects remotely to computers and to virtual apps and desktops.
4,574 questions
asked 2023-07-05T15:30:52.96+00:00
Megha Goushal 30 Reputation points
commented 2024-09-20T02:55:45.48+00:00
Operations 1 Reputation point
0 answers

Clear History Problem in east asia countiries when they want to login in the application

Hello, We have offices in Copenhagen and several Asian countries, including China, Hong Kong, Indonesia, and Thailand. We are using a West Europe server in Azure, and our users in Europe can log in and work with our application without any issues.…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
395 questions
asked 2024-09-18T09:33:02.4566667+00:00
Maryam Ghoreishi 0 Reputation points