Microsoft Q&A

Access Development

775 questions

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.

Browse all Office tags

775 questions with Access Development tags

Sort by: Updated
0 answers

Am a pro user in power bi service and i cant find the streaming datasets option in the bi service

i cant access or cant see streaming datasets options in power bi service

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.
775 questions
asked 2023-12-07T06:33:00.99+00:00
Sachin D 0 Reputation points
0 answers

Can't transfer excel file to access.

I am attempting to transfer an Excel file to Access, but each time I try I receive an error message stating "Microsoft was unable to append all the data to the table." What could be causing this issue and how can I resolve it?

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,099 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
239 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.
775 questions
asked 2023-11-30T16:04:47.8333333+00:00
Nick 0 Reputation points
commented 2023-12-05T22:48:19.3066667+00:00
Colin Riddington 0 Reputation points
1 answer

how to update database using freeform list

I want to update a table based off of a list box. The list box needs to be freeform, copy/paste list. I have a table for servers. 1 column is for server names and another is for decommissioned (yes/no checkbox). I want to be able to provide a list of…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
239 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.
775 questions
asked 2023-11-22T16:45:14.7733333+00:00
Carl S 5 Reputation points
commented 2023-12-05T21:12:41.89+00:00
Carl S 5 Reputation points
1 answer 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.
239 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.
775 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.
572 questions
asked 2023-11-22T14:21:09.4966667+00:00
wire_jp 196 Reputation points
commented 2023-12-03T11:38:45.1166667+00:00
wire_jp 196 Reputation points
1 answer

access table transpose two fields

Hello, It's not easy for me to describe what I want. :-) I have a database table with two fields. In one field is an Active Directory Group, in the other field are the member of the group. In some groups there are 300 to 700 users separated by a…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
239 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.
775 questions
asked 2023-11-30T13:13:03.53+00:00
Andreas Sperling 40 Reputation points
answered 2023-11-30T16:03:41.4066667+00:00
Andreas Sperling 40 Reputation points
0 answers

Access Europe Meeting - Wed 6 Dec - Streamline Your Import/Export Spec Workflow with VBA Classes

The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike Wolfe (MVP) will be leading a presentation called…

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.
2,700 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
239 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.
775 questions
asked 2023-11-28T14:20:59.4733333+00:00
Colin Riddington 0 Reputation points
edited the question 2023-11-28T17:39:13.0133333+00:00
Colin Riddington 0 Reputation points
3 answers

When launched from Access via VBA, Word open a .tmp file outside the trusted folder (maybe OLE problem)

Hi, I have an Access form with an OLE BoundObjectFrame holding Word documents. I repurpose the context menu so I can lauch the Word document by my VBA code. When a file is opened everything is fine. But when I try to open a second one without closing the…

Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
504 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,061 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.
775 questions
Word Management
Word Management
Word: A family of Microsoft word processing software products for creating web, email, and print documents.Management: The act or process of organizing, handling, directing or controlling something.
863 questions
asked 2023-11-25T22:38:03.6133333+00:00
Lauro Colasanti 101 Reputation points
commented 2023-11-28T08:59:18.6666667+00:00
Jiajing Hua-MFST 705 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

Table in local emulator with CapsLock in table name is can't access by postman

I create 2 table with name are (Test, test) , I can access table test by using SAS key but Test I get no permission. you can check following picture

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.
2,312 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
239 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.
775 questions
asked 2023-11-20T06:29:13.9033333+00:00
Felix Truong 40 Reputation points
accepted 2023-11-27T14:32:42.85+00:00
Felix Truong 40 Reputation points
1 answer

How to increase the Custom Rest API Processing Speed?

Hi, Can anyone help me understanding on why API speed is not what it used to be?   I have designed a custom API for one of my client(lets say abc), in this I created a Staging table to store data received from API and on Insert event in table using…

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.
775 questions
asked 2023-10-13T04:34:37.0433333+00:00
Varun Garg 0 Reputation points
edited the question 2023-11-24T05:06:49.59+00:00
ShaikMaheer-MSFT 35,796 Reputation points Microsoft Employee
1 answer

Method to query access database from excel Visual Basic for Applications VBA

