Content
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
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?
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…
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 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 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…
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…
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
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…

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…
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), …
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 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…
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…
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?
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…

What best way to file your program in windows 11
How to import containers from ssh dev container

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…
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 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.