access
1854 TopicsHow do I reference query data from an Access Macro
I have a simple Select query that returns a number of records. In my Access macro (just for clarification, I do mean Access Macro and not VBA) I want to check how many records the query returns in an IF statement. In this specific case the check would be on zero returned records, but being able to check non-zero in the future might be useful. I have tried various internet searches but the only results I found relate to VBA. Suggestions on how to do this check would be appreciated. Thank You46Views0likes2CommentsIs there no way to allow people to comment on my word document?
I am trying to share something I am working on with beta readers and some friends but the only options are "can edit" or "can view". There is no option for "can comment" or to let them viewers use the review function. I asked for help with the issue and got told that because my account is personal OneDrive and not business that there is no review only feature. Was that a mistake or is Microsoft really this behind on basic features? Google Drive has allowed giving people access with "comment only" for years.Solved90Views1like2CommentsCan't use a SPN in a PowerBi dashboard to access SharePoint lists
Hoping you can help with an ongoing issue I have. I have a PowerBi dashboard I built using regular account to fetch some SharePoint lists and uploaded it to PowerBi for others to view Now in PowerBi portal I want to change the credential from my account to an SPN. I've read what feels like a thousand articles describing the process to create the SPN 99% all the same. Yet when I go into Powerbi portal, edit the semantic model for the dashboard, click edit credentials, select Service Principal put in the tenant ID the Service principal ID (yes using the app id, in fact I tried everything) the service principal key (the secret) and choose any privacy level it fails 100% of the time. Error is: Failed to update data source credentials: The credentials provided for the SharePoint source are invalid. Same error regardless of what privacy level I choose. I'm sure the secret is correct also. Just for fun I tried the Secret ID and the Object ID in place of the Application ID for the Service principal ID field. All failed same error. I'm sure the secret is correct also. The SPN has Graph sites.read.all, Graph user.read and SharePoint Sites.Read.All api permissions configured. All are consented. Everything seems right but gives me the error failed to retrieve oauth token 100% of the time. Am i missing something else? More API permissions maybe? Do i still need ot actually add the SPN to the Sharepoint site itself even though I has API permissions SharePoint Sites.Read.All? I've done days of research and all I find is lots of people with same or similar issue but not resolution. Is this a bug? Help me I'm desperate to get this fixed or I'm going to have to allow people to bypass MFA across my organization which I cant have.183Views0likes1CommentUsing Access Database on Two Computers [Case #:1053617826] Microsoft Support
I have several Access databases that are linked together for various queries I run. They are located on my OneDrive. I want to use them on 2 different computers. My main desktop computer was set up as "C:\users\admin\OneDrive\ " The databases are linked and all the queries have worked fine for many years. I just bought a brand new laptop to keep at another location. It was automatically set up as "C:\users\wcrim\OneDrive\". I can access all my OneDrive files on the new computer individually. However, my databases have linkages for many queries that point to the original "C:\users\admin\OneDrive\" locations for other the databases. So on the new computer, they can't be found. On the new computer it's set up as "C:\users\wcrim\OneDrive\" I keep getting not found. I was hoping to just be able to change the user name directory on the new computer to "admin", but it appears that can't done, at least not easily. That's what I was told. What can be done so I can use these databases and all the queries on my new laptop computer also. I'm looking for an uncomplicated solution. Thank You, Wayne Crimi [Case #:1053617826] Microsoft SupportSolved3.3KViews0likes19CommentsAccount blocked
My account has been blocked and when I try to reset my password and do the verification with my phone number, it says it isnt available. I then put in a different email to send the code too and I have filled out the recovery form but it has rejected me, even though, I put all the correct information in. I have tried over and over. Everything comes in to that email so I really need access back for work purposes as well as private. Please can someone help me as I cant speak to a customer support agent!149Views0likes2CommentsAccount name, email address relationship and changing these
Hello, I am trying to help an elderly friend who has been left behind by technology and seemingly endless changes to Microsoft and other products. I am not exactly young (72) and between the 2 of us we cannot understand what we need to do. He has problems because the email provider used for his accounts (ntlworld.com) does not work any more AND he has forgotten / lost his MS account passwords which makes changing / correcting stuff challenging as we have found out. Not a good place to start but that is what we have. Firstly, can someone explain the "structure" of a Microsoft (MS) account in terms of these bits of data: Account name / title / whatever (e.g. John Smith) Account email address (e.g. email address removed for privacy reasons) Secondary (back up) email address (e.g. email address removed for privacy reasons) Does the account name need to be the primary email or is the account user e.g. is John Smith simply "data" about the account whose main ID is mailto:email address removed for privacy reasons What is linked to what and in what way? I ask this because I log in to my MS account using an email address and password and I don't understand if this is what everyone does or is it one of several account IDs. We also had fun trying to add secondary email addresses and getting them verified - trying to verify them, he received an email from MS (to the newly added 2nd email address) telling him to click the link in the email. When he did this a pop up appeared telling him that he was logged into the wrong account. It is a fairly meaningless message (sadly like many MS messages to users). So, a good start would be to get an understanding from someone (in plain English and not tech speak) so I (and he) can clearly understand what we have got and then work out a way to get to our eventual target. It should keep us amused over the winter!! Thank you in advance, F70Views0likes1CommentAccess doesn't close properly. A remaining background process can only be terminated in task manager
Since yesterday I noticed that in all my Access databases there is a problem when I close them. When I close a database, it leaves a background process that can only be terminated in Task Manager. Without this, it is not possible to (re)open databases! I have already checked some possible causes. It also concerns databases that I have not changed at all in recent months and that worked fine until this week. Therefore, I have to assume that it is a bug in an automatic update! It seems that it has to do with a malfunction in the deallocation of allocated memory in VBA source code. Did anyone experience the same problem? Are there already fixes or solutions available?Solved93KViews8likes191CommentsTroubleshooting Queries in Access
Hi All, I am trying to run a query in an Access database, the query is expected to populate an existing table with new data, however it is not running as expected. As per the set-up process, 1. Have deleted old tables (with previous data), and imported new data for these tables from a different Access database 2. Then I am doing a compact and repair. 3. Then I am running query that is expected to populate the table, I see no records are added to the table Could this be a file reference issue **or** lack of data **or** missing tables /steps **or** a connection within Access. Appreciate step by step process to diagnose the issue82Views0likes2CommentsLocked out from O365 admin account
Hi! I am locked out from my non-protif organizations O365 admin-account. When trying to login, it ask for the authenticator code, but my authenticator app tells me to login and to login it needs an authenticator code..... I cant contact the O365 support since I cannot login. I found a phone number and talked to some AI bot, but it could not understand when I said the domain name of our organization and shut me down after 3 attempts. So - I have no way to login and handle my organizations account. Can someone please advice how to solve this, or how to get in touch with an actual human being in O365 support???121Views0likes2Comments