Thanks for any help. I have been using the below method to query my Access database from Excel VBA for over a decade. Today it started throwing an unspecified error. I tried all the usual suspects (reboot, reinstall, switch PC, access files from local…

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,061 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.
775 questions
asked 2022-02-02T20:42:47.52+00:00
Brad_BK 1 Reputation point
edited the question 2023-11-23T14:31:34.21+00:00
Jiachen Li-MSFT 21,946 Reputation points Microsoft Vendor
1 answer

Access query returns no results

I have a simple situation that isn't acting simply. I have 1 table, tblApplications. 1 query, qryApplications. 2 form, fmApplicationSearch and fmApplication. The fmApplicationSearch form has 3 fields (and a button to open fmApplication), …

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.
775 questions
asked 2023-11-20T22:06:15.5+00:00
Carl S 5 Reputation points
answered 2023-11-20T22:39:49.96+00:00
Carl S 5 Reputation points
1 answer

Check instances of opening an add-in (accde)

Hi, In VBA, is it possible when opening an add-in (accde) to check if this add-in is already opened by another database? I would like to perform an action in my add-in only each time it is opened for the first time.

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.
775 questions
asked 2023-11-10T16:03:57.73+00:00
jacky Perpète 41 Reputation points
answered 2023-11-18T05:36:29.7933333+00:00
jacky Perpète 41 Reputation points
0 answers

Access VBA SMTP now requires Authentication

I had some SMTP emails that were working just fine. But now my organization requires that we use authentication to send out to outside domain emails. My working code is as seen below: Sub SendEmail(sTo As String, sSubject As String, Optional sBody As…

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.
775 questions
asked 2023-11-17T18:56:24.3366667+00:00
Criseno, Ryan 0 Reputation points
3 answers

How to leverage SQL Server Application Roles in MsAccess?

Does anyone know if there is a way to use SQL Server Application Roles from within Ms Access? I have an Ms Access application with tables linked to SQL Server. Users of the application can access and manipulate data in the linked tables according to…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
11,635 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.
775 questions
asked 2022-05-17T16:50:36.447+00:00
Mats 1 Reputation point
edited a comment 2023-11-15T20:33:54.5+00:00
Albert Kallal 4,381 Reputation points
0 answers

how come i do not find releases pipeline tab and not find use the editor to create a pipeline with YAML on my machine?

i am using dev.azure to do ci/cd, but how come i do not find releases pipeline tab and not find use the editor to create a pipeline with YAML?

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.
775 questions
asked 2023-11-15T03:29:18.9733333+00:00
dongjun 0 Reputation points
1 answer

verify jwt (access_token) by python

hello, I have a front in angular and a backend in Django Python. I take my access_token from my front by: this.msalService.instance.acquireTokenSilent and send it to my backend api, i need to verify and validate this access_token before anything will…

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.
775 questions
Microsoft Entra External ID
Microsoft Entra External ID
A modern identity solution for securing access to customer, citizen and partner-facing apps and services. It is the converged platform of Azure AD External Identities B2B and B2C. Replaces Azure Active Directory External Identities.
2,465 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
17,589 questions
asked 2023-11-07T15:17:15.7033333+00:00
bar c 0 Reputation points
commented 2023-11-10T20:22:41.9833333+00:00
JamesTran-MSFT 34,226 Reputation points Microsoft Employee
1 answer

What best way to file your program in windows 11

How to import containers from ssh dev container

Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
11,157 questions
Remote Desktop
Remote Desktop
A Microsoft app that connects remotely to computers and to virtual apps and desktops.
3,991 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.
775 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
6,808 questions
asked 2023-10-19T00:19:31.3033333+00:00
abiola mohammed 0 Reputation points
answered 2023-11-10T08:00:13.38+00:00
Wesley Li-MSFT 4,346 Reputation points Microsoft Vendor
0 answers

Calculate by month days served based on start date and end date into a report

I am creating an MS Access project that will determine the amount of time served by month and need it to return the results into a temporary table that will be used to populate a report. The criteria will be supplied in the initial form/report that will…

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.
775 questions
asked 2023-11-07T15:11:47.6266667+00:00
Texas-Carey 0 Reputation points
edited the question 2023-11-08T01:23:47.3+00:00
Anna Xiu-MSFT 20,646 Reputation points Microsoft Vendor
0 answers

LINKEDIN ERROR: STATUS 403 Api Organization version: 202310

I am working to get data from public pages with Api "Organization" with the last version (202310), but I always get status 403, "Not enough permissions to access" eventhough I got the specific scope for this request. If I switch to…

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.
775 questions
asked 2023-10-31T15:03:04.9633333+00:00
Juan Carranza 0 Reputation points
edited the question 2023-11-03T20:17:53.27+00:00
Juan Carranza 0 Reputation points
2 answers

Access shortcut

I used to be able to copy a field entry from the previous record in a table by Ctl '. It now no longer works. Is there now another way? Copying and pasting takes too many key strokes.

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.
775 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.
572 questions
asked 2023-10-16T11:21:18.06+00:00
Alan Green 0 Reputation points
commented 2023-10-31T23:07:38.8933333+00:00
Colin Riddington 0 Reputation points