SIA FOR TECH

Saving Images to a Folder in Ms Access

noreply@blogger.com (SIA 4 TECH) — Thu, 30 May 2024 08:22:00 +0000

Hello everyone! In this video, I'll show you how to save images into a specific folder instead of saving them inside the database itself. This method will make your database much faster and lighter in weight. In the second part, I'll demonstrate how to display images from a specific folder. Finally, in the third part, I will show you how to zoom in on a picture inside a form using a very simple VBA code.

Part 1: Saving Images to a Folder

Modify the database to store the file name of the image.
Create a folder to save the images.
Program a button using VBA to browse and save images.

Part 2: Displaying Images from a Folder

Add an image control to your form.
Set the control source to display the saved images.

Part 3: Zooming Images in a Form

Create a new form to display the zoomed image.
Set up an on-click event to open the zoomed image form.

This step-by-step guide will help you enhance your database application by efficiently managing images. Don't forget to like, comment, and subscribe for more tutorials!

schedule an email to be sent at a later time

noreply@blogger.com (SIA 4 TECH) — Tue, 26 Mar 2024 13:20:00 +0000

In this detailed video guide, we delve into the art of email scheduling using Outlook. Whether you're a busy professional, a student managing multiple projects, or simply looking to optimize your email workflow, mastering scheduling can significantly enhance your productivity. Join us as we walk you through the steps of scheduling emails to be sent at specific times, ensuring that your messages reach recipients at the most opportune moments. From setting up schedules for important reminders to coordinating emails across different time zones, this tutorial covers everything you need to know. Learn how to seamlessly integrate email scheduling into your daily routine, allowing you to prioritize tasks effectively and streamline communication. With Outlook's intuitive features and our expert guidance, you'll gain the confidence to take control of your inbox like never before. Whether you're a novice or seasoned Outlook user, this video promises valuable insights and practical tips to optimize your email management skills. Don't miss out on this opportunity to elevate your productivity and become a master of email scheduling with Outlook. Watch now and transform the way you approach email communication! to watch other videos of this course check this link below: https://youtube.com/playlist?list=PLX21EEATqSVJacpp9mrJLLyQSebaZafZw

how to Highlight unmatched cells in excel

noreply@blogger.com (SIA 4 TECH) — Thu, 15 Feb 2024 06:22:00 +0000

If you've ever faced the challenge of comparing large datasets across multiple sheets, this tutorial is for you. We'll guide you through step-by-step instructions to quickly identify and highlight cells that have been modified between two sheets.

Our approach utilizes the versatile features of Excel, specifically conditional formatting and formulas, to streamline the comparison process. By following along with our tutorial, you'll learn how to:

Select the data range for comparison
Set up conditional formatting rules to highlight unmatched cells
Write VLOOKUP formulas to dynamically compare values
Handle changes in table structure without disrupting the comparison

Whether you're a beginner or an experienced Excel user, this tutorial offers valuable insights to enhance your data analysis skills. Join us as we dive into the world of Excel data comparison and unlock new possibilities for efficient data management.

Create 3D Morph transition in Power Point

noreply@blogger.com (SIA 4 TECH) — Tue, 05 Dec 2023 02:30:00 +0000

PowerPoint 3d Transition Morph transition

How to Unprotect or Unlock Excel and Word Files

noreply@blogger.com (SIA 4 TECH) — Sun, 26 Nov 2023 05:59:00 +0000

# Video Instruction Guide: How to Unprotect or Unlock Excel and Word Files

**Introduction:**

Hello everyone! In this video, I'll guide you through the process of unlocking or unprotecting Excel and Word files. If you've encountered files that are protected and require a password for editing, don't worry – I'll show you a simple and effective method to bypass these restrictions using your Gmail account.

**Step 1: Excel File Unlocking**

1.1. Start by opening the Excel file you want to unlock. Notice that it's currently protected, preventing any edits.

1.2. Navigate to the "Review" tab and attempt to unprotect the sheet. You'll find it prompts you for a password.

1.3. Now, let's head over to your Gmail account. Log in, and click on the Google Apps icon.

1.4. Scroll down and click on the "Docs" icon. This will open the Docs section for your Gmail account.

1.5. Click on the "Open file picker" icon.

1.6. Choose the "Upload" tab and click "Browse" to find your Excel file. Upload the file to your Gmail account.

1.7. Once uploaded, the file will open automatically. Simply go to the "File" menu and select "Download." Save it to your computer.

1.8. Open the downloaded file, and voila! You'll find that the file is now completely unlocked, allowing you to make any necessary changes.

1.9. Check the "Review" tab – you'll see that all restrictions have been removed.

**Step 2: Word Document Unlocking**

2.1. Now, let's tackle a protected Word document.

2.2. Open the Word file, which currently restricts editing.

2.3. Similar to the Excel process, go to the "Review" tab and attempt to stop protection. It will ask for a password.

