Turn Router into a wifi or wireless client

 

Wireless router is intended to broadcast wireless signal to clients such as mobile phones, laptops, desktop computers, etc. however, most routers can work the other way around. Yes, it can work as wifi or wireless client to, receiving signals and act like a wireless adapter for your desktop pc, laptops, and other devices that has LAN access port (Ethernet). Of course, adding functionality means tweaking router’s configuration or system. Most of the manufacturer’s firmware disables this function.

STEPS

  1. Flash the router with tomato firmware
  2. Logon to your router’s UI by going to 192.168.1.1 (this vary from router to router, mostly this information is available at the back of your router. You may also have to set your computer’s ip address to 192.168.1.100 to access the UI)
  3. In your WAN and LAN Settings:
WAN / Internet

LAN

(49)
Mostly 255.255.255.0
Router is 0.0.0.0, you can usually use the default value
Automatic From Dhcp will use router as the DNS. Manual DNS will use specified DNS-servers
(minutes)

Set a LAN IP address that is not on the same subnet as your primary (host) router. For example, if your host router’s IP address is 192.168.1.1, then you might assign the client router 192.168.0.1 or 10.0.0.1.

  1. in your router’s UI, navigate to Basic>>Network

Enter wireless/wifi credentials

  • Wireless Mode: Wireless Client
  • Interface: WAN
  • Wireless Network Mode: Automatic
  • SSID: Enter any available wifi/wireless network 
  • Channel: Channel where your wifi/wireless network is                             broadcast at.
  • Security: Enter whatever security type the network is                             using (commonly Wpa/wpa2 Personal)
  • Encryption: Select the correct encryption (Usually                                           TKIP/AES)
  • Shared Key: Password
  • Group Key Renewal: 3600

 

This will make your router capture a wifi/wireless signal from a host and transmit it to your computer via LAN (ethernet).

 

 

 

 

 

MS Access 2016 Query Criteria

>25 and <50

This criterion applies to a Number field, such as Price or UnitsInStock. It includes only those records where the Price or UnitsInStock field contains a value greater than 25 and less than 50.

DateDiff (“yyyy”, [BirthDate], Date()) > 30

This criterion applies to a Date/Time field, such as BirthDate. Only records where the number of years between a person’s birthdate and today’s date is greater than 30 are included in the query result.

Is Null

This criterion can be applied to any type of field to show records where the field value is null.

 

Criteria for Text, Memo, and Hyperlink fields

 

To include records that… Use this criterion Query result
Exactly match a value, such as China “China” Returns records where the CountryRegion field is set to China.
Do not match a value, such as Mexico Not “Mexico” Returns records where the CountryRegion field is set to a country/region other than Mexico.
Begin with the specified string, such as U Like U* Returns records for all countries/regions whose names start with “U”, such as UK, USA, and so on.

NOTE: When used in an expression, the asterisk (*) represents any string of characters — it is also called a wildcard character. For a list of such characters, see the article Access wildcard character reference.

Do not begin with the specified string, such as U Not Like U* Returns records for all countries/regions whose names start with a character other than “U”.
Contain the specified string, such as Korea Like “*Korea*” Returns records for all countries/regions that contain the string “Korea”.
Do not contain the specified string, such as Korea Not Like “*Korea*” Returns records for all countries/regions that do not contain the string “Korea”.
End with the specified string, such as “ina” Like “*ina”

Returns records for all countries/regions whose names end in “ina”, such as China and Argentina.

Do not end with the specified string, such as “ina” Not Like “*ina” Returns records for all countries/regions that do not end in “ina”, such as China and Argentina.

 

Criteria for Number, Currency, and AutoNumber fields

 

To include records that… Use this criterion Query Result
Exactly match a value, such as 100 100 Returns records where the unit price of the product is $100.
Do not match a value, such as 1000 Not 1000 Returns records where the unit price of the product is not $1000.
Contain a value smaller than a value, such as 100 < 100
<= 100
Returns records where the unit price is less than $100 (<100). The second expression (<=100) displays records where the unit price is less than or equal to $100.
Contain a value larger than a value, such as 99.99 >99.99
>=99.99
Returns records where the unit price is greater than $99.99 (>99.99). The second expression displays records where the unit price is greater than or equal to $99.99.
Contain one of the two values, such as 20 or 25 20 or 25 Returns records where the unit price is either $20 or $25.
Contain a value that falls with a range of values >49.99 and <99.99
-or-
Between 50 and 100
Returns records where the unit price is between (but not including) $49.99 and $99.99.
Contain a value that falls outside a range <50 or >100 Returns records where the unit price is not between $50 and $100.
Contain one of many specific values In(20, 25, 30) Returns records where the unit price is either $20, $25, or $30.
Contain a value that ends with the specified digits Like “*4.99” Returns records where the unit price ends with “4.99”, such as $4.99, $14.99, $24.99, and so on.

