MoonPoint Support Logo


Shop Amazon Warehouse Deals - Deep Discounts on Open-box and Used ProductsAmazon Warehouse Deals

Advanced Search
Sun Mon Tue Wed Thu Fri Sat
18 19 20 21 22 23 24
25 26 27 28 29 30  
AprMay Jun
Jul Aug Sep
Oct Nov Dec

Sun, Apr 18, 2021 5:13 pm

DB Browser for SQLite for Microsoft Windows systems

DB Browser for SQLite provides a data base management system (DBMS) for SQLite databases on a variety of operating systems. It is available for Microsoft Windows operating systems—there is even a portable application version that does not have to be installed, but instead can be run from a USB flash drive. The software is also available for macOS—see DB Browser for SQLite on OS X— and Linux systems. SQLIte itself is a relational database management system (RDBMS) available for a variety of operating systems. SQLite is freely available under a public domain license and DB Browser for SQLite is also freely available under a GNU General Public License (GPL). DB Browser for SQLite provides the underlying SQLite software, so you don't need to install SQLite on a system prior to installng DB Browser for SQLite.

[More Info]

[/software/database/sqlite/db_browser] permanent link

Sat, Apr 10, 2021 5:26 pm

Creating a list that is expandable and collapsible in HTML5

If you wish to make a list that can be collapsed and expanded on a webpage or a section on the page that can be expanded to reveal more details, you can use the details and summary tags with version 5 of HTML. E.g., the following code allows information to be displayed or hidden by clicking on an arrowhead that will appear to the left of whatever appears within the summary tags. The information within the details tag will be hidden or displayed by clicking on the arrowhead to toggle between the two options.
The American Civil War began on April 12, 1865 when South Carolina
militia forces attacked Fort Sumter at Charleston, South Carolina. The
conflict lasted until May 9, 1865 when the president of the Confederacy,
Jefferson Davis, declared an end to the insurrection. Each side in the
conflict suffered over 800,000 casualties. The principal cause of the
conflict was the issue of slavery within the United States with abolitionists
in the North viewing the practice as a crime against humanity while Southern
slave owners viewed it as a necessary evil or, for some defenders of slavery,
even as a positive good, which they feared would be eliminated under the
recently elected President Abraham Lincoln.

[More Info]

[/network/web/html] permanent link

Wed, Apr 07, 2021 9:34 pm

Iterating over a PHP associative array by key

The PHP scripting language provides associative arrays that allow one to associate a key in the array to a value; each key in the array must be unique. E.g., I can create an array of United States presidents that uses the presidents' names as the keys and their political party affiliation as the value for each key. I could then iterate through the array by key and show the corresponding value for each key as in the example PHP code.

[/languages/php] permanent link

Wed, Mar 24, 2021 10:02 pm

Changing the default value for "Read It" in Book Collector

After I updated Book Collector, the book management database from that I use to track my book collection, from 21.0 build 3 to 21.1 build 1 today, I noticed that books I entered afterwards were being assigned a value of "Yes" for "Read It" by default—that value appears under the "Personal" fields for a book entry. I was able to change the default value to "No" by clicking on Tools on the main menu, selecting "Field Defaults" and changing the "Times Read" value from "1" to "0"; after I made that change new books I entered were given a "Read It" value of "No" by default.

Book Collector Field Defaults

[/software/database/collectorz] permanent link

Mon, Mar 15, 2021 2:30 pm

Deleting entries from Book Collector CLZ Cloud account

The March 4, 2021 version of Book Collector, version 21.0.3, allows you to remove all entries from the CLZ Cloud account from within the program. I needed to do that because the cloud account contained entries from my wife's book database that would be added to my database if I synched the accounts—I wanted to keep the two book lists separate. The steps for wiping the copy of the database stored in the CLZ cloud from the Windows version of the program are listed below:
  1. Within the Book Collector program, click on Clz Cloud on the menu bar at the top of the program window.
  2. Select Synchronize.
  3. Click on View my collection in CLZ Cloud if you wish to view the books stored in the copy of the database in the CLZ Cloud in a webpage in your default browser before deleting everything in that version, then click on the Clear CLZ Cloud button at the bottom of the program window to remove all book entries from the version of the database stored in the cloud.
  4. You should then see zero cloud changes to be downloaded.

    CLZ Cloud after clearing cloud

    If you wish to then synchronize your local copy of the database to a copy stored in the cloud, you can click on Sync Changes. When you do so you should see "sending items to cloud." Be prepared to wait a few minutes for the synchronization operation to complete if you have a large number of books in your Book Collector database. You will see the number of "Adds/Edits" decrease to zero as books are uploaded. When the process is complete you will see the message "Finished syncing changes. Would you like to view your collection in CLZ Cloud?"

[/software/database/collectorz] permanent link

Fri, Mar 05, 2021 1:38 pm

Obtain Monitor Manufacturer Information Using PowerShell

I wanted to be able to obtain information on a monitor attached to a Windows 10 desktop system, including the manufacturer, model number, serial number, and date of manufacture, from a command-line interface (CLI). One way to do that is by using PowerShell, which Microsoft provides as part of its Windows operating system. You can open a PowerShell window on a Microsoft Windows 10 system by typing PowerShell in the "Type here to search" field at the bottom of the Windows display. You should see the Windows PowerShell app listed as an option you can click on to open a PowerShell window. If you type gwmi WmiMonitorID -Namespace root\wmi at the prompt and hit enter, you will see information similar to the following output displayed.

PS C:\> gwmi WmiMonitorID -Namespace root\wmi