2.4. Head back to your Gmail account, click on the Google Apps icon, and scroll down to the "Docs" icon.

2.5. Follow the same steps as in the Excel process: open file picker, upload the file, and download it after it opens automatically.

2.6. Once downloaded, open the Word file, and you'll find that the file is now completely unlocked. All icons are active, and you can make any desired changes.

2.7. Check the "Review" tab – the restrictions have been successfully removed.

**Conclusion:**

I hope this video guide was helpful for everybody! If you encounter password-protected files, remember that with a Gmail account, you can easily unlock and edit them hassle-free. Stay tuned for more useful tips in my next video. See you there!

VBA Code to Split table in Excel sheet to multiple tables and add total to each table.

noreply@blogger.com (SIA 4 TECH) — Thu, 17 Aug 2023 11:53:00 +0000




In this Excel tutorial, we'll dive into the world of VBA coding to 
automate the process of splitting a large table into multiple tables. 
If you've ever wondered how to efficiently manage and organize your data in Excel, 
this tutorial is for you!



Sub SplitTable()
    Dim wss As Worksheet
    Dim wst As Worksheet
    Dim tbs As ListObject
    Dim newTable As ListObject
    Dim ids As Collection
    Dim cel As Range
    Dim rt As Long
    Dim id As Variant
    Application.ScreenUpdating = False
    Set wss = ActiveSheet
    Set tbs = wss.Range("A1").ListObject
    Set ids = New Collection
    On Error Resume Next
    For Each cel In tbs.ListColumns("Employee ID").DataBodyRange
        ids.Add Key:=CStr(cel.Value), Item:=cel.Value
    Next cel
    On Error GoTo 0
    Set wst = Worksheets.Add(After:=wss)
    wst.Range("Z1").Value = "Employee ID"
    rt = 1
    For Each id In ids
        tbs.HeaderRowRange.Copy Destination:=wst.Range("A" & rt)
        wst.Range("Z2").Value = id
        tbs.Range.AdvancedFilter _
            Action:=xlFilterCopy, _
            CriteriaRange:=wst.Range("Z1:Z2"), _
            CopyToRange:=wst.Range("A" & rt + 1)
        wst.Range("A" & rt).CurrentRegion.Rows(1).Delete Shift:=xlShiftUp
        ' Add the table and get a reference to it
        Set newTable = wst.ListObjects.Add(Source:=wst.Range("A" & rt).CurrentRegion)
        ' Enable total row for the new table
        newTable.ShowTotals = True
        rt = rt + wst.Range("A" & rt).CurrentRegion.Rows.Count + 1
    Next id
    wst.Range("Z1:Z2").Clear
    wst.UsedRange.EntireColumn.AutoFit
    Application.ScreenUpdating = True
End Sub

Create a flow to Filter items in MS list and send by email In power automate

noreply@blogger.com (SIA 4 TECH) — Thu, 10 Aug 2023 06:26:00 +0000

in this video you will learn how to create a flow to automate sending data from ms list by email after filtering them.

Create a Flow in Microsoft Power automate to Import Data from Excel Sheet to MS List

noreply@blogger.com (SIA 4 TECH) — Thu, 10 Aug 2023 06:25:00 +0000

If you like to learn how to automate importing data from excel sheet to Ms List,

check out this video:

LazeSoft windows password recovery

noreply@blogger.com (SIA 4 TECH) — Sun, 16 Jul 2023 12:54:00 +0000

LazeSoft Windows Password Recovery Download link

https://www.mediafire.com/file/mb3g9553d29qc9j/lazeSoft.exe/file

گۆرينى ژمارە بۆ نوسين لە بەرنامەى ئێكسل

noreply@blogger.com (SIA 4 TECH) — Sun, 12 Mar 2023 13:21:00 +0000

بۆ گۆرينى ژمارە بۆ نوسينى كوردى ئەم هەنگاوانە بنێ

١- ئەم مۆيويلە داونلۆد بكە لەم لينكەوە ( ئێرە كليك بكە )

٢- داوى داگرتنى فايلكە بە رنامەى ئێكسل بكەوە و تابى (Developer) چالاك بكە

٣- كليكى تابى (Developer) بكە و پاشان كليك لەسەر (View Code) بكە

٤- لەسەر ناوى شيتەكە كليكى لاى راست بكە و پاشان (Import File..) بكە

٥- ئەو فايلە داونلۆدت كردوە ديارى بكە و پاشان كليكى (Open ) بكە

٦- ويندۆى فيشوەل بەيسك دابخەو بگەرێوە ناو بەرنامەى ئێكسل

٧- ئێستا كاتى ئەوەيە كە ژمارە بكەيت بە نوسين لە رێي فەنكشنى (GoriniJimare) و بەم جۆرە بينوسە

GoriniJimare(C2,"","")

