Tag Archives: microsoft
Struggling to link pop-up form to main form
Hello,
I’m struggling to properly link the selections made in a pop-up form to the main record.
I have set up the table “UNCategories” to house all the selections from the pop-up form … AND I have a main table, “RTTT,” where “TermID” is the primary key.
TermID is a foreign key in the UNCategories table … and UNCategoriesID is a foreign key in RTTT (the main table).
As you can see in the pic all the way at the bottom, the table UNCategories is registering the results, but when it comes to the record they relate to, nothing but zeros appear! So, I have a bunch of results, but no idea which record they belong to.
Any help would be greatly appreciated! If you need further screen grabs, please let me know.
Hello, I’m struggling to properly link the selections made in a pop-up form to the main record. I have set up the table “UNCategories” to house all the selections from the pop-up form … AND I have a main table, “RTTT,” where “TermID” is the primary key. TermID is a foreign key in the UNCategories table … and UNCategoriesID is a foreign key in RTTT (the main table). As you can see in the pic all the way at the bottom, the table UNCategories is registering the results, but when it comes to the record they relate to, nothing but zeros appear! So, I have a bunch of results, but no idea which record they belong to. Any help would be greatly appreciated! If you need further screen grabs, please let me know. Read More
Fundraising and Engagement solution will be retired
Hi
Has there been any partner announcements for the retirement of Fundraising and Engagement?
This is from a customer’s post on LinkedIn:
Fundraising and Engagement will be retired
Microsoft remains committed to providing affordable and relevant technology and skilling to nonprofit organizations worldwide. As we continue to innovate and enhance our technology offerings, we are making strategic updates to our suite of solutions. Notably, the Fundraising and Engagement solution will be retired, with technical support concluding at 11:59 PM PT (US) on December 31, 2026.
As of July 15, 2024, Microsoft will continue providing necessary security updates, but will not make additional enhancements to Fundraising and Engagement.
Between July 15, 2024, and December 31, 2026, you can continue to use Fundraising and Engagement, apply security updates as they are made available from Microsoft, and receive technical support from Microsoft. After December 31, 2026, Microsoft will no longer implement security updates for Fundraising and Engagement, and there will be no further technical support for the solution.
What action should your organization take?
We want to ensure that all customers have a successful path forward on the Microsoft Cloud for their organizational fundraising needs.
Customers currently using Fundraising and Engagement should work with their Microsoft Partner to identify the future configuration of Dynamics 365 Sales needed to meet their specific needs. If your organization does not have a Microsoft Partner, you can find a partner with knowledge of the Fundraising and Engagement solution at Microsoft.com/nonprofits.
Alternatively, customers can explore Microsoft partner solutions for donor management and fundraising built on Dynamics 365 Sales that have been specifically designed for customers transitioning from Fundraising and Engagement, including solutions from Barhead, mhance, and SylogistMission CRM. More solutions will be coming soon in the Partner solutions area of Solution Center.
If you have questions about these changes, please contact your Microsoft account team, your Microsoft Partner, or use this form to contact us.
Sincerely,
Microsoft Tech for Social Impact Team
Hi Has there been any partner announcements for the retirement of Fundraising and Engagement? This is from a customer’s post on LinkedIn: Fundraising and Engagement will be retiredMicrosoft remains committed to providing affordable and relevant technology and skilling to nonprofit organizations worldwide. As we continue to innovate and enhance our technology offerings, we are making strategic updates to our suite of solutions. Notably, the Fundraising and Engagement solution will be retired, with technical support concluding at 11:59 PM PT (US) on December 31, 2026.As of July 15, 2024, Microsoft will continue providing necessary security updates, but will not make additional enhancements to Fundraising and Engagement.Between July 15, 2024, and December 31, 2026, you can continue to use Fundraising and Engagement, apply security updates as they are made available from Microsoft, and receive technical support from Microsoft. After December 31, 2026, Microsoft will no longer implement security updates for Fundraising and Engagement, and there will be no further technical support for the solution.What action should your organization take?We want to ensure that all customers have a successful path forward on the Microsoft Cloud for their organizational fundraising needs.Customers currently using Fundraising and Engagement should work with their Microsoft Partner to identify the future configuration of Dynamics 365 Sales needed to meet their specific needs. If your organization does not have a Microsoft Partner, you can find a partner with knowledge of the Fundraising and Engagement solution at Microsoft.com/nonprofits.Alternatively, customers can explore Microsoft partner solutions for donor management and fundraising built on Dynamics 365 Sales that have been specifically designed for customers transitioning from Fundraising and Engagement, including solutions from Barhead, mhance, and SylogistMission CRM. More solutions will be coming soon in the Partner solutions area of Solution Center.If you have questions about these changes, please contact your Microsoft account team, your Microsoft Partner, or use this form to contact us.Sincerely,Microsoft Tech for Social Impact Team Read More
Formatting a Cell or Cells from the color pallete
For some reason I lost the capability of highlighting / coloring a cell or cells from the drop down menu above the spreadsheet. I had it previously but now I can select a cell but when selecting color it does not color the cell(s),
Please help, Thank you….
For some reason I lost the capability of highlighting / coloring a cell or cells from the drop down menu above the spreadsheet. I had it previously but now I can select a cell but when selecting color it does not color the cell(s),Please help, Thank you…. Read More
How do I set up a custom email inQᴜɪᴄᴋBᴏᴏᴋs?
To set up a custom email in QᴜɪᴄᴋBᴏᴏᴋs, follow these steps:
Open Preferences:
Open QᴜɪᴄᴋBᴏᴏᴋs and go to “Edit” > “Preferences.”Select “Send Forms” from the left menu.
Add Custom Email:
Under the “My Preferences” tab, click “Add” to set up a new email account.
Enter Email Information:
Enter your email address (e.g., email address removed for privacy reasons).Choose “Other” from the dropdown menu if your email provider is not listed.
Enter SMTP Server Details:
Obtain the SMTP server details from your email provider (reebsd.com).Typically, this includes the SMTP server address, port number, and SSL requirements.
if any problem you can call as
To set up a custom email in QᴜɪᴄᴋBᴏᴏᴋs, follow these steps:Open Preferences:Open QᴜɪᴄᴋBᴏᴏᴋs and go to “Edit” > “Preferences.”Select “Send Forms” from the left menu.Add Custom Email:Under the “My Preferences” tab, click “Add” to set up a new email account.Enter Email Information:Enter your email address (e.g., email address removed for privacy reasons).Choose “Other” from the dropdown menu if your email provider is not listed.Enter SMTP Server Details:Obtain the SMTP server details from your email provider (reebsd.com).Typically, this includes the SMTP server address, port number, and SSL requirements.if any problem you can call as Read More
How do I fix QᴜɪᴄᴋBᴏᴏᴋs Error 1304?
QᴜɪᴄᴋBᴏᴏᴋs Error 1304 occurs during installation and is typically due to issues with the installation CD or insufficient permissions. To fix it:
Copy Installation Files: Copy the QᴜɪᴄᴋBᴏᴏᴋs installation files from the CD to your hard drive and run the setup from there.Check Permissions: Ensure you have administrative rights on your computer.Repair .NET Framework: Use the Microsoft .NET Framework Repair Tool to fix any issues.Disable Security Software: Temporarily disable any antivirus or firewall software during installation.Clean Install: If the issue persists, perform a clean install of QᴜɪᴄᴋBᴏᴏᴋs using the QᴜɪᴄᴋBᴏᴏᴋs Clean Install Tool.
QᴜɪᴄᴋBᴏᴏᴋs Error 1304 occurs during installation and is typically due to issues with the installation CD or insufficient permissions. To fix it:Copy Installation Files: Copy the QᴜɪᴄᴋBᴏᴏᴋs installation files from the CD to your hard drive and run the setup from there.Check Permissions: Ensure you have administrative rights on your computer.Repair .NET Framework: Use the Microsoft .NET Framework Repair Tool to fix any issues.Disable Security Software: Temporarily disable any antivirus or firewall software during installation.Clean Install: If the issue persists, perform a clean install of QᴜɪᴄᴋBᴏᴏᴋs using the QᴜɪᴄᴋBᴏᴏᴋs Clean Install Tool. Read More
How to Quickly Access Journal Entries in QᴜɪᴄᴋBᴏᴏᴋs Online
To quickly access journal entries in QᴜɪᴄᴋBᴏᴏᴋs Online, follow these steps:
Login to QᴜɪᴄᴋBᴏᴏᴋs Online: Open QᴜɪᴄᴋBᴏᴏᴋs Online and log in to your account.
Go to the ‘New’ Button: Click on the ‘New’ button (+) at the left-hand corner of the dashboard.
Select ‘Journal Entry’: Under the ‘Other’ section, select ‘Journal Entry’. This will take you directly to the journal entry form.
View Existing Entries: To view existing journal entries, click on the ‘Reports’ tab on the left menu, search for ‘Journal’ in the search bar, and select the report.
These steps provide quick access to creating and viewing journal entries in QᴜɪᴄᴋBᴏᴏᴋs Online.
To quickly access journal entries in QᴜɪᴄᴋBᴏᴏᴋs Online, follow these steps:Login to QᴜɪᴄᴋBᴏᴏᴋs Online: Open QᴜɪᴄᴋBᴏᴏᴋs Online and log in to your account.Go to the ‘New’ Button: Click on the ‘New’ button (+) at the left-hand corner of the dashboard.Select ‘Journal Entry’: Under the ‘Other’ section, select ‘Journal Entry’. This will take you directly to the journal entry form.View Existing Entries: To view existing journal entries, click on the ‘Reports’ tab on the left menu, search for ‘Journal’ in the search bar, and select the report.These steps provide quick access to creating and viewing journal entries in QᴜɪᴄᴋBᴏᴏᴋs Online. Read More
WDK NuGet: A new way to develop drivers on Windows
We are excited to introduce the WDK NuGet, a new offering that enables developers to build drivers for Windows.
The WDK is the essential tool for developing, testing and deploying drivers on the Windows platform. It provides the headers, libraries, tools and metadata that you need to create drivers for Windows devices.
Previously, the WDK was available as an MSI installer or an ISO file.
The WDK NuGet contains the compiled code, libraries, headers, tools and metadata for driver development. You can easily consume the WDK NuGet package by adding it to your project and then calling its functionality in your project code.
The WDK NuGet offer some advantages over the traditional WDK offerings:
It is smaller in size, which reduces the download and setup time.
It is portable across different machines and environments.
It can be integrated with large CI/CD pipelines and source control systems.
It better support an agile WDK release model, it can be easily updated latest WDK features and fixes.
The WDK NuGet is now publicly available on nuget.org, where you can find the latest and previous versions of the package.
To get started with the WDK NuGet, you need to have Visual Studio 2022 or later installed on your machine. You can then follow the steps in this Microsoft Learn documentation to install the WDK NuGet package and create your first driver project.
We are also working on improving the developer experience while developing their driver projects from Visual Studio by adding WDK as a Visual Studio individual workload. This will make it easier to install and update the WDK NuGet package from the Visual Studio installer.
We hope you enjoy the WDK NuGet package and find it useful for your driver development needs. We welcome your feedback and suggestions on how to make it better.
Microsoft Tech Community – Latest Blogs –Read More
Setting Up CDC for Seamless Operations in Azure SQL Managed Instances with Failover Groups
Customers leverage Change Data Capture (CDC) with Azure SQL Managed Instance in various configurations. Although CDC operates smoothly after a local failover to a secondary replica in SQL Managed Instance Business Critical, it is not designed to function seamlessly after a geo failover within a Failover Group configuration. This applies to both General Purpose and Business Critical tiers. This step-by-step guide will assist you in configuring CDC to work seamlessly with a Failover Group configuration, ensuring that changes continue to be captured after a geo failover.
Prerequisites:
Two SQL MI instances configured as failover group partners.
A user database to be configured to capture changes, MyDB in this guide.
Login to the primary replica using SQL Server Management Studio (SSMS).
If CDC is not yet enabled on the primary instance target database, use the following command to configure the database for CDC. Ensure to replace MyDB with the name of the target database.
USE [MyDB]
EXEC sys.sp_cdc_enable_db
GO
Now that CDC is enabled at the database level, enable CDC on the specific tables to track. Use the following T-SQL code to add a table and replace mytable with your table name:
USE [MyDB]
EXEC sys.sp_cdc_enable_table
@source_schema = N’dbo’,
@source_name = N’mytable’,
@role_name = NULL,
@supports_net_changes = 1
GO
For a complete explanation of the above two TSQL statements please refer to the Microsoft documentation: Enable and Disable change data capture – SQL Server | Microsoft Learn
This step will create two SQL Agent jobs with names that contain the database name as can be seen below:
After enabling CDC on your database and tracking changes on tables, we will modify the default CDC configuration to make it failover group aware for seamless data capture after each failover.
Add a new step named Verify if primary replica to the capture job that will verify the current replica is the primary. This is required for ensuring the jobs only run on the primary replica, preventing unnecessary job failures or attempts to run CDC operations on the geo-secondary replica. Add the following T-SQL code as the new step command, replacing MyDB with your actual database name:
IF DATABASEPROPERTYEX(‘MyDB’, ‘Updateability’) <> ‘READ_WRITE’ THROW 50000, ‘This is not the primary replica.’, 1;
The new step will look like this:
Configure the new step to Quit the job reporting success in the On failure action of the Advanced page: Adjust the new step’s settings so that, if it fails due to the error thrown by the check (indicating the replica is not the primary), it quits reporting success. This change is necessary because the job isn’t supposed to be executed on non-primary replicas, and the “failure” is by design, not due to an actual error in job execution.
Note: Even though the job will quit reporting success every minute, the step itself will fail when running on the geo-secondary and the job history will contain entries like the ones shown below:
This is expected and monitoring may need to be adjusted accordingly to not alert in this specific step failure. During failover events, jobs may also fail due to the transient unavailability of the database and monitoring will need to be adjusted to contemplate these scenarios.
Configure the capture Job to start on step 1:Verify is primary replica. Move the new step Verify is primary replica to the top of the steps list, and configure the Start step to the be the new step. At this point, the steps of the capture job should look like this:
Repeat the same steps 4 through 6 above for the Cleanup Job. Remember to replace MyDB with your database name accordingly. The steps of the cleanup job should look like this:
Change the Retry attempts on the Change Data Capture Collection Agent to 0: This prevents the job from retrying after a failover, as the job’s continuation will be managed by the new primary replica. The change should look like this:
Add a new schedule to the capture job which attempts to start the job every minute. This is needed so that CDC begin capturing as soon as possible on the new primary replica after a failover event. Name it Start if primary replica. This new schedule should look like this:
Important note: If for any troubleshooting reason the capture job needs to be stopped for a certain amount of time, the way to accomplish it in the failover group will be to disable the Start if primary replica schedule in both primary and geo-secondary replicas by unchecking the Enabled box shown above. To resume CDC capture, enable the schedule again in both places.
Remove the original schedule named CDC Capture agent schedule to prevent the Capture Job from running when each replica starts.
At this point, the capture job schedules should look like this:
Script out both CDC jobs on the primary replica (Capture and Cleanup jobs) so they can be created on the geo-secondary later. This can be done by expanding the SQL Server Agent node in Object Explorer and scripting out the job as seen in the screenshot below:
Capture the content of cdc_jobs table on the primary to populate later the geo-secondary. Replace MyDB with your database name, execute the T-SQL code below on the primary replica, and copy and save for later the INSERT statement generated in the results:
DECLARE @Database NVARCHAR(255) = ‘MyDB’/*<<Your DATABASE NAME goes here*/
, @Fields NVARCHAR(200) = ‘[job_type], [job_id], [maxtrans], [maxscans], [continuous], [pollinginterval], [retention], [threshold]’
, @SQL NVARCHAR(1000);
SET @SQL = ‘SET NOCOUNT ON;
DECLARE @Insert VARCHAR(MAX);
SELECT @Insert = ISNULL(@Insert + ” UNION ”, ”INSERT INTO msdb.dbo.cdc_jobs([database_id], ‘
+ @Fields + ‘)”) + CHAR(13) + CHAR(10) + ”SELECT DB_ID(””’ + @Database + ””’),” + ‘
+ REPLACE(REPLACE(REPLACE(@Fields, ‘,’, ‘ + ”, ” + ‘), ‘[‘, ””””’ + CAST(‘),’]’,’ AS VARCHAR(max)) + ””””’)
+ ‘ FROM msdb.dbo.cdc_jobs WHERE database_id = DB_ID(”’ + @Database + ”’);
PRINT @Insert’;
EXEC sp_executesql @SQL;
Below is an example of executing the T-SQL code. Note the INSERT INTO statement under Messages:
Connect to the geo-secondary and run the following query to confirm CDC has been enabled on the geo-secondary as well. The column is_cdc_enabled should be 1 for your database:
SELECT name, is_cdc_enabled FROM sys.databases;
Create both the CDC SQL Agent jobs on the geo-secondary using the scripts generated on the primary replica previously in step 11. Connect to the geo-secondary replica and:
Run the script to create the capture job.
Run the script to create the cleanup job.
Verify both jobs are listed under SQL Server Agent – Jobs in SSMS.
Note: If you ever remove CDC from these failover group replicas, do it on the primary replica and delete the two jobs manually on the geo-secondary since sp_cdc_disable_db will not remove the jobs on the geo-secondary replica.
Create the cdc_jobs table in the geo-secondary MSDB database. Execute the following T-SQL code, replacing MyDB with your actual database name to create this table on the geo-secondary:
USE [msdb]
GO
CREATE TABLE [dbo].[cdc_jobs] (
[database_id] [int] NOT NULL
, [job_type] [nvarchar](20) NOT NULL
, [job_id] [uniqueidentifier] NULL
, [maxtrans] [int] NULL
, [maxscans] [int] NULL
, [continuous] [bit] NULL
, [pollinginterval] [bigint] NULL
, [retention] [bigint] NULL
, [threshold] [bigint] NULL
, PRIMARY KEY CLUSTERED ([database_id] ASC, [job_type] ASC)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY];
Insert in the cdc_jobs table on the geo-secondary the data captured on the primary. Execute the INSERT statement captured in the results of step 12 on the MSDB database of the geo-secondary and verify that the cdc_jobs table content is the same on both replicas. An example of the content of the cdc_jobs table after inserting the rows can be seen below.
Update the cdc_jobs table in the MSDB on the geo-secondary to reflect the correct job IDs. Run the following T-SQL code on the geo-secondary to update cdc_jobs table so it contains the job identifications of the jobs on the geo-secondary instead of the primary. Remember to replace MyDB with your actual database name:
UPDATE c
SET c.job_id = s.job_id
FROM msdb.dbo.sysjobs s
JOIN msdb.dbo.cdc_jobs c
ON s.name = ‘cdc.’ + DB_NAME(c.database_id) + ‘_’ + c.job_type
WHERE DB_NAME(c.database_id) = ‘MyDB’;
Create the cdc_jobs_view system view in the MSDB database on the geo-secondary which is required by the CDC SQL Agent Jobs:
USE [msdb]
GO
CREATE VIEW dbo.cdc_jobs_view AS
SELECT
[database_id],
[job_type],
[job_id],
[maxtrans],
[maxscans],
[continuous],
[pollinginterval],
[retention],
[threshold]
FROM dbo.cdc_jobs;
All configurations have been completed to configure CDC for SQL Managed Instance Failover Group. After every geo failover, CDC will resume capturing within the next minute on the new primary replica. The data changes are still logged in the transaction log as usual so there is no data capture loss.
This content includes materials and contributions from Yvonne Vanslageren.
Feedback and suggestions
If you have feedback or suggestions for improving this data migration asset, please contact the Azure Databases SQL Customer Success Engineering Team. Thanks for your support!
Microsoft Tech Community – Latest Blogs –Read More
Hᴏᴡ Dᴏ I Cʀᴇᴀᴛᴇ ᴀɴᴅ Sᴇɴᴅ ᴀɴ Aᴄᴄᴏᴜɴᴛᴀɴᴛ’s Cᴏᴘʏ ɪɴ Qᴜɪᴄᴋ_B000ᴋs﹖
To create and send an Accountant’s Copy in Qᴜɪᴄᴋ_B000ᴋs, follow these steps:
Open Qᴜɪᴄᴋ_B000ᴋs: Go to the “File” menu.Select Accountant’s Copy: Choose “Send Company File” then “Accountant’s Copy.”Set Dividing Date: Choose a dividing date and click “Next.”Send via Accountant’s Copy File Transfer (ACFT): Follow the prompts to enter your accountant’s email address and send the file directly.Alternatively, Save Locally: Save the file locally and send it via email or other means.
For further assistance, consult Qᴜɪᴄᴋ_B000ᴋs support.
To create and send an Accountant’s Copy in Qᴜɪᴄᴋ_B000ᴋs, follow these steps:Open Qᴜɪᴄᴋ_B000ᴋs: Go to the “File” menu.Select Accountant’s Copy: Choose “Send Company File” then “Accountant’s Copy.”Set Dividing Date: Choose a dividing date and click “Next.”Send via Accountant’s Copy File Transfer (ACFT): Follow the prompts to enter your accountant’s email address and send the file directly.Alternatively, Save Locally: Save the file locally and send it via email or other means.For further assistance, consult Qᴜɪᴄᴋ_B000ᴋs support. Read More
How to prevent video from being cropped in a Teams recording?
Recently we recorded a video of a meeting. The meeting was hybrid where 4 of the main presenters were seated in the front of the room. We positioned the camera to have all 4 presenters in view. The output was correctly displayed in the room and on a separate laptop (all 4 presenters could be seen at all times). Upon reviewing the recording, only 1.5 of the presenters were visible, even when one of the other presenters was speaking.
It seems that the “Fill frame” feature enabled itself for the recording, despite the person who recorded the meeting verifying that the “Fit to frame” option was selected on his device before recording.
Is there a way to prevent videos from being automatically cropped in recordings?
Recently we recorded a video of a meeting. The meeting was hybrid where 4 of the main presenters were seated in the front of the room. We positioned the camera to have all 4 presenters in view. The output was correctly displayed in the room and on a separate laptop (all 4 presenters could be seen at all times). Upon reviewing the recording, only 1.5 of the presenters were visible, even when one of the other presenters was speaking. It seems that the “Fill frame” feature enabled itself for the recording, despite the person who recorded the meeting verifying that the “Fit to frame” option was selected on his device before recording. Is there a way to prevent videos from being automatically cropped in recordings? Read More
How to Restore a QᴜɪᴄᴋBᴏᴏᴋs Portable Company File: Step-by-Step Guide
Restoring a QᴜɪᴄᴋBᴏᴏᴋs portable company file is a streamlined process that ensures your data is efficiently imported into QᴜɪᴄᴋBᴏᴏᴋs Desktop. Begin by launching QᴜɪᴄᴋBᴏᴏᴋs and selecting “File” from the menu. Next, choose “Open or Restore Company” and opt for “Restore a portable file (.QBM).” Locate the .QBM file on your computer that you wish to restore and click “Open.” QᴜɪᴄᴋBᴏᴏᴋs will prompt you to select a destination folder for the restored company file; choose an appropriate location and click “Save.” Follow any additional on-screen instructions to finalize the restoration process. Once completed, your QᴜɪᴄᴋBᴏᴏᴋs portable company file will be restored, allowing you to resume working with your financial data seamlessly. This method is ideal for transferring files between different QᴜɪᴄᴋBᴏᴏᴋs installations or for creating backups that can be easily transported or shared.
Restoring a QᴜɪᴄᴋBᴏᴏᴋs portable company file is a streamlined process that ensures your data is efficiently imported into QᴜɪᴄᴋBᴏᴏᴋs Desktop. Begin by launching QᴜɪᴄᴋBᴏᴏᴋs and selecting “File” from the menu. Next, choose “Open or Restore Company” and opt for “Restore a portable file (.QBM).” Locate the .QBM file on your computer that you wish to restore and click “Open.” QᴜɪᴄᴋBᴏᴏᴋs will prompt you to select a destination folder for the restored company file; choose an appropriate location and click “Save.” Follow any additional on-screen instructions to finalize the restoration process. Once completed, your QᴜɪᴄᴋBᴏᴏᴋs portable company file will be restored, allowing you to resume working with your financial data seamlessly. This method is ideal for transferring files between different QᴜɪᴄᴋBᴏᴏᴋs installations or for creating backups that can be easily transported or shared. Read More
Why Am I Unable to Create an Accountant’s Copy in QuiCk- B00ks?
If you’re unable to create an Accountant’s Copy in QuiCk- B00ks, try the following solutions:
Update QuiCk- B00ks: Ensure you have the latest QuiCk- B00ks updates installed.Check File Name: Ensure the company file name doesn’t have special characters.Verify File Size: Large files can cause issues. Try reducing the file size.Disable Hosting: Go to “File” > “Utilities” and ensure hosting is off.Check Network Settings: Ensure network settings allow QuiCk- B00ks communication.Run File Doctor: Use QuiCk- B00ks File Doctor to repair any file issues.
For additional support, contact QuiCk- B00ks support.
If you’re unable to create an Accountant’s Copy in QuiCk- B00ks, try the following solutions:Update QuiCk- B00ks: Ensure you have the latest QuiCk- B00ks updates installed.Check File Name: Ensure the company file name doesn’t have special characters.Verify File Size: Large files can cause issues. Try reducing the file size.Disable Hosting: Go to “File” > “Utilities” and ensure hosting is off.Check Network Settings: Ensure network settings allow QuiCk- B00ks communication.Run File Doctor: Use QuiCk- B00ks File Doctor to repair any file issues.For additional support, contact QuiCk- B00ks support. Read More
How do I update QᴜɪᴄᴋBᴏᴏᴋs Desktop?
To update QᴜɪᴄᴋBᴏᴏᴋs Desktop, follow these steps:
Automatic Updates:
Open QᴜɪᴄᴋBᴏᴏᴋs Desktop.Go to “Help” > “Update QᴜɪᴄᴋBᴏᴏᴋs Desktop.”Click “Update Now” and select “Get Updates.”Restart QᴜɪᴄᴋBᴏᴏᴋs when the update completes, and click “Install Now” if prompted.
Manual Updates:
Visit the QᴜɪᴄᴋBᴏᴏᴋs Downloads & Updates page.Select your QᴜɪᴄᴋBᴏᴏᴋs product and version, then click “Search.”Download the update file and run it to install the latest updates.
Verify Updates:
After updating, open QᴜɪᴄᴋBᴏᴏᴋs, go to “Help” > “Update QᴜɪᴄᴋBᴏᴏᴋs Desktop,” and check the “Overview” tab to confirm that the latest version is installed.
Keeping QᴜɪᴄᴋBᴏᴏᴋs Desktop updated ensures you have the latest features and security enhancements.
To update QᴜɪᴄᴋBᴏᴏᴋs Desktop, follow these steps:Automatic Updates:Open QᴜɪᴄᴋBᴏᴏᴋs Desktop.Go to “Help” > “Update QᴜɪᴄᴋBᴏᴏᴋs Desktop.”Click “Update Now” and select “Get Updates.”Restart QᴜɪᴄᴋBᴏᴏᴋs when the update completes, and click “Install Now” if prompted.Manual Updates:Visit the QᴜɪᴄᴋBᴏᴏᴋs Downloads & Updates page.Select your QᴜɪᴄᴋBᴏᴏᴋs product and version, then click “Search.”Download the update file and run it to install the latest updates.Verify Updates:After updating, open QᴜɪᴄᴋBᴏᴏᴋs, go to “Help” > “Update QᴜɪᴄᴋBᴏᴏᴋs Desktop,” and check the “Overview” tab to confirm that the latest version is installed.Keeping QᴜɪᴄᴋBᴏᴏᴋs Desktop updated ensures you have the latest features and security enhancements. Read More
Auto-populate row completion?
Hi there,
I have a SharePoint list where the columns are Create Date, Request #, and 5 employee names. Each employee goes into the list and marks if he or she has completed the request, or not.
What I Want: I want to add a column titled “Status” where it will automatically fill in the words “Selections Complete” when all 5 employees have made a selection. If possible, also send an email to a recipient of my choice. It doesn’t matter if they choose Complete or Not – all that matters is that they have made a selection of Complete or No.
Is this possible? I understand the list I made is a little bit unorthodox with each employee being a column.
Thanks.
Hi there, I have a SharePoint list where the columns are Create Date, Request #, and 5 employee names. Each employee goes into the list and marks if he or she has completed the request, or not. What I Want: I want to add a column titled “Status” where it will automatically fill in the words “Selections Complete” when all 5 employees have made a selection. If possible, also send an email to a recipient of my choice. It doesn’t matter if they choose Complete or Not – all that matters is that they have made a selection of Complete or No. Is this possible? I understand the list I made is a little bit unorthodox with each employee being a column. Thanks. Read More
How do I fix QᴜɪᴄᴋBᴏᴏᴋs Error Code 102?
QᴜɪᴄᴋBᴏᴏᴋs Error Code 102 indicates an issue with online banking, often due to server problems or maintenance at your bank’s end. To fix it, follow these steps:
Check Bank Website:
Log in to your bank’s website to ensure there are no alerts or maintenance notifications.Verify you can access your account without issues.
Update QᴜɪᴄᴋBᴏᴏᴋs:
In QᴜɪᴄᴋBᴏᴏᴋs Online, go to the “Banking” tab.Click “Update” to refresh your bank connection.
Wait and Retry:
If the bank is undergoing maintenance, wait a few hours and try updating again.
Verify Account Info:
Ensure your bank account information and login credentials in QᴜɪᴄᴋBᴏᴏᴋs are accurate and up-to-date.
Contact Support:
If the issue persists, contact QᴜɪᴄᴋBᴏᴏᴋs support or your bank to check for ongoing issues and get further assistance.
These steps should help resolve Error Code 102 and restore your bank connection in QᴜɪᴄᴋBᴏᴏᴋs.
QᴜɪᴄᴋBᴏᴏᴋs Error Code 102 indicates an issue with online banking, often due to server problems or maintenance at your bank’s end. To fix it, follow these steps:Check Bank Website:Log in to your bank’s website to ensure there are no alerts or maintenance notifications.Verify you can access your account without issues.Update QᴜɪᴄᴋBᴏᴏᴋs:In QᴜɪᴄᴋBᴏᴏᴋs Online, go to the “Banking” tab.Click “Update” to refresh your bank connection.Wait and Retry:If the bank is undergoing maintenance, wait a few hours and try updating again.Verify Account Info:Ensure your bank account information and login credentials in QᴜɪᴄᴋBᴏᴏᴋs are accurate and up-to-date.Contact Support:If the issue persists, contact QᴜɪᴄᴋBᴏᴏᴋs support or your bank to check for ongoing issues and get further assistance.These steps should help resolve Error Code 102 and restore your bank connection in QᴜɪᴄᴋBᴏᴏᴋs. Read More
Why Is My Q uick=B00ks Automatic Backup Not Working?
If your Q uick=B00ks automatic backup is not working, it could be due to several reasons:
Outdated Q uick=B00ks : Ensure you have the latest updates installed.Incorrect Backup Settings: Verify your automatic backup settings are correctly configured.Insufficient Permissions: Run Q uick=B00ks as an administrator to grant necessary permissions.File Corruption: Use Q uick=B00ks File Doctor to check and repair any file issues.Storage Issues: Ensure there is enough space on the backup destination drive.
Solution:
Open Q uick=B00ks , go to “File” > “Back Up Company” > “Create Local Backup.”Click “Options” to set your preferences and ensure the destination path is correct.Save and verify the backup.
For further help, contact Q uick=B00ks support.
If your Q uick=B00ks automatic backup is not working, it could be due to several reasons:Outdated Q uick=B00ks : Ensure you have the latest updates installed.Incorrect Backup Settings: Verify your automatic backup settings are correctly configured.Insufficient Permissions: Run Q uick=B00ks as an administrator to grant necessary permissions.File Corruption: Use Q uick=B00ks File Doctor to check and repair any file issues.Storage Issues: Ensure there is enough space on the backup destination drive.Solution:Open Q uick=B00ks , go to “File” > “Back Up Company” > “Create Local Backup.”Click “Options” to set your preferences and ensure the destination path is correct.Save and verify the backup.For further help, contact Q uick=B00ks support. Read More
How do I set up email in QᴜɪᴄᴋBᴏᴏᴋs?
To set up email in QᴜɪᴄᴋBᴏᴏᴋs, follow these steps:
Open Preferences:
Open QᴜɪᴄᴋBᴏᴏᴋs and go to “Edit” > “Preferences.”Select “Send Forms” from the left menu.
Choose Email Provider:
Under the “My Preferences” tab, select your email provider (WebMail, Outlook, or QᴜɪᴄᴋBᴏᴏᴋs Email).
Set Up WebMail:
If using WebMail (e.g., Gmail, Yahoo), click “Add.”Enter your email address and select your provider from the dropdown menu.QᴜɪᴄᴋBᴏᴏᴋs will auto-fill the SMTP server details; confirm and enter your email password.Click “OK” and then “OK” again to save your settings.
Set Up Outlook:
If using Outlook, ensure Outlook is installed and set as your default email program.QᴜɪᴄᴋBᴏᴏᴋs will automatically sync with Outlook for sending emails.
Test Email:
Test the email setup by sending a test email. Go to “File” > “Send Forms” and select a form to send.
These steps will enable you to send invoices, estimates, and other forms directly from QᴜɪᴄᴋBᴏᴏᴋs using your preferred email service.
To set up email in QᴜɪᴄᴋBᴏᴏᴋs, follow these steps:Open Preferences:Open QᴜɪᴄᴋBᴏᴏᴋs and go to “Edit” > “Preferences.”Select “Send Forms” from the left menu.Choose Email Provider:Under the “My Preferences” tab, select your email provider (WebMail, Outlook, or QᴜɪᴄᴋBᴏᴏᴋs Email).Set Up WebMail:If using WebMail (e.g., Gmail, Yahoo), click “Add.”Enter your email address and select your provider from the dropdown menu.QᴜɪᴄᴋBᴏᴏᴋs will auto-fill the SMTP server details; confirm and enter your email password.Click “OK” and then “OK” again to save your settings.Set Up Outlook:If using Outlook, ensure Outlook is installed and set as your default email program.QᴜɪᴄᴋBᴏᴏᴋs will automatically sync with Outlook for sending emails.Test Email:Test the email setup by sending a test email. Go to “File” > “Send Forms” and select a form to send.These steps will enable you to send invoices, estimates, and other forms directly from QᴜɪᴄᴋBᴏᴏᴋs using your preferred email service. Read More
What is the QᴜɪᴄᴋBᴏᴏᴋs Migration Tool and how do I use it?
The QᴜɪᴄᴋBᴏᴏᴋs Migration Tool is a utility that helps you transfer your QᴜɪᴄᴋBᴏᴏᴋs Desktop installation, including data files, to a new computer. To use it, follow these steps:
Prepare for Migration:
On your old computer, open QᴜɪᴄᴋBᴏᴏᴋs and go to “File” > “Utilities” > “Move QᴜɪᴄᴋBᴏᴏᴋs to another computer.”Follow the prompts to create a one-time password and copy the migration tool installer and your QᴜɪᴄᴋBᴏᴏᴋs data to a USB drive.
Run Migration Tool on New Computer:
Insert the USB drive into your new computer.Open the USB drive and run the QᴜɪᴄᴋBᴏᴏᴋs Migration Tool installer.Enter the one-time password you created earlier.
Complete Migration:
Follow the on-screen instructions to transfer QᴜɪᴄᴋBᴏᴏᴋs and your data files to the new computer.The tool will install QᴜɪᴄᴋBᴏᴏᴋson your new computer and move your data files.
Verify Installation:
Open QᴜɪᴄᴋBᴏᴏᴋs on the new computer to ensure all your data has been transferred correctly.Update QᴜɪᴄᴋBᴏᴏᴋs to the latest version if needed.
These steps will help you seamlessly migrate QᴜɪᴄᴋBᴏᴏᴋs Desktop to a new computer, ensuring all your data and settings are preserved.
The QᴜɪᴄᴋBᴏᴏᴋs Migration Tool is a utility that helps you transfer your QᴜɪᴄᴋBᴏᴏᴋs Desktop installation, including data files, to a new computer. To use it, follow these steps:Prepare for Migration:On your old computer, open QᴜɪᴄᴋBᴏᴏᴋs and go to “File” > “Utilities” > “Move QᴜɪᴄᴋBᴏᴏᴋs to another computer.”Follow the prompts to create a one-time password and copy the migration tool installer and your QᴜɪᴄᴋBᴏᴏᴋs data to a USB drive.Run Migration Tool on New Computer:Insert the USB drive into your new computer.Open the USB drive and run the QᴜɪᴄᴋBᴏᴏᴋs Migration Tool installer.Enter the one-time password you created earlier.Complete Migration:Follow the on-screen instructions to transfer QᴜɪᴄᴋBᴏᴏᴋs and your data files to the new computer.The tool will install QᴜɪᴄᴋBᴏᴏᴋson your new computer and move your data files.Verify Installation:Open QᴜɪᴄᴋBᴏᴏᴋs on the new computer to ensure all your data has been transferred correctly.Update QᴜɪᴄᴋBᴏᴏᴋs to the latest version if needed.These steps will help you seamlessly migrate QᴜɪᴄᴋBᴏᴏᴋs Desktop to a new computer, ensuring all your data and settings are preserved. Read More
Introducing Windows 11 checkpoint cumulative updates
We’re excited to further optimize the delivery of continuous innovation in Windows 11 with new checkpoint cumulative updates.[1] As early as late 2024, you will automatically get this optimization on any devices running Windows 11, version 24H2 or later, as well as on Windows Server 2025. Keeping your organization updated and secure will involve smaller, faster, and more sustainable updates, with no action required from you. Keep reading to learn how you can preview this experience today in Windows Insider Preview Build 26120.1252 (Dev Channel).
Tip: Windows 11, version 24H2 will be available as a traditional feature update to all devices later this year.
Checkpoint cumulative updates explained
Windows 11 quality updates use servicing technology and are built cumulatively from the time when a new Windows OS was “released to manufacturing” (RTM). These monthly updates include all the changes since RTM in the form of binary differentials computed from the initial version of those binaries.
Tip: Review how quality updates work in Windows monthly updates explained.
With Windows 11, version 24H2, we’re introducing a new concept of checkpoint cumulative updates. This will allow you to get features and security enhancements via the latest cumulative update through smaller, incremental differentials containing only the changes since the previous checkpoint cumulative update. This means that you can save time, bandwidth, and hard drive space.
Going forward, Microsoft might periodically release cumulative updates as checkpoints. The subsequent updates will then consist of:
The update package files associated with the checkpoints
New update package files that contain incremental binary differentials against the version of binaries in the last checkpoint
This process may be repeated multiple times, thereby generating multiple checkpoints during the lifecycle of a given Windows release. The Windows 11, version 24H2 servicing stack can merge all the checkpoints and only download and install content that’s missing on the device.
Managing cumulative updates
If you manage updates with Windows Update, Windows Update for Business, Windows Autopatch, or Windows Server Update Services (WSUS), these new developments do not require any changes or actions on your part. They will simply appear as a normal monthly update, only improved. You can continue to use the same tools and processes that you currently use for approving and deploying updates.
Remember, this applies to your devices running Windows 11, version 24H2 or later, as well as Windows Server 2025. You can preview this experience today with Windows Insider Preview Build 26120.1252 (Dev Channel).
If you source updates from the Microsoft Update Catalog, you’ll notice that a given monthly update may contain more than one update package file available for download. There will be one file for each checkpoint, plus an additional file that contains cumulative payload from the latest checkpoint. You will be able to install all files sequentially using existing deployment tools.
If you are running other versions of Windows 10 or Windows 11 (earlier than version 24H2), the process of updating will be similar to previous monthly updates or annual Windows 11 feature updates.
Benefits of checkpoint cumulative updates
Now your organization can stay current with the latest feature and security enhancements in improved ways. Specifically, you get even smaller downloads to Windows devices, sustainable redistribution of updates within your infrastructure, and a better update experience for annual feature updates.
Smaller downloads to the clients
Previously with Windows 11, version 21H2, we introduced smaller downloads to Windows devices by doing range reads to only download and install binary differentials missing on the device. These binary differentials are computed against the RTM version of the binaries. When Windows 11 24H2 cumulative update is released as a checkpoint, the binary differentials in subsequent cumulative updates are generated against the version of binaries in the latest checkpoint instead of the RTM version. Therefore, these differentials are smaller and faster to apply on devices that have already synced to the latest checkpoint cumulative update.
Tip: For a refresher on prior improvements, refer to Windows 11 cumulative updates improvements: an overview and Faster. Smaller. Windows 11, version 22H2 update fundamentals.
Server-side sustainable redistribution
Up to this point, updates have been packaged in a single file that continues to grow over time. This file is downloaded or cached on to the distribution points for redistribution whether they’re Microsoft front-end servers or your remote branch offices. For subsequent updates after a checkpoint, you don’t need to redistribute all the content accumulated since RTM. Once you download a checkpoint file, you can use file-level deduplication to only download incremental files in the subsequent updates. Reserve valuable energy resources only for what’s necessary.
Optimized and sustained feature update delivery via enablement packages
When an annual feature update is delivered using servicing technology and an enablement package, this new release shares a common core operating system with the previous release.[2] This means that it also shares the same monthly updates. The result is single update files become increasingly larger and more impactful with every new release that has its own servicing lifecycle.
When a checkpoint is introduced in alignment with the availability of a feature update with an enablement package, the monthly updates for those releases can start fresh and small. This means that Microsoft can scale to more enablement packages for feature updates, and you can adopt them faster, more easily, and more efficiently than a traditional feature update.
These optimizations are especially designed to help your organization to adopt the continuous innovation model of Windows 11. With annual enablement-package–based feature updates, you can improve your security posture and compliance by ensuring that your devices are always running the latest of Windows 11.
Get ready
We encourage you to check out the preview experience today in Windows Insider Preview Build 26120.1252 (Dev Channel).
We’re passionate about keeping your device protected and productive. As the teams that bring you Windows updates every month, we’ve embraced continuous delivery of innovation and make improvements regularly. We’re excited about this newest innovation for cumulative updates, and we hope that you try Windows 11 checkpoint cumulative updates soon!
[1] Read about Delivering continuous innovation in Windows 11.
[2] To review how enablement packages work, see What’s new for IT pros in Windows 11, version 23H2 and KB5027397.
Continue the conversation. Find best practices. Bookmark the Windows Tech Community, then follow us @MSWindowsITPro on X and on LinkedIn. Looking for support? Visit Windows on Microsoft Q&A.
Microsoft Tech Community – Latest Blogs –Read More
