Category: Microsoft
Category Archives: Microsoft
Feature Request: Allow pinned tabs to redirect to a specific URL at each time browser restart.
Previously, I used “Install this site as an app” to install all the tools to my Windows start menu to create handy shortcuts. However, as time passes, there are too many online tools for daily use, and I think the start menu is no longer a good place for my tools. So, I’m trying to create several workspaces and pin tabs in Edge to solve my problem, and I think it works pretty well on first impression. Unfortunately, I am disappointed that the pinned tab doesn’t provide any option to set “always redirect to the specific URLs when the browser restarts”. It makes the whole workspace doesn’t work as I expected. So, I hope this feature will come up in the future.
Previously, I used “Install this site as an app” to install all the tools to my Windows start menu to create handy shortcuts. However, as time passes, there are too many online tools for daily use, and I think the start menu is no longer a good place for my tools. So, I’m trying to create several workspaces and pin tabs in Edge to solve my problem, and I think it works pretty well on first impression. Unfortunately, I am disappointed that the pinned tab doesn’t provide any option to set “always redirect to the specific URLs when the browser restarts”. It makes the whole workspace doesn’t work as I expected. So, I hope this feature will come up in the future. Read More
Latest Canary Win 11 versions and Star Wars Outlaws (edited)
On my two computers running the latest versions of Canary, Star Wars Outlaws, recently released by Ubisoft, crashes. The game hangs (closes itself) even after several dozen seconds, regardless of in-game behavior, without any error message.I nterestingly, many other players on the Outlaws forums are complaining about the same issue in the Canary Insider build.
Perhaps some direction could be given by the information that this error does not appear in Windows 23h2 versions, but unfortunately it causes problems in 24h2 version. During a failure, I have no problems with overheating of the card/processor/board. I also exclude antivirus because I added the game to the exceptions. I also use the latest NVIDIA drivers.
On my two computers running the latest versions of Canary, Star Wars Outlaws, recently released by Ubisoft, crashes. The game hangs (closes itself) even after several dozen seconds, regardless of in-game behavior, without any error message.I nterestingly, many other players on the Outlaws forums are complaining about the same issue in the Canary Insider build.Perhaps some direction could be given by the information that this error does not appear in Windows 23h2 versions, but unfortunately it causes problems in 24h2 version. During a failure, I have no problems with overheating of the card/processor/board. I also exclude antivirus because I added the game to the exceptions. I also use the latest NVIDIA drivers. Read More
When I try to open office 365 I get a blank white screen. Urgent!
Guys please help!
When I try to open my office 365 I get a blank white screen. Just happened this morning.
I cant see my files.
I tried uninstalling office 365 and reinstalling it from the Microsoft store but it’s still blank.
What do I do?
Guys please help!When I try to open my office 365 I get a blank white screen. Just happened this morning.I cant see my files.I tried uninstalling office 365 and reinstalling it from the Microsoft store but it’s still blank.What do I do? Read More
Problem with Excel for the Web
I need help with Excel for Web.
In my organization, it works fine for everyone else, but when I edit an Excel file, I need to be the first to enter it. If there is any other user, I get an error message stating that the file is locked and I can only view it in read-only mode.
If the other user closes the file, I can normally enter it, and the other user may also enter it.
Also, other users do not see this, and they can enter the file if they like in any order, etc.
I need help with Excel for Web. In my organization, it works fine for everyone else, but when I edit an Excel file, I need to be the first to enter it. If there is any other user, I get an error message stating that the file is locked and I can only view it in read-only mode. If the other user closes the file, I can normally enter it, and the other user may also enter it. Also, other users do not see this, and they can enter the file if they like in any order, etc. Read More
Structure Work Items in Azure DevOps (Beginners question :) )
Hi guys,
we are using Azure DevOps since few months and everything so far. We are using the Agile Process with Epic, Features, User Stories and Tasks.
So for the main part everything is clear to me, when we add a new feature for our application I create a feature item, a user story to explain the business view with acceptance criteria and tasks for the specific work that needs to be done to implement this.
But now we have some task like refactoring this, developing basic functions in code we can use in different areas of the app, optimize code structure etc.
For that part I am not sure how to add work items that we can track the work, have everything transparent in AzureDevops and following the structure of the Agile Process with Features, User Stores, Tasks etc.
Is it like to have a Feature (Refactoring part xy in app) and a User Story like “As a developer I want to refactor this method in code that we can use it in any other party of the application”. And the creating tasks for it?
So is the user in this case the developer instead of the customer (the end user of the application)?
Would be nice to hear some ideas and your experience, how to handle this! 🙂
Thanks guys!
Flo
Hi guys, we are using Azure DevOps since few months and everything so far. We are using the Agile Process with Epic, Features, User Stories and Tasks. So for the main part everything is clear to me, when we add a new feature for our application I create a feature item, a user story to explain the business view with acceptance criteria and tasks for the specific work that needs to be done to implement this. But now we have some task like refactoring this, developing basic functions in code we can use in different areas of the app, optimize code structure etc.For that part I am not sure how to add work items that we can track the work, have everything transparent in AzureDevops and following the structure of the Agile Process with Features, User Stores, Tasks etc. Is it like to have a Feature (Refactoring part xy in app) and a User Story like “As a developer I want to refactor this method in code that we can use it in any other party of the application”. And the creating tasks for it? So is the user in this case the developer instead of the customer (the end user of the application)? Would be nice to hear some ideas and your experience, how to handle this! 🙂 Thanks guys!Flo Read More
JSON Parsing
The output should be with 2 rows:
TVS1111 0 DBSSI ICICI addr1
TVS1111 0 DBSSI ICICI addr2
and we have to do JSON parsing for the below JSON string
declare @pJson NVARCHAR(MAX) = ‘{
“header”: {
“msgId”: “TVS1111”
},
“txnResponses”: [{
“chargesAmount”: “0”,
“senderParty”: {
“swiftBic”: “DBSSI”
},
“receivingParty”: {
“bankName”: “ICICI”,
“bankAddresses”: [{
“address”: “addr1”
},
{
“address”: “addr2”
}]
}
}]
}’
I attempted the following but it does not get the desired output
select
a.msgId,
b.chargesAmount,
b.senderPartyswiftBic,
b.receivingPartybankName,
c.address1
FROM OPENJSON(@pJson)
WITH
(
msgId VARCHAR(100) N’$.header.msgId’,
txnResponses NVARCHAR(MAX) AS JSON
) as a
CROSS APPLY OPENJSON(a.txnResponses)
WITH
(
chargesAmount VARCHAR(100) ‘$.chargesAmount’,
senderPartyswiftBic VARCHAR(100) ‘$.senderParty.swiftBic’,
receivingPartybankName VARCHAR(100) ‘$.receivingParty.bankName’,
bankAddresses NVARCHAR(MAX) AS JSON
) as b
CROSS APPLY OPENJSON(b.bankAddresses)
WITH (
address1 VARCHAR(100) ‘$.address’
) as c;
The output should be with 2 rows: TVS1111 0 DBSSI ICICI addr1TVS1111 0 DBSSI ICICI addr2 and we have to do JSON parsing for the below JSON string declare @pJson NVARCHAR(MAX) = ‘{ “header”: { “msgId”: “TVS1111” }, “txnResponses”: [{ “chargesAmount”: “0”, “senderParty”: { “swiftBic”: “DBSSI” }, “receivingParty”: { “bankName”: “ICICI”, “bankAddresses”: [{ “address”: “addr1” }, { “address”: “addr2” }] } }]}’ I attempted the following but it does not get the desired outputselect a.msgId, b.chargesAmount, b.senderPartyswiftBic, b.receivingPartybankName, c.address1FROM OPENJSON(@pJson)WITH( msgId VARCHAR(100) N’$.header.msgId’, txnResponses NVARCHAR(MAX) AS JSON) as aCROSS APPLY OPENJSON(a.txnResponses)WITH( chargesAmount VARCHAR(100) ‘$.chargesAmount’, senderPartyswiftBic VARCHAR(100) ‘$.senderParty.swiftBic’, receivingPartybankName VARCHAR(100) ‘$.receivingParty.bankName’, bankAddresses NVARCHAR(MAX) AS JSON) as bCROSS APPLY OPENJSON(b.bankAddresses)WITH ( address1 VARCHAR(100) ‘$.address’) as c; Read More
Feature Request: Restrict Name Editing in Shared Bookings for Organization (Similar to MS Forms)
I would like to request a feature for Shared Bookings within our organization.
It would be very helpful if there were an option to prevent users from editing their names when making a booking, similar to how Microsoft Forms handles name fields for authenticated users.
This feature would improve accuracy, as the names provided would be consistent across bookings.
I believe this feature would be beneficial for many organizations.
Best regards
I would like to request a feature for Shared Bookings within our organization. It would be very helpful if there were an option to prevent users from editing their names when making a booking, similar to how Microsoft Forms handles name fields for authenticated users. This feature would improve accuracy, as the names provided would be consistent across bookings.I believe this feature would be beneficial for many organizations. Best regards Read More
HELP WITH MY WHERE CLAUSE REQUIREMENT
Hello ,
I need help with examining this query.
I have this query below and my requirements. The First Requirement is
1. If appselection !=’notice to process’ and notetxt is NULL in last month show acct and no txt notes
2. if appselection=’notice to process’ and no notetxt in one month show the results (acctid)
—————————————————————————————
WITH NOTATION AS (SELECT
acctid,
appselection,
notetxt,xtp,
ndate
FROM TABLEA),
City as (acctid,
appselection
FROM EXAMPLE)
SELECT a.acctid,b.appselection,a.notetxt,a.ndate,a.xtp
FROM NOTATION a
LEFT JOIN b
ON a.acctid=b.acctid
WHERE b.appselection=’notice to process’ AND (a.notetxt IS NULL OR TO_DATE(a.ndate, ‘mm/dd/yyyy’)<=ADD_Months(SYSDATE,-1))) OR b.appselection=’notice to process’ AND (a.notetxt IS NULL OR TO_DATE(a.ndate,’mm/dd/yyyy’)<=ADD_MONTHS(sysdaate,-1)))
————————————————————————————-
I need another Where clause for requirement 2 using the same query above
REQUIREMENT b: show acctid with no notetxt in Last 2 weeks. below is what I have
WHERE n.notetxt IS NULL AND TO_DATE(n.ndate, ‘mm/dd/yyyy’)<=CURREN_DATE-14)
Hello ,I need help with examining this query.I have this query below and my requirements. The First Requirement is1. If appselection !=’notice to process’ and notetxt is NULL in last month show acct and no txt notes2. if appselection=’notice to process’ and no notetxt in one month show the results (acctid)—————————————————————————————WITH NOTATION AS (SELECTacctid,appselection,notetxt,xtp,ndateFROM TABLEA),City as (acctid,appselectionFROM EXAMPLE)SELECT a.acctid,b.appselection,a.notetxt,a.ndate,a.xtpFROM NOTATION aLEFT JOIN bON a.acctid=b.acctidWHERE b.appselection=’notice to process’ AND (a.notetxt IS NULL OR TO_DATE(a.ndate, ‘mm/dd/yyyy’)<=ADD_Months(SYSDATE,-1))) OR b.appselection=’notice to process’ AND (a.notetxt IS NULL OR TO_DATE(a.ndate,’mm/dd/yyyy’)<=ADD_MONTHS(sysdaate,-1)))————————————————————————————-I need another Where clause for requirement 2 using the same query aboveREQUIREMENT b: show acctid with no notetxt in Last 2 weeks. below is what I haveWHERE n.notetxt IS NULL AND TO_DATE(n.ndate, ‘mm/dd/yyyy’)<=CURREN_DATE-14) Read More
New MAC user with Excel app question.
I am new to MAC and going back to school using an online platform. The institution provides access to Office 365 and all apps on its website. I can open them, but when I open spreadsheets they come up with blue triangles in the data areas. To open the Excel sheet properly, I figured out I could open the Excel App (from the institution page) in a separate window and drag the assignment spreadsheet linked to my course content into the app. This opens it and lets me edit as I need. The next part of the assignment is to Copy the Excel graph and then Paste Special as a Microsoft Excel Object into the Word document. This is where I am stuck. I do not have the Paste Special option and everything I have tried to paste does not work out.
I am new to MAC and going back to school using an online platform. The institution provides access to Office 365 and all apps on its website. I can open them, but when I open spreadsheets they come up with blue triangles in the data areas. To open the Excel sheet properly, I figured out I could open the Excel App (from the institution page) in a separate window and drag the assignment spreadsheet linked to my course content into the app. This opens it and lets me edit as I need. The next part of the assignment is to Copy the Excel graph and then Paste Special as a Microsoft Excel Object into the Word document. This is where I am stuck. I do not have the Paste Special option and everything I have tried to paste does not work out. Read More
Latest Canary Win 11 versions and Star Wars Outlaws.
On my two computers with the latest versions of Canary, the game Star Wars Outlaws recently released by Ubisoft crashes. The game crashes after even several dozen seconds without any error message. Interestingly, many other people are complaining about the same problem in Canary Insider, and the error itself does not appear on the 23h2 version, but unfortunately causes problems on 24h2.
On my two computers with the latest versions of Canary, the game Star Wars Outlaws recently released by Ubisoft crashes. The game crashes after even several dozen seconds without any error message. Interestingly, many other people are complaining about the same problem in Canary Insider, and the error itself does not appear on the 23h2 version, but unfortunately causes problems on 24h2. Read More
Microsoft 365 Personal vs. Microsoft 365 Business
Is there a forum/community/hub for 365 Personal?
I am trying to find knucklehead that developed the auto-create Skype account feature for kids accounts on 365 Family.
Is there a forum/community/hub for 365 Personal? I am trying to find knucklehead that developed the auto-create Skype account feature for kids accounts on 365 Family. Read More
Email disappears a few seconds after arriving.
I started noticing my email was starting to showing less of my important emails, I have checked all folders and it is just gone. I have seen them pop up and when I go to click on them they are gone before I can try. One time I was responding to an email and it just Disappeared in the middle of me typing. I can use the search menu to find the mail, but that is only if I know the mail I am looking for, when the email is deleted before I see it i can’t search for it. I have changed nothing on the settings and I have contacted support several times and had they were unable to help. I really need these emails so any help would be appreciated. Thank you for your time.
I started noticing my email was starting to showing less of my important emails, I have checked all folders and it is just gone. I have seen them pop up and when I go to click on them they are gone before I can try. One time I was responding to an email and it just Disappeared in the middle of me typing. I can use the search menu to find the mail, but that is only if I know the mail I am looking for, when the email is deleted before I see it i can’t search for it. I have changed nothing on the settings and I have contacted support several times and had they were unable to help. I really need these emails so any help would be appreciated. Thank you for your time. Read More
how to search in table?
Hi! I want to create a simply calculator for my work.
How do I make a program that will check the protein and urea levels entered by the user and then display recommendations in the “TIP:” field?
Help me! 😭
Hi! I want to create a simply calculator for my work.How do I make a program that will check the protein and urea levels entered by the user and then display recommendations in the “TIP:” field?Help me! 😭 Read More
How to Dynamically Control Debug.Print in MS Access VBA for Optimized Performance
Hello Microsoft Community,
I’m Sasha Froyland, and I run an MS Access consultancy where we focus on optimizing performance while maintaining flexibility in debugging. I’ve recently developed a strategy for dynamically controlling Debug.Print to gain up to a 30% performance boost, which we use in our projects. What follows is this performance best practice that has helped us improve efficiency.
Would a post like this be of interest to the community? If this isn’t the appropriate place for such content, please accept my apologies in advance. My only goal is to facilitate communication and knowledge-sharing of best practices across the Access development space.
Looking forward to hearing your thoughts!
Below, please find the details of the best practice:
At Help4Access, we know how important it is to balance performance with debugging. MS Access developers rely on Debug.Print to track their code, but excessive use can slow your application—sometimes by as much as 30%. To solve this, we’ve designed a dynamic method to enable or disable Debug.Print, giving you a performance boost without sacrificing debugging flexibility.
Step 1: Global Variable for Control
Start by adding a global variable:
This will allow you to toggle Debug.Print on and off globally in your app.
Step 2: Configuration Table
Create a system configuration table, tblSystemConfig, with a field DebugEnabled (Yes/No). This table will store the setting for whether Debug.Print is active.
Step 3: Initialize on Startup
At the start of your application, pull the DebugEnabled value into the global variable:
Step 4: Conditional Debug.Print
Wherever you use Debug.Print, wrap it in a conditional statement:
Step 5: Real-Time Debugging Control
You can toggle the DebugEnabled flag in your config table to turn debugging on or off, and then refresh gDebugEnabled—no need to restart the application. This gives you up to a 30% performance boost during production while retaining the ability to debug when necessary.
By following this approach, you get both better debugging and improved performance. At Help4Access, we implement strategies like this to ensure that your Access applications run faster and more efficiently.
Hello Microsoft Community, I’m Sasha Froyland, and I run an MS Access consultancy where we focus on optimizing performance while maintaining flexibility in debugging. I’ve recently developed a strategy for dynamically controlling Debug.Print to gain up to a 30% performance boost, which we use in our projects. What follows is this performance best practice that has helped us improve efficiency. Would a post like this be of interest to the community? If this isn’t the appropriate place for such content, please accept my apologies in advance. My only goal is to facilitate communication and knowledge-sharing of best practices across the Access development space. Looking forward to hearing your thoughts! Below, please find the details of the best practice: At Help4Access, we know how important it is to balance performance with debugging. MS Access developers rely on Debug.Print to track their code, but excessive use can slow your application—sometimes by as much as 30%. To solve this, we’ve designed a dynamic method to enable or disable Debug.Print, giving you a performance boost without sacrificing debugging flexibility.Step 1: Global Variable for ControlStart by adding a global variable: vbaCopy codePublic gDebugEnabled As Boolean This will allow you to toggle Debug.Print on and off globally in your app.Step 2: Configuration TableCreate a system configuration table, tblSystemConfig, with a field DebugEnabled (Yes/No). This table will store the setting for whether Debug.Print is active.Step 3: Initialize on StartupAt the start of your application, pull the DebugEnabled value into the global variable: vbaCopy codegDebugEnabled = DLookup(“DebugEnabled”, “tblSystemConfig”) Step 4: Conditional Debug.PrintWherever you use Debug.Print, wrap it in a conditional statement: vbaCopy codeIf gDebugEnabled Then Debug.Print “Your debug message” Step 5: Real-Time Debugging ControlYou can toggle the DebugEnabled flag in your config table to turn debugging on or off, and then refresh gDebugEnabled—no need to restart the application. This gives you up to a 30% performance boost during production while retaining the ability to debug when necessary.By following this approach, you get both better debugging and improved performance. At Help4Access, we implement strategies like this to ensure that your Access applications run faster and more efficiently. Read More
OneDrive Photos on iPad does not detect or upload iPad Screen recordings
OneDrive Photos on iPad does not detect or upload iPad Screen recordings saved in iPadOS Photos App.
However it detects and uploads all other type of videos and screen recordings from iPhones.
Anyone else?
OneDrive Photos on iPad does not detect or upload iPad Screen recordings saved in iPadOS Photos App.However it detects and uploads all other type of videos and screen recordings from iPhones.Anyone else? Read More
o1: OpenAI’s new reasoning model series, now available to select Azure customers
Earlier this week, Microsoft announced the addition of OpenAI’s newest models o1-preview and o1-mini to Microsoft Azure OpenAI Service, Azure AI Studio, and GitHub Models. The o1-preview and o1-mini models are accessible in Azure AI Studio and GitHub Models to select Azure customers to collaboratively explore and identify the unique strengths of each model. These advanced reasoning models address complex issues such as complex code generation, advanced problem solving, complex document comparison, and instruction following and workflow management.
The exclusive access now available to select customers enables early experimentation with these models’ advanced reasoning capabilities, with API access coming soon.
Read more about this recent announcement here: Introducing o1: OpenAI’s new reasoning model series for developers and enterprises on Azure | Microsoft Azure Blog
____________________________________________________________________________________________________________
There are now several GPT-4o models powering Azure OpenAI Service: o1-preview, o1-mini, GPT-4o, GPT-4o Mini, DALL-E, and Whisper. Which of these models have you been using in your app development for marketplace solutions? Comment below to let us know how you are leveraging these new technologies!
Earlier this week, Microsoft announced the addition of OpenAI’s newest models o1-preview and o1-mini to Microsoft Azure OpenAI Service, Azure AI Studio, and GitHub Models. The o1-preview and o1-mini models are accessible in Azure AI Studio and GitHub Models to select Azure customers to collaboratively explore and identify the unique strengths of each model. These advanced reasoning models address complex issues such as complex code generation, advanced problem solving, complex document comparison, and instruction following and workflow management.
The exclusive access now available to select customers enables early experimentation with these models’ advanced reasoning capabilities, with API access coming soon.
Read more about this recent announcement here: Introducing o1: OpenAI’s new reasoning model series for developers and enterprises on Azure | Microsoft Azure Blog
____________________________________________________________________________________________________________
There are now several GPT-4o models powering Azure OpenAI Service: o1-preview, o1-mini, GPT-4o, GPT-4o Mini, DALL-E, and Whisper. Which of these models have you been using in your app development for marketplace solutions? Comment below to let us know how you are leveraging these new technologies! Read More
Can we use On-Behalf-Of-User flow and Client Credential Flow for same API
I have developed few API and its using on behalf of user flow. We get the delegated access for respective users to perform action. But we have several background jobs so can i switch to client credential flow for just these background jobs?
By doing this the same API has both “on behalf of user flow” and “Client Credential flow”!
I have developed few API and its using on behalf of user flow. We get the delegated access for respective users to perform action. But we have several background jobs so can i switch to client credential flow for just these background jobs? By doing this the same API has both “on behalf of user flow” and “Client Credential flow”! Read More
Capture a Network Trace : Wireshark
Introduction:
I have seen issues the customers are trying to troubleshoot with network for their applications hosted over IIS. In network troubleshooting, it’s often necessary to capture packets from both the client and server to fully understand what’s happening during communication. Wireshark, the go-to tool for network analysis, can help with this, but capturing from both sides simultaneously requires careful planning. This approach provides a complete view of the communication and helps identify issues more effectively.
In this blog will guide we will talk about the process of capturing Wireshark traces from the client and server sides at the same time, providing you with a clearer picture of the network flow and potential issues.
Let’s get started with wire shark:
Wireshark is a free and open-source network capture and network analysis tool widely used around the globe. It is not installed by default on any operating system, so it requires customers to download and install it onto their devices. All you need to make use of this is
The tool from official website Wireshark · Download
Administrator Access on Both (Client and Server)
We will capture the traces now :
Run Wireshark. On Windows machines, open the Start menu and type Wireshark in the search bar, then right-click Wireshark and select Run as Administrator
Wireshark will capture traffic from all network adapters and Network Interface Cards but you can isolate one for the capture using the Capture menu displayed when Wireshark opens. You should see a line next to the interface name that indicates if traffic is currently flowing over the interface or not to assist in the selection, if needed.
In the toolbar menu select Capture -> Start, or you can also select the blue shark fin button to start a network capture.
Set this up on Client and Server both. Now repro the problem you want to investigate. You should see packets details scrolling into view as the capture is running.
After you have reproduced the problem, in the toolbar menu select Capture -> Stop, or you can simply click the red square button to stop the trace.
In the toolbar menu, select File -> Save As. In the Save As dialog box save the trace as *.pcapng, which is the default Wireshark trace format, or you can change the Save as type dropdown menu to Microsoft Netmon 2.x and save the trace as *.cap to open using Netmon.
Now these are the ready logs for the comprehensive review to troubleshoot.
Microsoft Tech Community – Latest Blogs –Read More