Install Windows Drivers all in once.

noreply@blogger.com (SIA 4 TECH) — Sun, 05 Feb 2023 07:49:00 +0000

Share Link of created PDF file by email instead of share it as attachment

noreply@blogger.com (SIA 4 TECH) — Sun, 05 Feb 2023 07:48:00 +0000

Learn Power automate - Part01 - Convert word, Excel Files to PDF without third party connectors or premium subscriptions

noreply@blogger.com (SIA 4 TECH) — Sun, 29 Jan 2023 05:51:00 +0000

Solving Rubick's Cube in 1 mint they lied to you

noreply@blogger.com (SIA 4 TECH) — Sun, 29 Jan 2023 05:49:00 +0000

You may have seen many videos on solving Rubick's Cube on youtube and you followed the steps as they showed you in the video but with no luck,

check this video why it didn't work for you:

هەموو بەرنامەكانى ئەدۆبى بە كراك كراوى

noreply@blogger.com (SIA 4 TECH) — Tue, 30 Aug 2022 06:01:00 +0000

هەموو بەرنامەكانى ئەدۆبى بە كراك كراوى

بەرنامەكان پێويستيان بە سێتەئەپ نيە تەنها داونلۆدى بكە بۆ ناو كۆمپويوتەرەكەت و ئيشى پێ بكە :
پێويستت بە بەرنامەى وين ڕار ئەبێت بۆ كردنەوەى فيلەكان دواى داون لۆد كردن
داوى تەواو بوونى داونلۆد بەشى يەكەم بكەرەوە و ئێكستراكتى بكە بۆ شوێنێكى ناو كۆمپيوتەرەكەت

Adobe Photoshop 2020 Portable (v21.1.2)

Download Links:

Part01
Part02
Part03

--------------------------------------------------------
Adobe Lightroom Classic 2020 Portable (v9.2)

Download Links:

Part01
Part02

---------------------------------------------------------------

Adobe Illustrator 2020 Portable (v24.1)

Download Links:

Part01

Part02

Part03

-----------------------------------------------------
Adobe InDesign CC 2020 Portable v15.0.1

Download Links:

Part01

Part02

-----------------------------------------------------------------------
Adobe After Effects CC 2020 Portable

Download Links:

Part01

Part02

Part03

-------------------------------------------------------------------------------------
Adobe Premiere Pro CC 2019 Portable v13.1.5.47

Download Links:

Part01

Part02

Part03

-------------------------------------------------------------

Adobe Animate 2020 Portable

Download Links:

Part01

Part02

Part03

--------------------------------------------------------------

Adobe Character Animator 2020 Portable

Download Links:

Part01

Part02

-----------------------------------------------------------------------------------

Adobe Acrobat Pro DC 2020 Portable (v20.006.20034)

Download Links:

Part01

Part02
Part03

YouTube Channel QR code

noreply@blogger.com (SIA 4 TECH) — Wed, 17 Aug 2022 11:34:00 +0000

How to remove poshukach search engine from google chrome home page

noreply@blogger.com (SIA 4 TECH) — Wed, 30 Mar 2022 10:51:00 +0000

when you are stuck with poshukach. search engine home page here is the solution on how to remove it completely.

SQL LITE FULL TUTORIAL COURSE

noreply@blogger.com (SIA 4 TECH) — Mon, 28 Mar 2022 13:53:00 +0000

IN 40 simplified videos you will master SQL Lite.

setup Gmail account on outlook

noreply@blogger.com (SIA 4 TECH) — Thu, 09 Dec 2021 11:37:00 +0000

how to make Gmail works offline without internet

noreply@blogger.com (SIA 4 TECH) — Thu, 09 Dec 2021 11:36:00 +0000

Setup out of office in gmail

noreply@blogger.com (SIA 4 TECH) — Thu, 09 Dec 2021 11:36:00 +0000

Solved: Adobe Acrobat DC black screen, not responding

noreply@blogger.com (SIA 4 TECH) — Thu, 09 Dec 2021 11:35:00 +0000

Remove password from excel sheet

noreply@blogger.com (SIA 4 TECH) — Thu, 09 Dec 2021 11:34:00 +0000

How to Show WiFi Password with your phone without rooting or installing any app!

noreply@blogger.com (SIA 4 TECH) — Sun, 14 Nov 2021 16:32:00 +0000

Solved: Crashing Adobe Acrobat Reader when saving changes or printing a file!

noreply@blogger.com (SIA 4 TECH) — Fri, 29 Oct 2021 16:33:00 +0000

You may face freezing or not responding to your Adobe Acrobat Reader application after doing some changes on your pdf file like filling a form or trying to add a signature, and when you want to save the changes the Adobe Acrobat Read get frozen or does not respond,

in this video, I have explained three easy ways to work around this issue, maybe one of the ways solve this issue, so watch the video till the end. and let us know which way did work for you.