Tag Archives: microsoft
Whom to report when several days after a ‘file submission’ displayed status is ‘In progress’…
Hello all,
could anyone be so kind to tell me whom should I report these issues to, when :
– after several days (since submission took place on June 29, 2024) reported Status for same below mentioned ‘Submission ID’ is still displayed as ‘In progress’ ?
– no details for an already Submitted ‘File submission’ are available (because after clicking on ‘ 90d794a0-3a0d-4bc2-9d8f-2169d477fb30‘ only this error message is shown ‘The details for the submission were not found or the submission has expired. You can view recent items in your submission history.‘) ?
P.S. If I’d rather (better) submit this post/question into another Discussion Space then please just let me know ASAP.
Below you find a screenshot showing main issue I described. Please also note that I also already tried to report same main issue same day of submission and also today via same ‘Provide feedback’ smiley icon(also shown in screenshot below and evidenced in a squared box) but with no results so far.
Thanks in advance for any update.
Best Regards
Rob
Hello all, could anyone be so kind to tell me whom should I report these issues to, when :- after several days (since submission took place on June 29, 2024) reported Status for same below mentioned ‘Submission ID’ is still displayed as ‘In progress’ ?- no details for an already Submitted ‘File submission’ are available (because after clicking on ‘ 90d794a0-3a0d-4bc2-9d8f-2169d477fb30’ only this error message is shown ‘The details for the submission were not found or the submission has expired. You can view recent items in your submission history.’) ? P.S. If I’d rather (better) submit this post/question into another Discussion Space then please just let me know ASAP.Below you find a screenshot showing main issue I described. Please also note that I also already tried to report same main issue same day of submission and also today via same ‘Provide feedback’ smiley icon(also shown in screenshot below and evidenced in a squared box) but with no results so far.Thanks in advance for any update. Best RegardsRob Read More
Can’t select multiple items with ctrl-click
Hi,
MS has changed mouse behavior in New Outlook. This seems an unusual move because PC users generally know how to use their keyboard and mouse – and have done for ~40 years. ctrl – left-click has, as long as I can remember, always enabled the user to select multiple items – text, files etc. But in New Outlook (not other MS programs) this has been disabled. This is a fundamental GUI operation. I can only imagine that the developer responsible has not been using PCs very much (or very long). Perhaps they are only accustomed to touch screens and / or are a very young child?
The mouse behavior has also been changed for activating pop-up options, namely spell-check, which is now left-click (was right click). This means that roughly 2 billion users accustomed to spell checking / using pop-up edit menus now have the inconvenience of learning a new and pointless set of operations (Incidentally, the old operation of left click – delete, to enter a word and change a character, not archives the email!).
In conclusion, I think MS should admit this was a mistake and put back the conventional controls. And probably re-assign those employees (or creche residents) responsible. Despite what many people think, I do no believe MS is in the business of deliberately annoying their customers.
Finally – when I tried to find out where to raise this as an issue / bug, I found there is not longer any online way to do this and there are only various software tools to try to fix issues yourself. Since this fits best into the category of feedback / bug repot, I really think MS should reinstate such online services.
Thanks,
T.
Hi, MS has changed mouse behavior in New Outlook. This seems an unusual move because PC users generally know how to use their keyboard and mouse – and have done for ~40 years. ctrl – left-click has, as long as I can remember, always enabled the user to select multiple items – text, files etc. But in New Outlook (not other MS programs) this has been disabled. This is a fundamental GUI operation. I can only imagine that the developer responsible has not been using PCs very much (or very long). Perhaps they are only accustomed to touch screens and / or are a very young child? The mouse behavior has also been changed for activating pop-up options, namely spell-check, which is now left-click (was right click). This means that roughly 2 billion users accustomed to spell checking / using pop-up edit menus now have the inconvenience of learning a new and pointless set of operations (Incidentally, the old operation of left click – delete, to enter a word and change a character, not archives the email!). In conclusion, I think MS should admit this was a mistake and put back the conventional controls. And probably re-assign those employees (or creche residents) responsible. Despite what many people think, I do no believe MS is in the business of deliberately annoying their customers. Finally – when I tried to find out where to raise this as an issue / bug, I found there is not longer any online way to do this and there are only various software tools to try to fix issues yourself. Since this fits best into the category of feedback / bug repot, I really think MS should reinstate such online services. Thanks, T. Read More
Microsoft Reporting Services – (localdb)MSSQLLocalDB
Using Reporting Services (project), I am able Create and Run reports. But I cannot deploy the project. (target report selected in properties)
I am hoping to deploy the report (report project) from my Startup project inside my projects Solution. However, when I deploy the project from Solution Explorer, it shows username and password dialog box, that I never entered during SQL installation setup. (does not work when entered)
So I tried to run reports using ReportViewer, which I know to run *.rdlc reports by default. Information that I read online says that ReportViewer will NOT run *.rdl files. However, I am okay with using ReportViewer with *.rdl reports, if possible.
All help and guidance appreciated in advance,
Shane.
Using Reporting Services (project), I am able Create and Run reports. But I cannot deploy the project. (target report selected in properties) I am hoping to deploy the report (report project) from my Startup project inside my projects Solution. However, when I deploy the project from Solution Explorer, it shows username and password dialog box, that I never entered during SQL installation setup. (does not work when entered) So I tried to run reports using ReportViewer, which I know to run *.rdlc reports by default. Information that I read online says that ReportViewer will NOT run *.rdl files. However, I am okay with using ReportViewer with *.rdl reports, if possible. All help and guidance appreciated in advance, Shane. Read More
Feedback: Please Include Customer Identifying Info In Booking Email
The emails we get from the Bookings have no customer identifying info.
It has their name, assigned staff member, and the date & time etc., but that’s it.
So we have to go in to Bookings just to get their email*, copy it, and manually paste it elsewhere (Freshdesk).
It’s such a waste of time for something that should be included.
Please consider adding it as an option!
(*Sometimes we use their mobile if we can’t find customer using their email.)
The emails we get from the Bookings have no customer identifying info. It has their name, assigned staff member, and the date & time etc., but that’s it. So we have to go in to Bookings just to get their email*, copy it, and manually paste it elsewhere (Freshdesk). It’s such a waste of time for something that should be included. Please consider adding it as an option! (*Sometimes we use their mobile if we can’t find customer using their email.) Read More
determine order of results in search on sharepoint site
Currently when a user searches for a document on our sharepoint site, it doesnt show the results in order of latest modified or created date. How can we organise our search to show the results in order from latest modified date?
Currently when a user searches for a document on our sharepoint site, it doesnt show the results in order of latest modified or created date. How can we organise our search to show the results in order from latest modified date? Read More
Assista ao vídeo da palestra “Inteligência Artificial & Educação: é possível as duas serem aliadas?”
Feliz em começar aqui nossos posts semanais com os conteúdos do evento AI for ChangeMakers
E o primeiro é sobre IA na educação com Vera Cabral (Diretora de Educação na Microsoft LATAM) e
Ana Ligia Scaccheti (Diretora-executiva na Associação Nova Escola)
https://www.youtube.com/watch?v=HFsXiNkdXmA&feature=youtu.be
Feliz em começar aqui nossos posts semanais com os conteúdos do evento AI for ChangeMakers
E o primeiro é sobre IA na educação com Vera Cabral (Diretora de Educação na Microsoft LATAM) e Ana Ligia Scaccheti (Diretora-executiva na Associação Nova Escola)
https://www.youtube.com/watch?v=HFsXiNkdXmA&feature=youtu.be Read More
Flagged emails cant be changed in To-Do
When I flag an email in Outlook, it shows up in the To-Do list but I cannot enter a due date or status (or probably anything else). What’s up with that?
When I flag an email in Outlook, it shows up in the To-Do list but I cannot enter a due date or status (or probably anything else). What’s up with that? Read More
SharePoint Global Navigation Blank
I am struggling with getting the Global navigation working, not sure if I am doing something wrong or if it’s a timing issue?
I have read many MS and other pages and videos on Navigation and hub sites and think I understand it a bit but clearly, I am missing something.
Steps Taken
Via SharePoint Admin & Site Settings & PowerShell
Created a Comm site (HomeSite)Set as the Home site, via PS [Set-SPOHomeSite -HomeSiteUrl https://…]Registered the HomeSite to a Hub siteChanged the “look and feel” on the HomeSite, eg theme colors, layoutThe Global Navigation link is shown under the site’s Settings menu with;Enable global nav “On” changed custom logo for visual testing (and is shown on all pages now)Confirmed Hub Settings is “Shown in navigation”Associated another site (Site2), with the HomeSite Created two more Comms sites (HrDeptHub) & (Onboarding)Associated Onboarding to the HrDeptHub siteAdded a parent association to the HrDeptHub to the HomeSiteasdf
But in the end, I am not seeing any menu changes (horizontal page menus on the Comms site) and the Global Navigation is empty. I am logged into the site as the Site Owner and have a test user with basic permissions only.
Oddly the Theme settings/colors on the HomeSite (hub) are not propagating to the associated sites. In another test with 2 brand new sites (CommSite1 hub) & (Teamsite1), branding/colors are enforced on the associated TeamSite1. But I the Global Nav is empty, and the top Hub navigation (horizontal) only shows items from the site itself.
I am struggling with getting the Global navigation working, not sure if I am doing something wrong or if it’s a timing issue?I have read many MS and other pages and videos on Navigation and hub sites and think I understand it a bit but clearly, I am missing something. Steps TakenVia SharePoint Admin & Site Settings & PowerShellCreated a Comm site (HomeSite)Set as the Home site, via PS [Set-SPOHomeSite -HomeSiteUrl https://…]Registered the HomeSite to a Hub siteChanged the “look and feel” on the HomeSite, eg theme colors, layoutThe Global Navigation link is shown under the site’s Settings menu with;Enable global nav “On” changed custom logo for visual testing (and is shown on all pages now)Confirmed Hub Settings is “Shown in navigation”Associated another site (Site2), with the HomeSite Created two more Comms sites (HrDeptHub) & (Onboarding)Associated Onboarding to the HrDeptHub siteAdded a parent association to the HrDeptHub to the HomeSiteasdf But in the end, I am not seeing any menu changes (horizontal page menus on the Comms site) and the Global Navigation is empty. I am logged into the site as the Site Owner and have a test user with basic permissions only. Oddly the Theme settings/colors on the HomeSite (hub) are not propagating to the associated sites. In another test with 2 brand new sites (CommSite1 hub) & (Teamsite1), branding/colors are enforced on the associated TeamSite1. But I the Global Nav is empty, and the top Hub navigation (horizontal) only shows items from the site itself. Read More
SharePoint form “Edit Columns” with “Conditional Formula” and available field properties
I am trying to find out where I can find a complete list of the available “properties” of a column, so I don’t have to continually ask in a forum.
For example, I am trying to set a “conditional formula” to show a column on the default New Experience forms when the current user a specific person (people column-single input).
eg
=if([$CurrentUser.email] == ‘name @ domain dot com’, ‘true’, ‘false’)
What are the right properties and where can I find the list for this or any column for that matter, so can learn to solve these questions on my own.
AND
Similarly the correct syntax/properties to use for say a people column, MS help shows this,
=if([$Owner.email] == ‘name @ domain dot com’, ‘true’, ‘false’)
I assume “Owner.email” is the created by person’s email but that is not working when I change it to local user/email.
Thanks for any direction, suggestions.
I am trying to find out where I can find a complete list of the available “properties” of a column, so I don’t have to continually ask in a forum. For example, I am trying to set a “conditional formula” to show a column on the default New Experience forms when the current user a specific person (people column-single input).eg=if([$CurrentUser.email] == ‘name @ domain dot com’, ‘true’, ‘false’)What are the right properties and where can I find the list for this or any column for that matter, so can learn to solve these questions on my own. ANDSimilarly the correct syntax/properties to use for say a people column, MS help shows this, =if([$Owner.email] == ‘name @ domain dot com’, ‘true’, ‘false’) I assume “Owner.email” is the created by person’s email but that is not working when I change it to local user/email. Thanks for any direction, suggestions. Read More
Data Retention, Compliance, and Litigation Holds
We recently revamped our data retention policies and now I need to set up everything in M365. In the past, we would enable litigation hold under the user’s account. Since that only does email, that is not enough.
We are now drastically shortening our retention policy and it’s critical that all data for a user is accessible if they were brought into a litigation issue. So if we were subpoenaed, I would “freeze” the users data and then it would be possible to search if we were required 1/2/3 months down the road. Is the best way to do this by starting an eDiscovery search and placing everything on hold but not searching for anything? Then, if we were required to search the account, I would edit that eDiscovery hold to include specific queries? Or maybe I would create a “Litigation Hold” retention policy outside of the new default one that would hold their data indefinitely? That seems like a pain to exclude the user and then add them to the other and probably not efficient.
Looking for advice from anyone who does this a lot as Microsoft gives a ton of options.. which is great, but it makes it difficult to know the best way when handling critical data.
We recently revamped our data retention policies and now I need to set up everything in M365. In the past, we would enable litigation hold under the user’s account. Since that only does email, that is not enough. We are now drastically shortening our retention policy and it’s critical that all data for a user is accessible if they were brought into a litigation issue. So if we were subpoenaed, I would “freeze” the users data and then it would be possible to search if we were required 1/2/3 months down the road. Is the best way to do this by starting an eDiscovery search and placing everything on hold but not searching for anything? Then, if we were required to search the account, I would edit that eDiscovery hold to include specific queries? Or maybe I would create a “Litigation Hold” retention policy outside of the new default one that would hold their data indefinitely? That seems like a pain to exclude the user and then add them to the other and probably not efficient. Looking for advice from anyone who does this a lot as Microsoft gives a ton of options.. which is great, but it makes it difficult to know the best way when handling critical data. Read More
Sorting on multiples in same column
Hi there – Cannot figure this out. I have a list of items in a column as follows:
5″ White
5″ Red
5″ Blue
11″ White
11″ Red
11″ Blue
17″ White
17″ Red
17″ Blue
There are several more sizes but I need to sort this sheet so that the colors fall in order and the sizes order as 11, 17, 5.
11″ White
17″ White
5″ White
11″ Red
17″ Red
5″ Red
And so on. The colors are in a specific order not based on alphabet.
Thank you in advance!
Hi there – Cannot figure this out. I have a list of items in a column as follows:5″ White5″ Red5″ Blue11″ White11″ Red11″ Blue17″ White17″ Red17″ BlueThere are several more sizes but I need to sort this sheet so that the colors fall in order and the sizes order as 11, 17, 5. 11″ White17″ White5″ White11″ Red17″ Red5″ RedAnd so on. The colors are in a specific order not based on alphabet.Thank you in advance! Read More
What do you think about RSVP in Outlook?
Hello Calendar Community,
RSVP (responding to meeting invitations) is an area with lots of opportunity for improvements in Outlook Calendar. I’m reaching out to gather your feedback on RSVP.
We’re particularly interested in understanding:
Ease of Use: How intuitive and user-friendly do you find the current RSVP process?
Functionality: Are there any features you wish were included to improve the RSVP experience?
Efficiency: How could we make RSVPing quicker and more efficient for you?
Overall Experience: Any other comments on your overall experience with the RSVP functionality?
Feel free to share your thoughts in the comments. I am really eager for some insights from our community and its power calendar users.
cheers,
Gio
Hello Calendar Community,
RSVP (responding to meeting invitations) is an area with lots of opportunity for improvements in Outlook Calendar. I’m reaching out to gather your feedback on RSVP.
We’re particularly interested in understanding:
Ease of Use: How intuitive and user-friendly do you find the current RSVP process?
Functionality: Are there any features you wish were included to improve the RSVP experience?
Efficiency: How could we make RSVPing quicker and more efficient for you?
Overall Experience: Any other comments on your overall experience with the RSVP functionality?
Feel free to share your thoughts in the comments. I am really eager for some insights from our community and its power calendar users.
cheers,
Gio Read More
Visual Studio AI Toolkit : Building Phi-3 GenAI Applications
Level up your Generative AI development with Microsoft’s AI Toolkit! In the previous blog, we explored how AI Toolkit empowers you to run LLMs/SLMs locally.
AI toolkit lets us to,
Run pre-optimized AI models locally: Get started quickly with models designed for various setups, including Windows 11 running with DirectML acceleration or direct CPU, Linux with NVIDIA GPUs, or CPU-only environments.
Test and integrate models seamlessly: Experiment with models in a user-friendly playground or use a REST API to incorporate them directly into your application.
Fine-tune models for specific needs: Customize pre-trained models (like popular SLMs Phi-3 and Mistral) locally or in the cloud to enhance performance, tailor responses, and control their style.
Deploy your AI-powered features: Choose between cloud deployment or embedding them within your device applications.
Port Forwarding, a valuable feature within the AI Toolkit, serves as a crucial gateway for seamless communication with the GenAI model. Whether it’s through a straightforward API call or leveraging the SDKs, this functionality greatly enhances our ability to harness the power of the LLM/SLM. By enabling Port Forwarding, a plethora of new scenarios unfold, unlocking the full potential of our interactions with the model.
Port forwarding is like setting up a special path for data to travel between two devices over the internet. In the context of AI Toolkit, port forwarding involves configuring a pathway for communication between the LLM and external applications or systems, enabling seamless data exchange and interaction.
AI toolkit auto forwards the port to 5272 by default. If needed this can be modified or new ports can be added. This can be seen the moment we load the AI Toolkit extension on VS Code. A notification can be seen on the right side of the screen stating the “Your application running on port 5272 is available”
The 5272 is default port assigned by AI Toolkit, if we wish to add more ports, that can be done by navigating to the PORTS terminal on VS Code and then clicking on the “Add Ports” button.
In this, we can see the section “Forwarded address”. This is the address which will be used for communicating with the SLM. For this tutorial, Phi-3 will be used. This is a Small Language Model from Microsoft. It can be downloaded from the Model Catalog section.
Testing and comprehending the API Endpoint on POSTMAN:
Testing out an application from the API testing application, gives a clear knowledge about the API specification. This can also be done using the coding language, but for this demonstration, I will be showcasing it through the POSTMAN application. Postman application needs to be downloaded and installed on the local machine. Also sign up and create an account if you don’t have one. Once the application is launched, click on create a new request, it will be displayed as “+’” icon.
In order to do this testing, we would need some basic information about the API that we are testing. Details like Request method, Request URL, request body, type of the request body, authentication type are some of the mandatory things which will be needed. For the Visual Studio Code AI Toolkit API with Phi-3-mini-128k-cuda-int4-onnx model, the details are as follows,
Authentication: None
Request method: POST
Request URL:
http://127.0.0.1:5272/v1/chat/completions
Request Body type: Raw/JSON
Request Body:
{
“model”: “Phi-3-mini-128k-cuda-int4-onnx”,
“messages”: [
{
“role”: “user”,
“content”: “Hi”
}
],
“temperature”: 0.7,
“top_p”: 1,
“top_k”: 10,
“max_tokens”: 100,
“stream”: false
}
Authentication will be defaulting to None. So, it can be retained here to None as it is. HTTP request method here would be POST. The Request URL must be checked according to the Port that has been assigned, if it is the default port which is assigned by the visual studio ai toolkit, it will be 5272. Incase, it is changed to any other port, it must be changed in the URL as well. This will be a HTTP request and the URL must contain the URL address, followed by the port and the routes must be set as shown above.
The “model” parameter in the request body must have the same model that is being loaded in the VS Code AI Toolkit – playground section.
Request body type must be set to Raw and from the dropdown, select JSON.
The streaming parameter must be set to false, else the response will be streamed and divided into sub-classes of JSON which is hard to comprehend. In-case if the application needs streaming, then the parameter can be set to TRUE.
Once these are ready, use the Send button and wait for the response. If the API call is successful, 200 OK will be displayed and a response body will be visible in the Body tab.
NOTE: The VS Code AI Toolkit must be running in the background, and load the model in the playground before sending the API response in Postman.
The response of the above request is as follows,
Meanwhile, this will also be reflected on the VS Code AI toolkit Output window as well.
The response body carries quite a lot of information, the answer that will be used in the application is in the “content” division. The code must navigate to the first section of the choices then the messages and finally to the content section. In python, it can be done by,
chat_completion.choices[0].messages.content
This will be further used while building the playground application in the later part of this tutorial.
The response body also provides some more useful information like the ID, created stamp, finish reason to name a few. The role parameter shows that the response is from the model and hence shows “assistant”.
Code snippet can also be generated with the POSTMAN app, which can be then used for testing the API. Following is the example for the Python Code using the HTTP Client.
Using the VS Code AI Toolkit with Python:
from openai import OpenAI
client = OpenAI(
base_url=”http://127.0.0.1:5272/v1/”,
api_key=”xyz” # required by API but not used
)
chat_completion = client.chat.completions.create(
messages=[
{
“role”: “user”,”content”: “What is the capital of India?””,
}
],
model=”Phi-3-mini-128k-cuda-int4-onnx”,
)
print(chat_completion.choices[0].message.content)
The Python script interacts with an API (local instance of OpenAI’s API) to get a chat completion.
Step-by-step explanation of Python Implementation:
Importing the OpenAI library: The script starts by importing the OpenAI class from the openai package. This class is used to interact with OpenAI’s API. It can be installed using the simple python command as follows.
pip install openai
Although we are not communicating to the OpenAI’s API, we are utilizing the OS library to interact with the model running in local machine.
Create an OpenAI client instance: Initialize an OpenAI client with a base URL pointing to http://127.0.0.1:5272/v1/, which suggests the API is hosted locally rather than on OpenAI’s cloud servers. An API key, “XYZ”, is also provided, which is noted as required by the API but not used in this context. The API key can be set to anything and not necessarily XYZ.
Create a chat completion request: The script then creates a chat completion request using the chat.completions.create method of the client. This method is called with two parameters:
messages: A list containing a single message dictionary where the role is set to “user” and the content is the question ” What is the capital of India?”. This structure mimics a chat interaction where a user asks a question.
model: Specifies the model to use for generating the completion, in this case, “Phi-3-mini-128k-cuda-int4-onnx”. This indicates a specific model configuration.
Print the response: Finally, the script prints the content of the first message from the response’s choices. API returns a list of possible completions (choices), and it accesses the content of the message from the first choice to display the answer to the user’s question as demonstrated in the POSTMAN section.
Run the code in a new VS Code window. Preferably use a virtual environment to execute this code. Python is a prerequisite. To learn more, click here.
Execute the code using, the command
python <filename>.py #replace filename with the respective filename.
or click on the run button on the top right side of the Visual Studio Code window.
The response is now printed on the terminal.
Developing Basic Application:
Similarly, we can use it in applications as well. To demonstrate, lets build a basic application using Streamlit and python. Streamlit turns python scripts into shareable web apps in minutes. To know more click here. To install streamlit, use the following command in the python terminal/VS Code terminal.
pip install streamlit
The following script creates a web-based chat interface using streamlit where users can input queries, which are then sent to an AI model via a local OpenAI API server. The AI’s responses are displayed back in the chat interface, facilitating a conversational interaction.
import streamlit as st
from openai import OpenAI
client = OpenAI(
base_url=”http://127.0.0.1:5272/v1/”,
api_key=”xyz” # required by API but not used
)
st.title(“Chat with Phi-3”)
query = st.chat_input(“Enter query:”)
if query:
with st.chat_message(“user”):
st.write(query)
chat_completion = client.chat.completions.create(
messages=[
{“role”: “user”,”content”: “You are a helpful assistant and provides structured answers.”},
{“role”: “user”, “content”: query}
],
model=”Phi-3-mini-128k-cuda-int4-onnx”,
)
with st.chat_message(“assistant”):
st.write(chat_completion.choices[0].message.content)
Since the above code is using the streamlit, the startup command is also given in a different syntax, the command is as follows,
streamlit run <filename>.py #replace filename with the respective filename.
Upon successful execution, the streamlit pops up a new window in the Microsoft edge with the webpage.
This is how we can create GenAI applications by using the models running on local VS Code AI Toolkit environment. In the upcoming blog, lets see how to apply retrieval augmented generation using the AI Toolkit framework.
Microsoft Tech Community – Latest Blogs –Read More
calculated columns
Hello. I would like to know if sharepoint calculated columns can reference a previous element of that same column or another. In Excel, for example, I can make a formula that is B11=B10+A10.
But in a sharepoint list the column name is referenced to calculate something.
Thanks in advance
Hello. I would like to know if sharepoint calculated columns can reference a previous element of that same column or another. In Excel, for example, I can make a formula that is B11=B10+A10.
But in a sharepoint list the column name is referenced to calculate something.
Thanks in advance Read More
hotmail accounts
I am using e mail with my 2 hotmail accounts on my Apple i phone SE. Recently I have been unable to send mail getting a message saying that account passwords are incorrect. I’m wondering if this is anything related to the message I received from MS about third party platforms. I have read this message several times but am baffled by the jargon.
I am using e mail with my 2 hotmail accounts on my Apple i phone SE. Recently I have been unable to send mail getting a message saying that account passwords are incorrect. I’m wondering if this is anything related to the message I received from MS about third party platforms. I have read this message several times but am baffled by the jargon. Read More
How do I “auto populate” a field on Access Forms
When I select the drop-down menu under ‘Proto category’ I need to have ‘ category time’ auto-populate against what info it has. For example, they both share one table. One scenario would be ‘if the proto category is T1 then the category time is 3 hours’. My table has each row as to what it needs to be per category.
When I select the drop-down menu under ‘Proto category’ I need to have ‘ category time’ auto-populate against what info it has. For example, they both share one table. One scenario would be ‘if the proto category is T1 then the category time is 3 hours’. My table has each row as to what it needs to be per category. Read More
Date formatting
Hi
I need a formula that turns this value 20060323 (YYYMMDD) into a short date – 23/03/2006 (DD/MM/YYY)
I have had a google and a look on this messageboard but I haven’t had much luck.
Thank you
Hi I need a formula that turns this value 20060323 (YYYMMDD) into a short date – 23/03/2006 (DD/MM/YYY) I have had a google and a look on this messageboard but I haven’t had much luck. Thank you Read More
Displaying most recent value in a horizontal array?
Hi,
I have an array full of prices and 1 date column. I need to display the most recent value of each row’s array that are all equal to today’s date. I plan to sum all the numbers eventually.
Ex:
TODAY’S DATE: July 4th 2024
18-May$63.00$86.00
04-Jul$134.00$34.00$50.00 04-Jul$25.00
Output:
78
50
25
(Summed up this would be 153)
Thanks in advance!
Hi,I have an array full of prices and 1 date column. I need to display the most recent value of each row’s array that are all equal to today’s date. I plan to sum all the numbers eventually.Ex:TODAY’S DATE: July 4th 202404-Jul$14.00$45.00 78.0018-May$63.00$86.00$92.00 04-Jul$134.00$34.00$50.00 04-Jul$25.00 Output:785025(Summed up this would be 153)Thanks in advance! Read More
File Explorer windows pops up out of nowhere
Since a day or so, at seemingly random moments a File Explorer window pops up in front of everything. This started to happen shortly after I had installed ExplorerPatcher. I am 100% positive that it never happened before, I would have remembered.
This post You’re Not Alone: Windows 11 Is Randomly Opening File Explorer says that this is a Windows 11 issue (which seems unlikely to me as I never saw it before installing EP), and that it does not create a new window but only brings an existing window to the foreground (which is pertinently untrue, it does create a new file explorer window). Some further investigation suggests that it happens when an application that was using full screen switches back to normal display (at least that is how I can reliably reproduce it).
It is not a big deal but it’s annoying, and somewhat spoils my joy in having discovered ExplorerPatcher. Any ideas out there ?
Since a day or so, at seemingly random moments a File Explorer window pops up in front of everything. This started to happen shortly after I had installed ExplorerPatcher. I am 100% positive that it never happened before, I would have remembered. This post You’re Not Alone: Windows 11 Is Randomly Opening File Explorer says that this is a Windows 11 issue (which seems unlikely to me as I never saw it before installing EP), and that it does not create a new window but only brings an existing window to the foreground (which is pertinently untrue, it does create a new file explorer window). Some further investigation suggests that it happens when an application that was using full screen switches back to normal display (at least that is how I can reliably reproduce it). It is not a big deal but it’s annoying, and somewhat spoils my joy in having discovered ExplorerPatcher. Any ideas out there ? Read More