NOTE: The characters * and %, when used in an expression, represent any number of characters — these are also called wildcard characters. The character % cannot be used in the same expression with the * character, nor can it be used in an expression with the ? wildcard character. You may use the wildcard character % in an expression that also contains the _ wildcard character.

Contain null null (or missing) values Is Null Returns records where no value is entered in the UnitPrice field.
Contain non-null values Is Not Null

Returns records where the value is not missing in the UnitPrice field.

 

Criteria for Date/Time fields

To include records that … Use this criterion Query result
Exactly match a value, such as 2/2/2006 #2/2/2006# Returns records of transactions that took place on Feb 2, 2006. Remember to surround date values with the # character so that Access can distinguish between date values and text strings.
Do not match a value, such as 2/2/2006 Not #2/2/2006# Returns records of transactions that took place on a day other than Feb 2, 2006.
Contain values that fall before a certain date, such as 2/2/2006 < #2/2/2006# Returns records of transactions that took place before Feb 2, 2006.

To view transactions that took place on or before this date, use the <= operator instead of the < operator.

Contain values that fall after a certain date, such as 2/2/2006 > #2/2/2006# Returns records of transactions that took place after Feb 2, 2006.

To view transactions that took place on or after this date, use the >= operator instead of the > operator.

Contain values that fall within a date range >#2/2/2006# and <#2/4/2006# Returns records where the transactions took place between Feb 2, 2006 and Feb 4, 2006.

You can also use the Between operator to filter for a range of values, including the end points. For example, Between #2/2/2006# and #2/4/2006# is the same as >=#2/2/2006# and <=#2/4/2006# .

