Use Cross Join In MS Access

Posted on by
Reply

Our Microsection report needs to have same serial number for each and every hole type. Using VBA to generate a table, which has a field of hole_type and a field of SN, sure will work. However; a proper and elegant way is to use a cross join to link two tables.

Tbl_Hole:
H_Type             Text     (PTH; Blind_Via; Micro_Via etc)
H_Name           Text     (Thermal Stress; As is; L1-3; L8-9 etc)

Tbl_SN:
SN                   Text     (1, 2, 3, 4, 5, etc)

SQL (qry_HoleType_SN):
SELECT *
FROM tbl_Hole, tbl_SN;

From a graphical query builder
Add both tables and ensure there is no link between them.

    Below is what I got.

    H_Type H_Name SN
    Blind Via L1-2 1
    Blind Via L1-2 2
    Blind Via L1-2 3
    Blind Via L1-2 4
    Blind Via L1-2 5
    Blind Via L8-9 1
    Blind Via L8-9 2
    Blind Via L8-9 3
    Blind Via L8-9 4
    Blind Via L8-9 5
    PTH As Is 1
    PTH As Is 2
    PTH As Is 3
    PTH As Is 4
    PTH As Is 5
    PTH Thermal Stress X 1
    PTH Thermal Stress X 2
    PTH Thermal Stress X 3
    PTH Thermal Stress X 4
    PTH Thermal Stress X 5
    PTH Thermal Stress Y 1
    PTH Thermal Stress Y 2
    PTH Thermal Stress Y 3
    PTH Thermal Stress Y 4
    PTH Thermal Stress Y 5

    Aspire One LINPUS Desktop Advance mode

    Posted on by
    Reply

    To open a terminal
    alt + F2; or go to File Manager > File > Terminal.
    ———————
    To get the Xfce Settings Manager.
    xfce-setting-show
    Then go to >Desktop > Behavior tab > Show desktop menu on right click
    ———————
    To remove and to add new desktop shortcuts.
    /home/user/.config/xfce4/desktop/group-app.xml
    ————————
    To find out CPU speed (peopel repoted that fan is always on, after BIOS was upgrated to V3114)
    grep ‘cpu MHz’ /proc/cpuinfo
    —————————-
    backup BIOS
    FLASHIT ZD5_3xxx.FD /AC /G
    This will dump the BIOS to the file BIOS3xxx.FD and won’t nag about a missing AC adapter. Please replace the 3xxx with your bios version. You can find it on the Setup information screen when you press F2 on bootup.
    ———–

    Install softwares on Linux using YUM

    Posted on by
    Reply

    *Step # 1: Configure yum
    Code:
    /etc/yum.conf
    [base]
    name=Fedora Core $releasever - $basearch - Base
    baseurl=http://apt.sw.be/fedora/$releasever/en/$basearch/dag
    baseurl=http://mirrors.kernel.org/fedora/core/$releasever/$basearch/os
    Save the file. Install GPG signature key with rpm command:
    Code:
    # rpm --import http://dag.wieers.com/packages/RPM-GPG-KEY.dag.txt
    ——————–
    *Step # 2 Update your package list:
    Code:
    # yum check-update
    ===============
    *Step # 3 start to use yum
    Install a new package called foo
    # yum install foo
    ===============
    To update packages
    # yum update
    To update a single package called bar
    # yum update bar
    To remove a package called telnet
    # yum remove telnet
    To list all packages
    # yum list installed
    ===============
    You can search using grep command
    # yum list installed | grep samba
    Display information on a package called foo
    ===============
    To display list of packages for which updates are available
    # yum list updates
    ===============
    clean all cahced packages:
    # yum clean packages
    To remove all cached packages and old headers:
    # yum clean all
    Force a fresh download of package
    # yum clean headers
    # yum clean oldheaders