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

Filter

Content

No answers or comments

124

With accepted answer

192

775 questions with Access Development tags

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

asked

Sachin D 0

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?

asked

Nick 0

commented

Colin Riddington 0

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…

asked

Carl S 5

commented

Carl S 5

1 answer

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…

asked

wire_jp 196

commented

wire_jp 196

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…

asked

Andreas Sperling 40

answered

Andreas Sperling 40

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…

asked

Colin Riddington 0

edited the question

Colin Riddington 0

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…

asked

Lauro Colasanti 101

commented

Jiajing Hua-MFST 705 Microsoft Vendor

1 answer

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

asked

Felix Truong 40

accepted

Felix Truong 40

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…

asked

Varun Garg 0

edited the question

ShaikMaheer-MSFT 35,796 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…

asked

Brad_BK 1

edited the question

Jiachen Li-MSFT 21,946 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), …

asked

Carl S 5

answered

Carl S 5

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.

asked

jacky Perpète 41

answered

jacky Perpète 41

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…

asked

Criseno, Ryan 0

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…

asked

Mats 1

edited a comment

Albert Kallal 4,381

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?

asked

dongjun 0

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…

asked

bar c 0

commented

JamesTran-MSFT 34,226 Microsoft Employee

1 answer

What best way to file your program in windows 11

How to import containers from ssh dev container

asked

abiola mohammed 0

answered

Wesley Li-MSFT 4,346 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…

asked

Texas-Carey 0

edited the question

Anna Xiu-MSFT 20,646 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…

asked

Juan Carranza 0

edited the question

Juan Carranza 0

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.

asked

Alan Green 0

commented

Colin Riddington 0