Contain values that fall outside a range <#2/2/2006# or >#2/4/2006# Returns records where the transactions took place before Feb 2, 2006 or after Feb 4, 2006.
Contain one of two values, such as 2/2/2006 or 2/3/2006 #2/2/2006# or #2/3/2006# Returns records of transactions that took place on either Feb 2, 2006 or Feb 3, 2006.
Contain one of many values In (#2/1/2006#, #3/1/2006#, #4/1/2006#) Returns records where the transactions took place on Feb 1, 2006, March 1, 2006, or April 1, 2006.
Contain a date that falls in a specific month (irrespective of year), such as December DatePart(“m”, [SalesDate]) = 12 Returns records where the transactions took place in December of any year.
Contain a date that falls in a specific quarter (irrespective of year), such as the first quarter DatePart(“q”, [SalesDate]) = 1 Returns records where the transactions took place in the first quarter of any year.
Contain today’s date Date() Returns records of transactions that took place on the current day. If today’s date is 2/2/2006, you see records where the OrderDate field is set to Feb 2, 2006.
Contain yesterday’s date Date()-1 Returns records of transactions that took place the day before the current day. If today’s date is 2/2/2006, you see records for Feb 1, 2006.
Contain tomorrow’s date Date() + 1 Returns records of transactions that took place the day after the current day. If today’s date is 2/2/2006, you see records for Feb 3, 2006.
Contain dates that fall during the current week DatePart(“ww”, [SalesDate]) = DatePart(“ww”, Date()) and Year( [SalesDate]) = Year(Date()) Returns records of transactions that took place during the current week. A week starts on Sunday and ends on Saturday.
Contain dates that fell during the previous week Year([SalesDate])* 53 + DatePart(“ww”, [SalesDate]) = Year(Date())* 53 + DatePart(“ww”, Date()) – 1 Returns records of transactions that took place during the last week. A week starts on Sunday and ends on Saturday.
Contain dates that fall during the following week Year([SalesDate])* 53+DatePart(“ww”, [SalesDate]) = Year(Date())* 53+DatePart(“ww”, Date()) + 1 Returns records of transactions that will take place next week. A week starts on Sunday and ends on Saturday.
Contain a date that fell during the last 7 days Between Date() and Date()-6 Returns records of transactions that took place during the last 7 days. If today’s date is 2/2/2006, you see records for the period Jan 24, 2006 through Feb 2, 2006.
Contain a date that belongs to the current month Year([SalesDate]) = Year(Now()) And Month([SalesDate]) = Month(Now()) Returns records for the current month. If today’s date is 2/2/2006, you see records for Feb 2006.
Contain a date that belongs to the previous month Year([SalesDate])* 12 + DatePart(“m”, [SalesDate]) = Year(Date())* 12 + DatePart(“m”, Date()) – 1 Returns records for the previous month. If today’s date is 2/2/2006, you see records for Jan 2006.
Contain a date that belongs to the next month Year([SalesDate])* 12 + DatePart(“m”, [SalesDate]) = Year(Date())* 12 + DatePart(“m”, Date()) + 1 Returns records for the next month. If today’s date is 2/2/2006, you see records for Mar 2006.
Contain a date that fell during the last 30 or 31 days Between Date( ) And DateAdd(“M”, -1, Date( )) A month’s worth of sales records. If today’s date is 2/2/2006, you see records for the period Jan 2, 2006. to Feb 2, 2006
Contain a date that belongs to the current quarter Year([SalesDate]) = Year(Now()) And DatePart(“q”, Date()) = DatePart(“q”, Now()) Returns records for the current quarter. If today’s date is 2/2/2006, you see records for the first quarter of 2006.
Contain a date that belongs to the previous quarter Year([SalesDate])*4+DatePart(“q”,[SalesDate]) = Year(Date())*4+DatePart(“q”,Date())- 1 Returns records for the previous quarter. If today’s date is 2/2/2006, you see records for the last quarter of 2005.
Contain a date that belongs to the next quarter Year([SalesDate])*4+DatePart(“q”,[SalesDate]) = Year(Date())*4+DatePart(“q”,Date())+1 Returns records for the next quarter. If today’s date is 2/2/2006, you see records for the second quarter of 2006.
Contain a date that falls during the current year Year([SalesDate]) = Year(Date()) Returns records for the current year. If today’s date is 2/2/2006, you see records for the year 2006.
Contain a date that belongs to the previous year Year([SalesDate]) = Year(Date()) – 1 Returns records of transactions that took place during the previous year. If today’s date is 2/2/2006, you see records for the year 2005.
Contain a date that belongs to next year Year([SalesDate]) = Year(Date()) + 1 Returns records of transactions with next year’s date. If today’s date is 2/2/2006, you see records for the year 2007.
Contain a date that falls between Jan 1 and today (year to date records) Year([SalesDate]) = Year(Date()) and Month([SalesDate]) <= Month(Date()) and Day([SalesDate]) <= Day (Date()) Returns records of transactions with dates that fall between Jan 1 of the current year and today. If today’s date is 2/2/2006, you see records for the period Jan 1, 2006 to to 2/2/2006.
Contain a date that occurred in the past < Date() Returns records of transactions that took place before today.
Contain a date that occurrs in the future > Date() Returns records of transactions that will take place after today.
Filter for null (or missing) values Is Null Returns records where the date of transaction is missing.
Filter for non-null values Is Not Null Returns records where the date of transaction is known.

 

For complete details and explanation, you may visit the source here 

 

MS Access 2016 Query Criteria Quick Reference Guide

Simple criteria for all data types:
Criteria Name Write it like… Function
1 Equals “x” Searches for values equal to x
2 Does Not Equal Not in (“x”) Searches for all values except those equal to x
3 Null Is Null Searches for empty fields
4 Not Null Is Not Null Searches for non-empty fields
Simple criteria for text:
Criteria Name Write it like… Function
1 Contains Like “*x*” Searches for all values that contain x
2 Does Not Contain Not like “*x*” Searches for all values except those that contain x
3 Begins With Like “x*” Searches for all values beginning with x
4 Ends With Like “*x” Searches for all values ending with x
5 Comes After >= “x” Searches for all values that come after x in alphabetical order
6 Comes Before <= “x” Searches for all values that come before x in alphabetical order
Simple criteria for numbers:
Criteria Name Write it like… Function
1 Between Between “x” and “y” Searches for values in the range between x and y
2 Less Than < x Searches for all values smaller than x
3 Less Than or Equal To <= x Searches for all values smaller than or equal to x
4 Greater Than > x Searches for all values larger than x
5 Greater Than or Equal To >= x Searches for all values larger than or equal to x
Simple criteria for dates:
Criteria Name Write it like… Function
1 Between Between “#mm/dd/yyyy#” and “#mm/dd/yyyy#” Searches for dates that fall between two dates
2 Before <#mm/dd/yyyy# Searches for dates before a certain date
3 After >#mm/dd/yyyy# Searches for dates after a certain date
4 Today =Date() Searches for all records containing today’s date
5 Days Before Today <=Date()-x Searches for all records containing dates x or more days in the past

Website Hosting in Philippines

Web hosting service during the 90’s was so elusive, today thousands of companies now are offering the same service with the price that never hurt pockets especially those individuals or starting-up businesses

 

SSL for Website is FREE?

Yes, Thanks to Let’s Encrypt –  is a free, automated, and open certificate authority (CA), run for the public’s benefit. It is a service provided by the Internet Security Research Group (ISRG).

As publish in their website, the key principles behind Let’s Encrypt are:

  • Free
  • Automatic
  • Secure
  • Transparent
  • Open
  • Cooperative

Web Browsers are becoming a striker, Let’s Encrypt is the answer for an average website that aims to gain trust from the internet crowd. Web sites that are SSL enabled, at least with basic encryption also wins ranking over google compared to those with no SSL.

To install Let’s Encrypt SSL, your Cpanel must support this. Otherwise, you may have to use Certbot.

Another option is to transfer your website to us (UiS Domain & Hosting) and we will install Let’s Encrypt for free. Contact us here

In case you plan to build a trustworthy web presence for your brand or project, you need an SSL more that Let’s Encrypt s offering

On our site, you can buy both standard and Wildcard Certificates at an affordable price. Each Certificate comes with rock-solid encryption together with a 100 % free re-issue. A 30-day money-back guarantee is also included, so that you could try out our SSL solutions without risk.

Learn more