__GENUS                : 2
__CLASS                : WmiMonitorID
__SUPERCLASS           : MSMonitorClass
__DYNASTY              : MSMonitorClass
__RELPATH              : WmiMonitorID.InstanceName="DISPLAY\\HPN360C\\5&2c03a83e&0&UID262_0"
__PROPERTY_COUNT       : 9
__DERIVATION           : {MSMonitorClass}
__SERVER               : YTTERBIUM
__NAMESPACE            : root\wmi
__PATH                 : \\YTTERBIUM\root\wmi:WmiMonitorID.InstanceName="DISPLAY\\HPN360C\\5&2c03a83e&0&UID262_0"
Active                 : True
InstanceName           : DISPLAY\HPN360C\5&2c03a83e&0&UID262_0
ManufacturerName       : {72, 80, 78, 0...}
ProductCodeID          : {51, 54, 48, 67...}
SerialNumberID         : {67, 78, 75, 48...}
UserFriendlyName       : {72, 80, 32, 51...}
UserFriendlyNameLength : 13
WeekOfManufacture      : 12
YearOfManufacture      : 2020
PSComputerName         : YTTERBIUM

PS C:\>

[More Info ]

[/os/windows/PowerShell] permanent link

Mon, Mar 01, 2021 9:44 pm

Changing the AutoRecover frequency for Microsoft Excel 2007

Microsoft Excel 2007 crashed on a laptop running Windows 10 that I was using. When I restarted Excel, I found that, unfortunately, I had lost all of the recent changes I had made to a spreadsheet, even though Excel put "(version 1).xlsb [Autosaved]" in the title of the spreadsheet I had been working on when I restarted Excel—-it crashed when I attempted to paste a webpage URL into a Hyperlink field. The crash and loss of my recent work was aggravating, so I decided to change the frequency with which Excel auomatically saves a file in an AutoRecover version that will allow you to automatically recover a document if if the program hangs or crashes. To change that setting for Excel 2007 on a Windows system, you can click on the Office Button at the top, left-hand corner of the Excel window (it is to the left of the "Home" tab as shown below).

Excel - Office Button

Then click on the Excel Options button and select the Save option. The checkbox for "Save AutoRecover information every" should be checked. You can then change the frequency from 10 minutes to a more frequent number; I chose to have Excel automatically save a document every 5 minutes.

Excel 2007 AutoRecover Frequency

[/software/office/excel] permanent link

Sat, Feb 20, 2021 7:29 pm

Checking the ink level for a Canon TR8520 Printer

To check the level of ink in the ink cartridges for a Canon TR8520 printer on a Windows 10 system, you can take the following steps:
  1. Select Devices.
  2. Select Printers & scanners.
  3. Click on Canon TR8500 series.
  4. Click on Manage.
  5. Click on the View Printer Status button.

You can then see the level of ink in the magenta (M), black (BK), yellow (Y), Black (PGBK), and Cyan (C) cartridges.

If you are near the printer, you can also check the ink levels from the front panel of the printer by touching the Setup icon, which looks like a gear, on the home screen of the front panel. Then tap "Estimated ink levels" on the panel. You will then see the estimated ink levels for each cartridge displayed. If the ink is depleted or near depletion in a cartridge, there will be a red circle with a white "X" in it dispalyed over the cartridge.

[ More Info ]

[/hardware/printer/canon/tr8520] permanent link

Fri, Feb 05, 2021 1:08 pm

Auto Warranty Telemarketer Calling from 410-457-9422

When I checked my cellphone this morning, I found I had missed a call an hour before from 1-410-457-9422. The call was listed as coming from Darlington, Maryland. I hadn't been to Darlington, MD in decades, so suspected it might be from a telemarketer, but called just to check, since I couldn't find information online associating the number with a telemarketer or scammer. When I called the number, an automated system answered that identified the number as being associated with an auto warranty service and gave me the option of hitting "1" to be removed from its calling list, which I chose to do.

[/phone] permanent link

Wed, Dec 16, 2020 9:15 pm

Creating a dropdown list in Microsoft Excel

In the Microsoft Excel spreadsheet program, if you wish to create a dropdown list where a user can select options from the list for a cell's value, you can take the steps below:
  1. Highlight the cells where you wish to have the the dropdown list appear, e.g., by clicking in a cell and dragging downwards through a column where a user should select from the dropdown list.
  2. Click on Data on the menu bar at the top of the Excel window
  3. Click on Data Validation.
  4. If you see 3 options under Data Validation, i.e., Data Validation, Circle Invalid Data, and Clear Validation Circles, select Data Validation.
  5. You will then see a window where you can change settings. In the "Allow" field for validation criteria, select List.
  6. You will then be given an option to provide the items for the list in the source field. If you have just a couple of options for the list that won't change, you can type them separated by a comma.
  7. Click on OK.

In cells where you have chosen to present a dropdown list to a user, when the user clicks on the cell or tabs into it, he/she will see a small box with a downward pointing arrowhead appear to the right of the cell. The user can then either type a value in the field or he/she can chose a value from the dropdown list by clicking on the small box with the downard pointing arrowhead. If the user types a value that isn't in the list rather than selecting from the dropdown list, when the user hits enter or moves the cursor out of the cell, he/she will see the message "The value you entered is not valid. A user has restricted values that can be entered in this cell."

[ More Info ]

[/software/office/excel] permanent link

Once You Know, You Newegg AliExpress by

Shop Amazon Local - Subscribe to Deals in Your Neighborhood

Valid HTML 4.01 Transitional

Privacy Policy   Contact

Blosxom logo