341 questions with Access tags

Sort by: Updated
2 answers

populate a list box based on user input

Hello, I am not a programmer, I need to populate a list box based on user input. I have Access form that has 5 Entry fields, that user enter proper information in one field and selecting “Search” icon. Created 5 different queries that runs according to…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
341 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.
857 questions
asked 2024-07-22T17:50:44.3933333+00:00
Radio Fixer 41 Reputation points
commented 2024-07-24T19:09:48.4866667+00:00
Radio Fixer 41 Reputation points
0 answers

The operation failed because of a registry or installation problem. Restart Outlook and try again.

I got an error "The operation failed because of a registry or installation problem. Restart Outlook and try again." on the last line of this simple procedure trying to execute .GetSharedDefaultFolder method: Public Sub xxx(Email As String,…

Outlook
Outlook
A family of Microsoft email and calendar products.
3,418 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
341 questions
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.
3,715 questions
asked 2024-07-18T18:50:10.17+00:00
Hugh Banyon 0 Reputation points
commented 2024-07-23T01:53:34.5966667+00:00
SokiGuo-MSFT 25,746 Reputation points Microsoft Vendor
1 answer

How to create a MS Word mail merge using an MS Access query with a criteria of Username

I have an MS Word document that I would like to populate with username details, namely; FirstName, LastName, PhoneNo, MobileNo & EmailAddress. I have an MS Access database that has a table called tblUsers with these fields plus a UserName field…

Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
751 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
341 questions
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.
3,715 questions
asked 2024-07-20T03:07:16.8233333+00:00
Matt Gilbert 0 Reputation points
edited the question 2024-07-22T02:45:30.6766667+00:00
Jiajing Hua-MFST 7,625 Reputation points Microsoft Vendor
1 answer

Why doesnt the checkbox result in a value of -1?

I am checking the boxes of these fields but for whatever reason the the value doesnt result in -1. Every single box i check returns a value of 0. What can I do so that I get the -1 value of a checked box. One thing to note is that the table from which…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
341 questions
asked 2024-07-19T17:22:19.23+00:00
Lopez, Ahiezer 236 Reputation points
edited the question 2024-07-19T21:40:12.17+00:00
Erland Sommarskog 106.8K Reputation points
1 answer One of the answers was accepted by the question author.

Will Microsoft Access have an End-of-Life? If so, when?

I am inquiring about the End of life for Microsoft Access in Office 365 products suite. Please provide dates as to end of life and end of support. Thank you!

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
341 questions
asked 2024-01-26T18:04:32.2033333+00:00
Brenda Edders 25 Reputation points
commented 2024-07-19T15:36:31.9966667+00:00
Dylan Accorti 6 Reputation points
2 answers

How do I access my account if My Authenticator was deleted and reinstalled and now requires me to do the same two-step verification process, when I'm unable to get on either device??.

I deleted and reinstalled my Authenticator app and it is still asking me to login, but it didn't save my account on the Authenticator app. Now the issue arouse that I can't verify on the app nor access my work account. How am I supposed to access my…

Microsoft Authenticator
Microsoft Authenticator
A Microsoft app for iOS and Android devices that enables authentication with two-factor verification, phone sign-in, and code generation.
6,129 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
341 questions
Microsoft Entra Internet Access
Microsoft Entra Internet Access
A Microsoft Entra service that provides an identity-centric Secure Web Gateway that protects access to internet, software as a service (SaaS), and Microsoft 365 apps and resources.
19 questions
asked 2024-07-09T14:05:57.0933333+00:00
Jordan, Arianna 5 Reputation points
commented 2024-07-17T04:44:04.3133333+00:00
Rahulkumar0855 0 Reputation points
2 answers

Issue involving sum within query returning null values, and then 0 with the addition of Nz() even though there is a quantity (MS Access)

In MS Access, I have a query summing a quantities from one table, a union query summing hours from three different tables, and finally a third query joining these two queries through alike part numbers and part descriptions. When I do this, the summed…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,345 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
341 questions
asked 2024-07-16T18:39:32.5566667+00:00
Baseel Atallah 0 Reputation points
answered 2024-07-17T02:19:49.9133333+00:00
LiHongMSFT-4306 25,651 Reputation points
2 answers

Visual Studio 2022 unable to connect to excel

Hi Folks, I wish to connect to Excel sheet from my Visual studio 2022 however when I create a connection and ran it the following error was produced. I am running Win10 64bit. ERROR Exception from HRESULT: 0xC020801C Error at Package [Connection manager…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
341 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,526 questions
asked 2024-07-13T03:00:10.69+00:00
Sebring 41 Reputation points
edited a comment 2024-07-15T07:08:58.26+00:00
Sebring 41 Reputation points
1 answer

If we are changing from Office 2016 Access runtime to Office 365 Access runtime, do we need to change the database.mdb file to the newer version of microsoft access ?

In MS Access 2016, we created a database , with the file called App1.accbd. Users run this using access runtime. i.e. they have a shortcut to MSAccess.exe ( the access runtime version), so that it opens App1.accdb. If we swap the access runtime version…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
341 questions
asked 2024-07-01T16:51:00.0766667+00:00
Greg Booth 1,316 Reputation points
commented 2024-07-13T15:28:58.87+00:00
2 answers

How can I have this code run faster?

I have this code that is executed only when I open a form. I press a button that runs a macro and that macro simply opens the form. Once this form is opened, the code in the "On Load" event is triggered, this code can be seen below. This code…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
341 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.
857 questions
asked 2024-07-10T17:27:48.5333333+00:00
Lopez, Ahiezer 236 Reputation points
commented 2024-07-11T21:03:54.8233333+00:00
AlphonseG 201 Reputation points
1 answer

Access Europe User Group Meeting - Wed 3 July

The next Access Europe User Group meeting will be on Wednesday 3 July 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). We are pleased to welcome two presenters from Germany: Olaf Nöhring and André Minhorst. Olaf will…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
341 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.
857 questions
asked 2024-06-28T18:28:52.7133333+00:00
Colin Riddington 141 Reputation points MVP
edited an answer 2024-07-08T12:11:40.9533333+00:00
Colin Riddington 141 Reputation points MVP
2 answers

where can I find Microsoft.ACE.OLEDB.12.0 Provider 64-bit

hello, We need the driver "Microsoft.ACE.OLEDB.12.0 Provider 64-bit", but it is no longer available! Could you provide me with a download link? Regards

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,345 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
341 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,624 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
517 questions
asked 2024-04-19T01:28:50.96+00:00
Elham Khalaji 0 Reputation points
commented 2024-07-04T11:11:44.27+00:00
Chandrasekar N 0 Reputation points
0 answers

Your account has been locked

Your account has been locked. Contact your support person to unlock it, then try again

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
341 questions
asked 2024-07-03T10:05:00.19+00:00
snof 0 Reputation points Microsoft Employee
3 answers

Error 3101 in Access 2013

I have an error 3101 message in my desktop database (Access2013). I do have a one to many relationship, but the "many" side does have a corresponding record on the "one" side, but I get the 3101 error anyway. How can that…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
341 questions
asked 2024-07-01T20:09:32.73+00:00
Biorn Veiro 0 Reputation points
commented 2024-07-02T20:35:19.08+00:00
Biorn Veiro 0 Reputation points
0 answers

The expression On Open you entered as the event property setting produces the following error : Duplicate definition

Hello all I am Fouad from Baghdad I have an Access database that works on all versions of Office from version 2010 to the latest version in Arabic, and it works on Windows 10 and Windows 11 systems, but there is a laptop on which my database did not…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
341 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.
857 questions
asked 2024-07-01T21:11:13.6+00:00
Fouad Alshamy 0 Reputation points
1 answer

I lost my access to Minecraft

I bought Minecraft years ago from a gift card. I migrated my Mojang account to my Microsoft account and I could play with no problems for the time being. I played the last time like 2-3 days ago, and now I wanted to play Minecraft again. I can't.…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
341 questions
asked 2024-06-30T10:46:23.02+00:00
Magdalena Rudnik 5 Reputation points
answered 2024-07-01T15:05:16.3533333+00:00
Schneider, Tobias 1,135 Reputation points
0 answers

Device management could not be enabled

Your account was not set up because device management could not be enabled. This device might not be able to access some resources such as wifi vpn or email

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
341 questions
asked 2024-07-01T05:29:52.7133333+00:00
Mahalakshmi S 0 Reputation points
6 answers One of the answers was accepted by the question author.

Invalid procedure call or argument error

When pressing a command button the code below is executed, and it results in an error as seen in the picture. In addition, I seem to be the only user with this issue. My coworkers don't mention having this issue. I never had this issue until about a…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
341 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.
857 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,067 questions
asked 2024-06-04T21:28:57.5766667+00:00
Lopez, Ahiezer 236 Reputation points
edited the question 2024-07-01T02:56:55.8133333+00:00
Jiajing Hua-MFST 7,625 Reputation points Microsoft Vendor
0 answers

Error when changing DataSet from Access to SQL

I have a VB program that I wrote many years ago that used an Access database. The program has a DataSet that I originally created from the Access database. Recently, I tried changing the connection string it uses to point to a MS SQL Server Express…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
341 questions
asked 2024-06-29T17:52:56.2233333+00:00
Gregory Greenman 0 Reputation points
0 answers

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.
341 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.
857 questions
asked 2024-06-21T14:37:39.87+00:00
CC 0 Reputation points