#ForFlukeSake

[fluk3sake]

MS Word: Edit PDF

MS Word: Edit PDF

Microsoft has brought in the ability to Edit a PDF directly from Word. Select the File Menu then select Open Word tells you that it’s going to make a copy of the PDF and convert its contents into a format that Word can display. The original PDF won’t be changed at all. Select OK. Depending on the size and the speed of your workstation this process can take some time. Be Patient. After your…

[fluk3sake]

MS Word: Create a Document

MS Word: Create a Document

When opening MS Word it opens in the Back Stage View, This view has three primary menus at the top Right. Home – Uses a combination of the most useful commands from the other Menus New – Different options to create a New Document Open – Selection of available locations from where documents can be opened. Blank Document A Blank document is an empty sheet that you can start from Scratch. On…

[fluk3sake]

MS Word: Toolbars and Ribbon

MS Word: Toolbars and Ribbon

The ribbon is a set of toolbars at the top of the window in Office programs designed to bring the most popular commands to the front to help you quickly complete a task.The Ribbon consists of three Basic parts: Tabs, Groups, and Commands Tabs The tabs open a ribbon with specific activities that can be used. The Home tab activities are the most commonly used among the other Tabs on the Menu…

[fluk3sake]

Operation Could Not Be Completed Error 0x00000bc4 No Printers Were Found

Operation Could Not Be Completed Error 0x00000bc4 No Printers Were Found

When trying to connect an end-user workstation to a Shared Printer on a Windows Server you get the error “Operation Could Not Be Completed Error 0x00000bc4 No Printers Were Found“. This issue can be because by many different reasons. To Resolve the issue you can attempt the following: Restart the Printer Spooler on the Workstation and the Server Open Command Prompt in Admin Mode on both the…

[fluk3sake]

Find Character in String from Right in Excel

Find Character in String from Right in Excel

Working with some log files based on a Flat file, we use Excel to get the data in a structured way to be able to use against other datasets. Getting data from these Text-based logs does sometimes need some creativity. This is the case when trying to get an unknown amount of characters after the last instance of a specific character. To understand how to get to this, let’s work through three…

[fluk3sake]

Learn Excel: What is Excel? Excel Layout

Learn Excel: What is Excel? Excel Layout

Whenever I meet a User that complains about knowledge and learning Excel better, I find that most of the time it is because they are shown the difficult side of Excel. With the difficult part, I mean they see functions within functions and get told these functions are easy. This is true if you used each function separately or even if you understand a few concepts of how Excel works. What is…

[fluk3sake]

ADDS - New AD Error: You must supply a user account name.

ADDS – New AD Error: You must supply a user account name.

While creating a Test Environment to check a few issues I am experiencing on a Previous RODC I set up. The following error kept coming up: “You must supply a user account Name”. Upon doing a bit of research I did not find much except for an article advising to create a new account and adding the user to the Domain Admin Groups. Which is fine and it worked but it did not make sense why I could…

[fluk3sake]

Find which program is using a Specific Port in Windows

Find which program is using a Specific Port in Windows

While installing a web server on a workstation, I kept getting an error that the port number was in use. This obviously caused some issues as it is an IT machine, who knows what was installed using the ports? There are two ways to figure out what software is using the ports required. The first is Command Prompt which is a Legacy way of doing it but still works fine.Secondly is with PowerShell…

[fluk3sake]

Outlook Email going to Deleted Items with no Rules

Outlook Email going to Deleted Items with no Rules

When a User comes to me regarding emails disappearing out of their mailbox or when READ the answer is normally the rules setup is moving your Email. But in this case, there was no Rules setup. The user complained the emails would randomly go to the deleted Items. This was not even from the same email Recipient it would be random Recipients. Ignored Emails The answer once we figured it out was…

[fluk3sake]

O365 SMTP Authentication Stopped Working

O365 SMTP Authentication Stopped Working

One of the things I prefer to set up on all Multifunction Printers is Scan-to-email. The config is much easier to do and you can add and remove users quickly as required. The problem is when all Scan-to-email functionality just stops working for no reason at all, troubleshooting can become tricky. This was the situation when Microsoft disabled all SMTP authentication within the…

[fluk3sake]

Finding the IP of a computer causing Event ID 4776

Finding the IP of a computer causing Event ID 4776

Logging onto an AD Server this week, we found a very worrying event in the Security Event Viewer when we saw Event ID 4776 Audit Failure every few seconds. The problem with this event is that if it does not pass on authentication, it gives you no information on where it originates. Let’s start with why this event displays on the Domain Controller displays this message. Local Policies On the…

[fluk3sake]

Excel Bulk Remove Blank Lines

Excel Bulk Remove Blank Lines

Removing Blank lines in Excel can be done in a few different ways. Create a FilterCreate a TableSpecial Select Create a Filter Start by selecting the complete range of data that you want to remove data on. On the “Home” Menu find “Editing“, “Sort & Filter”, and choose “Filter“. Now click any one of the Dropdown buttons on the header, and choose “Sort A to Z” or “Sort Z to A“. Create a…

[fluk3sake]

Adobe Reader prints weird Characters

Adobe Reader prints weird Characters

It sometimes happens that Adobe Reader displays a document fine on the screen but when printing it prints Gibberish. The Obvious fix for this is Uninstall and Reinstall. For the most part, this works and the issue is gone. Unfortunately, this is not always the case or always possible for those times you can try the following two solutions to see if it resolves the issue. Use Local fonts Open…

[fluk3sake]

Adobe Acrobat "Save As" Screen Blank

Adobe Acrobat “Save As” Screen Blank

After a recent reload of one of the User PC. We found an issue on Adobe Reader DC where the “Save As” dialog opens but it displays a Blank Page. After a bit of research, we found this is not a new problem but has been an issue in other versions for a few years. The Fix is fairly simple. Open Adobe Reader at the top Click Edit and then Preferences…On the Preferences dialog choose the Category:…

[fluk3sake]

Excel: Formula Dependency

While working with Excel files created by various people, you will encounter times when you need to find from where the data gets populated. This may not specifically be from the previous cell where another Formula or Value is. But rather each cell where data can change to affect a specific Value. Excel has Auditing features specifically for this purpose. These can be found on the Excel Ribbon…

[fluk3sake]

Run Application as Administrator for Non-Admin User

Run Application as Administrator for Non-Admin User

Sometimes it is necessary to run Applications as an Administrator otherwise the functionality on the Program just does not work. This was the case with one of our Financial systems which once a week I had to be next to the users to keep entering my Admin Credentials. I have tried everything you could search Online to have the application run without my intervention. Full Permission on the…