Category: Microsoft
Category Archives: Microsoft
Document hyperlink from document properties
Do you have any ideas to create a Hyperlink from document properties in modern view as it is in classic view? See examples below
Modern mode:
Classic mode:
Do you have any ideas to create a Hyperlink from document properties in modern view as it is in classic view? See examples below Modern mode:Classic mode: Read More
Best practices for honeytoken device
We just tried the honeytoken device feature of MDI by setting up a new domain-joined server with a fake file share opened up to everyone.
But we’re now getting ‘Honeytoken authentication activity on one endpoint’ incidents because there is kerberos activity to the domain controllers. But this activity makes sense since it’s domain-joined…
Shouldn’t you be joining these honeytoken devices to the domain or what are the best practises?
It seems there isn’t much documentation around setting up honeytoken devices. Most article describe setting up accounts.
We just tried the honeytoken device feature of MDI by setting up a new domain-joined server with a fake file share opened up to everyone. But we’re now getting ‘Honeytoken authentication activity on one endpoint’ incidents because there is kerberos activity to the domain controllers. But this activity makes sense since it’s domain-joined… Shouldn’t you be joining these honeytoken devices to the domain or what are the best practises?It seems there isn’t much documentation around setting up honeytoken devices. Most article describe setting up accounts. Read More
Onedrive app crashes entire PC
So this is my problem:
I had a sync issue where OneDrive was stuck on sync, without moving at all.
While troubleshooting that problem I was prompted to unlink and re-link my device.
after re-linking, I let OneDrive run all night to resync, when i came back to the PC in the morning i was greeted by a blue screen of death.
Since then, I have discovered that when it tries to sync, my entire PC crashes.
I cannot access any settings since settings aren’t accessible when sync is paused.
please help me with this godawful program
So this is my problem:I had a sync issue where OneDrive was stuck on sync, without moving at all.While troubleshooting that problem I was prompted to unlink and re-link my device.after re-linking, I let OneDrive run all night to resync, when i came back to the PC in the morning i was greeted by a blue screen of death.Since then, I have discovered that when it tries to sync, my entire PC crashes.I cannot access any settings since settings aren’t accessible when sync is paused.please help me with this godawful program Read More
Windows Server 2025 and beyond
Windows Server 2025 is the most secure and performant release yet! Download the evaluation now!
Looking to migrate from VMware to Windows Server 2025? Contact your Microsoft account team!
Looking to migrate from VMware to Windows Server 2025? Contact your Microsoft account team!
The 2024 Windows Server Summit was held in March and brought three days of demos, technical sessions, and Q&A, led by Microsoft engineers, guest experts from Intel®, and our MVP community. For more videos from this year’s Windows Server Summit, please find the full session list here.
This article focuses on what’s new and what’s coming in Windows Server 2025.
What’s new in Windows Server 2025
Get a closer look at Windows Server 2025. Explore improvements, enhancements, and new capabilities. We’ll walk you through the big picture and offer a guide to which Windows Server Summit sessions will help you learn more.
What’s ahead for Windows Server
What’s in it for you? Get a summary of the most important features coming in Windows Server 2025 that will make your life easier and your work more impactful. In this fireside chat, Hari Pulapaka, Windows Server GM and Jeff Woolsey, Principal PM manager, provide an overview of what’s next, and provide their thoughts on how Windows Server can help you stay ahead.
Microsoft Tech Community – Latest Blogs –Read More
Is there a fully EOP functionallity at SMTP-relay and how are the limits?
Hi Everybody,
we are considering to use the SMTP-functionality of ExO to drive mails additionally from a local server. The SMTP relay is described as one of three solutions on this site:
These three solutions are possible:
– SMTP client submission
– Direct send
– SMTP relay
SMTP relay seems to be the unrecommended solution of these three, but it is useful in some cases. In one row is the hint, that there is no possibility to bypass the antispam functionality. The question is here: Is this a fully activated EOP? I ask because normally you have to license the standalone version of EOP for on prem environments (it’s not really a cheap service). And for the the SMTP relay solution there is no ExO License needed, which always would include the EOP.
Is this EOP for free? Or what else is it? It is not clear described.
Another question is regarding the limits. In the linked site you can find regarding this “Reasonable limits are imposed.” Does anyone has further information about it? It is also not described and some people say, there is no limit, some other say the limits will come soon (1st of January 2025). I really don’t want to take advantage of this system but i need to know the facts about it.
Thanks for any contribution!
Hi Everybody, we are considering to use the SMTP-functionality of ExO to drive mails additionally from a local server. The SMTP relay is described as one of three solutions on this site: How to set up a multifunction device or application to send emails using Microsoft 365 or Office 365 | Microsoft Learn These three solutions are possible:- SMTP client submission- Direct send- SMTP relay SMTP relay seems to be the unrecommended solution of these three, but it is useful in some cases. In one row is the hint, that there is no possibility to bypass the antispam functionality. The question is here: Is this a fully activated EOP? I ask because normally you have to license the standalone version of EOP for on prem environments (it’s not really a cheap service). And for the the SMTP relay solution there is no ExO License needed, which always would include the EOP. Is this EOP for free? Or what else is it? It is not clear described. Another question is regarding the limits. In the linked site you can find regarding this “Reasonable limits are imposed.” Does anyone has further information about it? It is also not described and some people say, there is no limit, some other say the limits will come soon (1st of January 2025). I really don’t want to take advantage of this system but i need to know the facts about it. Thanks for any contribution! Read More
Excel or Number querry
Hii
I want to show a number like 1234567 as 12,00,000…
Please help me, how could change the number as required as above (in excel)……..
HiiI want to show a number like 1234567 as 12,00,000… Please help me, how could change the number as required as above (in excel)…….. Read More
Bug with entra shared IOS and teams?
Have IPhones setup using the entra shared mode, everything works great at a base level. Devices get configured to be in shared mode, sso works like a charm for edge and the first user into teams, device gets that user logged out and next user signs in, again edge detects and user is signed in but when you open a teams it’s looking for a email address, if you force close teams it triggers the sso extension and the user gets logged in. Cannot for the life of me figure out why teams ends up in a state where it’s logged out but unable to gets the user creds passed to it. This was not an issue in the past. A reminder this is not iPad shared mode I’m talking about, people get them confused.
Have IPhones setup using the entra shared mode, everything works great at a base level. Devices get configured to be in shared mode, sso works like a charm for edge and the first user into teams, device gets that user logged out and next user signs in, again edge detects and user is signed in but when you open a teams it’s looking for a email address, if you force close teams it triggers the sso extension and the user gets logged in. Cannot for the life of me figure out why teams ends up in a state where it’s logged out but unable to gets the user creds passed to it. This was not an issue in the past. A reminder this is not iPad shared mode I’m talking about, people get them confused. Read More
(help) How to add your own Power Automate flows in “apps” in group chat
Hi,
I have created multiple power automate flows with various purposes that are active in this group chat on TEAMS, but I would like to know if there is a way to add my custom flows here in this “apps” window to run them from there, or edit the default list.
I would also like to know if there is a way to anchor the workflows icon here, something like this:
Hi,I have created multiple power automate flows with various purposes that are active in this group chat on TEAMS, but I would like to know if there is a way to add my custom flows here in this “apps” window to run them from there, or edit the default list. I would also like to know if there is a way to anchor the workflows icon here, something like this: Read More
Per-User MFA State Added to Tenant Passwords and MFA Report
A Microsoft Graph update makes per-user MFA state available for user accounts. Being able to access the data means that we can include it in the User Passwords and Authentication report. You can now see if accounts are disabled, enabled, or enforced for per-user MFA along with all the other information captured about passwqrd changes, MFA authentication methods, and so on.
https://office365itpros.com/2024/06/14/per-user-mfa-state/
A Microsoft Graph update makes per-user MFA state available for user accounts. Being able to access the data means that we can include it in the User Passwords and Authentication report. You can now see if accounts are disabled, enabled, or enforced for per-user MFA along with all the other information captured about passwqrd changes, MFA authentication methods, and so on.
https://office365itpros.com/2024/06/14/per-user-mfa-state/ Read More
Free Trials & Private Offers
Hello!
I am unsure if this is the right place to ask this, so feel free to direct me elsewhere if not!
We offer Customers the ability to trial our solution directly with us for free for 14 days before purchasing, when starting our Marketplace journey we wanted to keep our listing aligned with what we offer directly to Customers on our Website. When initially listing on the Marketplace, we created a ‘free trial’ through the ‘Get It Now’ button, but what we quickly came to realise is that the free trial is also extended for Private Offers too if you have it activated on your listing.
This has caused issues because we do have Customers who are ready to buy now, buying through Private Offer and were being given the months free trial as well, essentially giving them the option to cancel in that months window, however if we were to have transacted directly with the Customer they would have been a paying Customer as soon as they had signed with us.
We have now turned off our free trial on our Marketplace listing because of this, but I have noticed a decline in activity on our listing as a result of this.
I just wanted to reach out and see if there were any other ISV’s facing a similar problem and if anyone knew if there was a way to get around it and essentially turn off the free trial for Private Offers? If there isn’t today, is anyone aware of any developments in the near future to rectify this?
Hello! I am unsure if this is the right place to ask this, so feel free to direct me elsewhere if not! We offer Customers the ability to trial our solution directly with us for free for 14 days before purchasing, when starting our Marketplace journey we wanted to keep our listing aligned with what we offer directly to Customers on our Website. When initially listing on the Marketplace, we created a ‘free trial’ through the ‘Get It Now’ button, but what we quickly came to realise is that the free trial is also extended for Private Offers too if you have it activated on your listing. This has caused issues because we do have Customers who are ready to buy now, buying through Private Offer and were being given the months free trial as well, essentially giving them the option to cancel in that months window, however if we were to have transacted directly with the Customer they would have been a paying Customer as soon as they had signed with us. We have now turned off our free trial on our Marketplace listing because of this, but I have noticed a decline in activity on our listing as a result of this. I just wanted to reach out and see if there were any other ISV’s facing a similar problem and if anyone knew if there was a way to get around it and essentially turn off the free trial for Private Offers? If there isn’t today, is anyone aware of any developments in the near future to rectify this? Read More
Meet Microsoft at FinOpsX 2024 in San Diego
For the second time, Microsoft will be a platinum sponsor of the FinOps X conference, taking place in
San Diego, CA, from June 19 – 22. This year, you can visit our dedicated Microsoft Event Hub website to learn more about our activities, connect with our experts, and register for our exclusive sessions.
This includes:
Our exclusive evening event, where you can network with industry leaders over amazing food, and celebrate the kickoff of FinOpsX. Spaces are limited.
Customer insight sessions with in-depth discussions and feedback. Register for one of the 45min time slots.
Microsoft speakers in the following sessions:
Unveiling Chevron’s transformation
Navigating new intersections and trends
Bring your data into the AI era – democratize FinOps with Microsoft
Profiles of Microsoft experts who will be attending, so you can connect with them on LinkedIn.
Learn more and register now for Microsoft sessions: https://finops.event-rsvp.net/
For event details and attendee registration, visit https://x.finops.org/us/
Microsoft Tech Community – Latest Blogs –Read More
SQL Profiler: can I see values of a proc when it is called from another proc?
I have SQL Server 2012 Enterprise. I have run SQL Profiler to track calls of my stored procedures. I have specified SP:Starting event for this.
There was a situation when my client application calls a procedure Proc1; and Proc1 calls procedure Proc2. Profiler displays the both calls – OK. But I see that Profiler displays actual values of procedure parameters (“@param1 = xxx, @param2= yyy” etc) only for Proc1. For Proc2 it does not show the actual values; it just enlists the parameters (“@param1, @param2” etc).
Is there a way to make SQL Profiler display the actual values for Proc2? Or maybe some other (free) profiler can do this?
I have SQL Server 2012 Enterprise. I have run SQL Profiler to track calls of my stored procedures. I have specified SP:Starting event for this.There was a situation when my client application calls a procedure Proc1; and Proc1 calls procedure Proc2. Profiler displays the both calls – OK. But I see that Profiler displays actual values of procedure parameters (“@param1 = xxx, @param2= yyy” etc) only for Proc1. For Proc2 it does not show the actual values; it just enlists the parameters (“@param1, @param2” etc). Is there a way to make SQL Profiler display the actual values for Proc2? Or maybe some other (free) profiler can do this? Read More
AVD Session host health state ‘Unavailable’
Hi Team,
We have Azure VD and some of the VMs/session hosts have ‘power state,’ as running but ‘Health State’ is ‘Unavailable’. Pls. find the screen shot attached with more details.
Is it possible to fix it by using ‘redeploy’ + reapply’ option? We have no data on the VM as its pooled and not dedicated. Any other solution, pls. suggest.
Regards,
Hi Team, We have Azure VD and some of the VMs/session hosts have ‘power state,’ as running but ‘Health State’ is ‘Unavailable’. Pls. find the screen shot attached with more details. Is it possible to fix it by using ‘redeploy’ + reapply’ option? We have no data on the VM as its pooled and not dedicated. Any other solution, pls. suggest. Regards, Read More
Some sort of a sumif formula
Hello,
I have an issue with a formula i can’t figure out how to make it work,
My goal is to apply a summ in a cell (A1 equals A2 for example) but ONLY if 2 specific cells have any data inside, text, numbers, summs, etc,
for example, A3 equals A2 ONLY if A2 and A1 have text/data/formula inside.
What would the formula be ?
Hello, I have an issue with a formula i can’t figure out how to make it work, My goal is to apply a summ in a cell (A1 equals A2 for example) but ONLY if 2 specific cells have any data inside, text, numbers, summs, etc, for example, A3 equals A2 ONLY if A2 and A1 have text/data/formula inside. What would the formula be ? Read More
Migration sql server from sql 2017 to sql 2022 with Minimal Down time
Below is our suggestion for the migration activity:
Always on High Availability
DB Mirroring
Logshipping
SQL Always on High Availability :
It is possible to configure a SQL Server Always On availability group with a primary replica running on SQL Server 2017 and a secondary replica running on SQL Server 2022, but there are important considerations and limitations to keep in mind:
Backward Compatibility: SQL Server supports having replicas on different versions, but the primary replica must be on an older version than or equal to the secondary replicas. Therefore, having SQL Server 2017 as the primary and SQL Server 2022 as the secondary is valid.
Database Upgrade Path: When you decide to upgrade the primary replica to a newer version, you need to follow a specific upgrade path to ensure minimal downtime and data integrity. Typically, this involves:
Adding the newer version as a secondary replica.
Failing over to the secondary replica running the newer version (making it the new primary).
Upgrading the former primary to the newer version.
Adding it back to the availability group.
Feature Compatibility: Some features available in SQL Server 2022 might not be fully supported or behave differently when the primary replica is running on SQL Server 2017. It’s essential to test the behavior of your applications and workloads thoroughly in this mixed-version environment.
Support and Documentation: Always refer to the official Microsoft documentation for the most accurate and up-to-date information about version compatibility and supported configurations. Microsoft’s official [documentation on Always On availability groups](https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/always-on-availability-groups-sql-server?view=sql-server-ver15) is a good place to start.
Licensing and Maintenance: Ensure that your licensing agreements and maintenance plans support such a configuration. Running different versions might have implications for your support agreements with Microsoft.
Here is a high-level example of setting up such a configuration:
Install SQL Server 2017 on the primary server and configure it as the primary replica.
Install SQL Server 2022 on the secondary server and configure it as the secondary replica.
Create the availability group on SQL Server 2017 and add the database(s) to the group.
Add the SQL Server 2022 instance as a secondary replica to the availability group.
Configure synchronization and verify that the secondary replica is properly synchronized with the primary replica.
Example Steps for Adding SQL Server 2022 as a Secondary Replica
On the Primary Server (SQL Server 2017):
ALTER AVAILABILITY GROUP [YourAGName]
ADD REPLICA ON ‘SQL2022ServerName’
WITH (ENDPOINT_URL = ‘TCP://SQL2022ServerName:5022’, AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT, FAILOVER_MODE = MANUAL);
On the Secondary Server (SQL Server 2022):
ALTER DATABASE [YourDatabaseName] SET HADR AVAILABILITY GROUP = YourAGName;
Join the Secondary Replica to the Availability Group:
ALTER AVAILABILITY GROUP [YourAGName] JOIN;
Start Data Synchronization:
ALTER DATABASE [YourDatabaseName] SET HADR RESUME;
Always test such configurations in a non-production environment to ensure that everything works as expected and to understand any potential issues or performance implications.
DB Mirroring :
Using database mirroring to migrate a SQL Server database from SQL Server 2017 to SQL Server 2022 is a viable strategy. Database mirroring provides a way to maintain a synchronized copy of your database on the new server. Here are the detailed steps to perform the migration:
Step-by-Step Migration Process
Prepare the Environment
Install SQL Server 2022: Set up SQL Server 2022 on your new server where you want to migrate your database.
Network Configuration: Ensure that the network between the old (SQL Server 2017) and the new server (SQL Server 2022) is properly configured and both servers can communicate with each other.
Backup the Primary Database
Full Backup:
BACKUP DATABASE YourDatabaseName TO DISK = ‘C:BackupYourDatabaseName_Full.bak’;
Transaction Log Backup:
BACKUP LOG YourDatabaseName TO DISK = ‘C:BackupYourDatabaseName_Log.trn’;
Restore the Backup on the New Server
Copy the backup files to the new server.
Restore the Full Backup:
RESTORE DATABASE YourDatabaseName FROM DISK = ‘C:BackupYourDatabaseName_Full.bak’
WITH NORECOVERY;
Restore the Transaction Log Backup:
RESTORE LOG YourDatabaseName FROM DISK = ‘C:BackupYourDatabaseName_Log.trn’
WITH NORECOVERY;
Configure Database Mirroring
On the Principal (SQL Server 2017):
ALTER DATABASE YourDatabaseName
SET PARTNER = ‘TCP://SQL2022ServerName:5022’;
On the Mirror (SQL Server 2022):
ALTER DATABASE YourDatabaseName
SET PARTNER = ‘TCP://SQL2017ServerName:5022’;
Security Configuration: Ensure that the database mirroring endpoints are configured correctly and that the service accounts have the necessary permissions.
Monitor the Synchronization
Verify that the mirroring session is established and that the databases are synchronizing. You can use the following query to check the status:
SELECT
db_name(database_id) AS DatabaseName,
mirroring_state_desc,
mirroring_role_desc,
mirroring_partner_name,
mirroring_partner_instance
FROM
sys.database_mirroring;
Failover to the New Server (SQL Server 2022)
Once the database is fully synchronized, you can perform a manual failover to make the SQL Server 2022 instance the principal server.
ALTER DATABASE YourDatabaseName SET PARTNER FAILOVER;
Update Applications and Services
Point your applications and services to the new SQL Server 2022 instance.
Update connection strings to reflect the new server name or IP address.
Remove Mirroring (Optional)
If you no longer need mirroring after the migration, you can remove the mirroring configuration.
— On the Principal (now SQL Server 2022)
ALTER DATABASE YourDatabaseName SET PARTNER OFF;
— On the Mirror (SQL Server 2017)
ALTER DATABASE YourDatabaseName SET PARTNER OFF;
Considerations and Best Practices
Compatibility: Ensure that your database and applications are compatible with SQL Server 2022. Test in a non-production environment before migrating.
Downtime: Plan for a maintenance window, as there might be a brief downtime during the failover.
Backup and Restore: Always have a recent backup before starting the migration.
Using database mirroring can provide a smooth transition with minimal downtime, ensuring that your data remains consistent throughout the migration process.
Log Shippig :
Using log shipping to upgrade from SQL Server 2017 to SQL Server 2022 involves setting up log shipping between the two servers, synchronizing them, and then performing a cutover. Here are the steps to perform the migration using log shipping:
Step-by-Step Migration Process
Prepare the Environment
Install SQL Server 2022: Set up SQL Server 2022 on your new server.
Network Configuration: Ensure that the network between the old (SQL Server 2017) and the new server (SQL Server 2022) is properly configured and both servers can communicate with each other.
Configure Log Shipping
Full Backup of the Primary Database (SQL Server 2017):
BACKUP DATABASE YourDatabaseName TO DISK = ‘C:BackupYourDatabaseName_Full.bak’;
Copy the Full Backup to the new server (SQL Server 2022).
Restore the Full Backup on the New Server (SQL Server 2022):
RESTORE DATABASE YourDatabaseName FROM DISK = ‘C:BackupYourDatabaseName_Full.bak’
WITH NORECOVERY;
Enable Log Shipping on the Primary Database (SQL Server 2017):
Right-click the database in SQL Server Management Studio (SSMS), go to “Properties,” and select “Transaction Log Shipping.”
Check “Enable this as a primary database in a log shipping configuration.”
Configure the backup settings (backup path, schedule).
Configure the Secondary Server (SQL Server 2022):
Specify the new server as the secondary.
Set the path to the backup folder where transaction log backups will be copied.
Configure the restore settings to restore the logs with the `STANDBY` option (so the database can be read-only for verification purposes) or `NORECOVERY` (if you want to keep it in a restoring state).
Start Log Shipping
Initial Transaction Log Backup:
BACKUP LOG YourDatabaseName TO DISK = ‘C:BackupYourDatabaseName_Log1.trn’;
Copy and Restore the Log Backup on SQL Server 2022:
RESTORE LOG YourDatabaseName FROM DISK = ‘C:BackupYourDatabaseName_Log1.trn’
WITH NORECOVERY;
Schedule Regular Log Backups: Configure SQL Server Agent jobs to take regular transaction log backups on the primary and copy them to the secondary server.
Monitor Log Shipping
– Monitor the log shipping status using the Log Shipping Monitor or SQL Server Management Studio to ensure that the transaction logs are being backed up, copied, and restored correctly.
Perform the Cutover to SQL Server 2022
Stop All Transactions on the Primary Database (SQL Server 2017): Ensure no new transactions are occurring on the primary database.
ALTER DATABASE YourDatabaseName SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
Take a Final Log Backup on the Primary (SQL Server 2017):
BACKUP LOG YourDatabaseName TO DISK = ‘C:BackupYourDatabaseName_LogFinal.trn’;
Copy and Restore the Final Log Backup on the Secondary (SQL Server 2022):
RESTORE LOG YourDatabaseName FROM DISK = ‘C:BackupYourDatabaseName_LogFinal.trn’
WITH RECOVERY;
Bring the New Database Online:
ALTER DATABASE YourDatabaseName SET MULTI_USER;
Update Applications and Services
Point your applications and services to the new SQL Server 2022 instance.
Update connection strings to reflect the new server name or IP address.
Considerations and Best Practices
Testing: Thoroughly test the log shipping configuration and the final cutover process in a non-production environment before doing it in production.
Downtime: Plan for a maintenance window during the cutover process as there will be some downtime.
Backup and Restore: Always have recent backups before starting the migration.
Log Shipping Monitor: Use the Log Shipping Monitor to ensure that all log shipping processes are running smoothly.
Log shipping for the upgrade provides a way to minimize downtime and ensure data consistency throughout the migration process.
Microsoft Tech Community – Latest Blogs –Read More
Fluent UI Theme Designer – SharePoint theme assistance
Good day
I created a new theme for my site collection using Fluent UI Theme Designer and it looks ok. However, the icons on the landing page look odd with black as a title colour. How can I change this to colour white? Please help.
Good day I created a new theme for my site collection using Fluent UI Theme Designer and it looks ok. However, the icons on the landing page look odd with black as a title colour. How can I change this to colour white? Please help. Read More
VLOOKUP References to tables with new columns
Hello,
I have a question about shifting vlookup references when adding new columns to the referenced table.
Ex: I have a master data table with all my data
I have a few different tabs with vlookups to said data. If I add columns to the master table, my vlookup references shift the range properly (adds 1 more column) but not the column number.
Original formula:
After the new column add:
As you can see, it adds a new column to my range (AF to AG) but not the corresponding extra column (stays at 31).
How should I write it so it shifts and I can add/delete columns if ever needed?
Changing formulas manually is the absolute last resort as I have about 600 formulas that I would need to manually edit.
Thanks in advance!
Hello, I have a question about shifting vlookup references when adding new columns to the referenced table.Ex: I have a master data table with all my dataI have a few different tabs with vlookups to said data. If I add columns to the master table, my vlookup references shift the range properly (adds 1 more column) but not the column number. Original formula:After the new column add: As you can see, it adds a new column to my range (AF to AG) but not the corresponding extra column (stays at 31). How should I write it so it shifts and I can add/delete columns if ever needed? Changing formulas manually is the absolute last resort as I have about 600 formulas that I would need to manually edit. Thanks in advance! Read More
Access database query
I am trying to build a database for my law firm to log documents we are storing for clients. I have created the form that will form the record card for each client and I have a table that shows the basic client details (e.g. name, address, etc).
What I’d like to do, is to be able to hyperlink the Client ID number (primary key), so that when you click it on the table, the associated record card form pops up, so you can see/complete the details of the documents stored. I’m quite new to Access and there are lots of templates in Access that do this, but even with the use of Copilot, I just cannot seem to figure out how to do this.
Any guidance would be very much appreciated
I am trying to build a database for my law firm to log documents we are storing for clients. I have created the form that will form the record card for each client and I have a table that shows the basic client details (e.g. name, address, etc). What I’d like to do, is to be able to hyperlink the Client ID number (primary key), so that when you click it on the table, the associated record card form pops up, so you can see/complete the details of the documents stored. I’m quite new to Access and there are lots of templates in Access that do this, but even with the use of Copilot, I just cannot seem to figure out how to do this. Any guidance would be very much appreciated Read More
Highlighting any cell with ‘X'(text) based on a cells value in corresponding row
Hey guys,
I made a little manual schedule-planning sheet – but for it not to be too confusing I would like to make any cell (task) marked with X (or any text) to be coloured according to the “Responsible’s” initials.
I just can’t figure this out – either with Conditional Formatting or VBA. Hope some of you can help!
Here is an example of what I mean, both in a sheet and a screenshot (I work in excel, not browser, it is just to share it):
https://docs.google.com/spreadsheets/d/1FADLbH4ZDIQZyLSMkv3j8m6UT-9ba0kaZpnpPndteys/edit?usp=sharin
So any cell marked with text under the date / schedule needs to marked the same color as the responsible for that task – e.g. any cells marked with text in a row where “NISOG” is responsible needs to be highlighted as light pink in this case.
I can’t figure out how to make it automatically so that any cells with text/values in the corresponding row as the “Responsible”‘s initials will get highlighted in a specific colour.
I can only figure out how to highlight a full row based on the initials under “Responsibility”, but this won’t suffice.
Hope some more skilled people out there can help! 🙂
Regards,
Nicky
Hey guys,I made a little manual schedule-planning sheet – but for it not to be too confusing I would like to make any cell (task) marked with X (or any text) to be coloured according to the “Responsible’s” initials. I just can’t figure this out – either with Conditional Formatting or VBA. Hope some of you can help! Here is an example of what I mean, both in a sheet and a screenshot (I work in excel, not browser, it is just to share it):https://docs.google.com/spreadsheets/d/1FADLbH4ZDIQZyLSMkv3j8m6UT-9ba0kaZpnpPndteys/edit?usp=sharin So any cell marked with text under the date / schedule needs to marked the same color as the responsible for that task – e.g. any cells marked with text in a row where “NISOG” is responsible needs to be highlighted as light pink in this case. I can’t figure out how to make it automatically so that any cells with text/values in the corresponding row as the “Responsible”‘s initials will get highlighted in a specific colour.I can only figure out how to highlight a full row based on the initials under “Responsibility”, but this won’t suffice. Hope some more skilled people out there can help! :)Regards,Nicky Read More
I want to Develop Unit Conversion Website like UZZA
I wnat to develop Unit Conversion website like Uzza Soft , How can devlop this with bulk creation in .net ?
I wnat to develop Unit Conversion website like Uzza Soft , How can devlop this with bulk creation in .net ? Read More