Saturday, 20 August 2011

ACCESS - blank parameter queries - SOLVED

No comments:
I have had sooo much trouble getting a parameter query to work in the ACCESS query grid.
Something seemingly so simple ....
When running a query I wanted to be prompted for whether the records should show those with a Checkbox field Ticked, eg (T)rue, Unticked (F)alse or Both Ticked and Unticked (All)
To cut directly to the chase, here is the query criteria which I finally got to work.

Note: The checkbox field being queried is called TaxClaim

IIf([Tax Claim? (T)rue, (F)alse or 'Enter' = All] Is Null,[TaxClaim],IIf([Tax Claim? (T)rue, (F)alse or 'Enter' = All] Like "T*",-1,0))
       If                                                     Then      Else

If Nothing is entered in the prompt dialog e.g. if just 'Enter' or 'OK' is pressed Then display everything in the [TaxClaim] field ... both Ticked and Unticked.

If anything is entered in the parameter dialog (preferably T, or True, or F, or False) the Else statement is executed.
Within the Else section is another nested IIf which checks if the entry is Like anything starting with T (Like "T*") if it is Then it sets the TaxClaim query criteria to -1 which equates to ticked checkboxes. If its anything Else which doesn't start with "T" (i.e. F or False) the TaxClaim query criteria is set to 0 which equates to Unticked checkboxes.

Key points:
The first and subsequent references to the one prompt must be identical
[Tax Claim? (T)rue, (F)alse or 'Enter' = All] 
or (a) subsequent prompt(s) appear(s) and the logic breaks

In the first ImmediateIf, the Is Null only seems to work the way shown. 
I originally tried to use it like IsNull([Tax Claim? ....]) ... that doesn't work in the query grid

The only thing which returned All records (both ticked and unticked) was the use of the Field Name (TaxClaim) in its referenced form (square brackets [TaxClaim])

Friday, 19 August 2011

Watts , Lux, Lumens, LEDs, and inacndescent lights

No comments:
For a more detailed explanation, see this web site, but as a rough comparison, think of these points:

Lumen s measure the total number of packets of light produced by a light source

To compare watts to light output and LED bulbs, we talk about ‘lumens per watt’ (lm/w).

Incandescent bulbs generate around 12 lm/w,
(so a 60watt bulb produces approximately 720 lumen)

LEDs and halogen lights are almost equivalent at 40 lm/w.
(so a 60watt halogen down-light produces approximately 2400 lumen)

Fluorescent tubes can produce 60 lm/w
(so a 60watt fluoro tube produces approximately 3600 lumen)

So for only 3 watts of consumed power, a single 3 watt CREE LED can produce 120 lumen (about the same as a 10watt incandescent bulb), while a 27 watt LED lamp (9x 3watt CREE LEDs) can produce 1080 lumen ... as much as a 90watt incandescent globe ... for only 27wats consumed !

Thursday, 18 August 2011

Using the ATO AUSkey with ECI

1 comment:
With my existing ATO OCAIII certificate for my Technology Tamed  BAS submissions through the Electronic Commerce Interface (ECI) software, due to expire in a couple of months, I decided I should bite the bullet and install AUSkey well ahead of this month's BAS submission to see if I could get it all working ok.

It turned out to be a reasonably painless process made up of the following main steps to install it to an XP SP3 computer (as opposed to a USB key) running Firefox as the browser of choice
  1. Register for an AUSkey (as an Administrator) providing necessary details of your identity.
    If you already have an ATO certificate, those details are used as verification
  2. Record a code generated at time of registration 
  3. Receive an email with an AUSkey download link in it
  4. Within 42 days* execute the link for the first time
    * If left for more than 42 days, the registration expires and you have to reapply ... like I did ... DOH!
  5. Your browser will be checked for the presence of the correct version of Java support
  6. If unsupported or no Java is found, you will be directed to install it before continuing.
    In my case I'm using Firefox (3.6.20) and Java Console 6.0.26 with Java Quick Starter 1.0 extensions along with the Java(TM) Platform SE 6 U26 ( and Java  Deployment Toolkit Plugins
  7. If all is in order you get to download a Microsoft Installer (.msi) file ... AUSkey_software.msi
  8. Once the download completes and the Internet Security Suite has approved it, execute the installer.
  9. Once installed, it requests a restart of your browser which appears to activate an ABR_AUSkey Mozilla Plugin (  
  10. Execute the emailed download link a second time
  11. Provide the code that was generated when you registered for your AUSkey, along with the required captcha
  12. Provide a secure password
  13. BINGO! the AUSkey cert was downloaded and installed
    (to C:\Documents and Settings\USERNAME\Application Data\AUSkey)
  14. Now load the ECI client ... it must be version 6 or later
  15. Choose Select Certificate and in my case I could now see two valid certs.
    One due to expire shortly, which if I selected it and chose Details, I was informed it had an Issuer: ATO OCAIII with a Location: CSI STORE
    Another with a an expiry date of two years away (probably from last-use, as AUSkey never expires as long as it is used at-least once very year). Selecting and choosing Details on this shows the Issuer: Australian Business Register CA with it's Location: SBR STORE
  16. To actually use the new (AUSkey) certificate is as simple as selecting the correct one when you attempt to transact with the ATO.
    e.g. From Business -- Activity Statements -- In Tray, choosing Get New Documents will prompt with the Connect to ATO dialog, simply choose the appropriate certificate in the Organisation Name drop-down and supply the secure password you specified earlier.
Some useful additional information is available through links from the ATO FAQ page.

About AUSkey

    * What is AUSkey
    * Are you eligible
    * Who can 'register' for an AUSkey at
    * Does each person in the business need an AUSkey or can we share
    * Types of AUSkey
    * Will your AUSkey expire
    * When should you cancel your AUSkey
    * What can you do if you disagree with a decision we make about your AUSkey

Getting and setting up your AUSkey
For the first time:

1 Register > 2 Install AUSkey software > 3 Install AUSkey > 4 Link AUSkey to government.

    * How to register if you have an ATO digital certificate
    * How to register if you do not have an ATO digital certificate
    * What information to have on hand if we ask you to phone us
    * Registering more than one person at a time
    * Registering for a Device AUSkey
    * How to install a Standard/Administrator AUSkey on your computer
    * How to install a Standard/Administrator AUSkey on your USB stick
    * About installing Device AUSkeys
    * Installing AUSkey to networks
    * Backup your AUSkey
    * How to link your AUSkey to government agencies

After the first time:
1 Install AUSkey software to your desired location (computer or USB stick) > 2 Request additional copy of your AUSkey via the AUSkey website > 3 Install AUSkey > Link AUSkey to government.

    * How to access the AUSkey software after installing your AUSkey
    * How to request an additional copy of your AUSkey

How to

    * Use an AUSkey that is installed on a USB stick
    * Change your password
    * Upgrade to an Administrator AUSkey/Downgrade to a Standard AUSkey
    * Update your name on our system if you have changed it
    * Move your AUSkey to a different location
    * Cancel your AUSkey
    * Delete an AUSkey from your computer or USB stick
    * Change the custodian of a Device AUSkey

Technical information

    * Operating systems and browsers
    * Active X
    * JavaScript
    * Restrictions on download, installation or USB access
    * Anti-virus software


    * Lost activation code
    * Lost ‘download and install’ email
    * Did not receive an email after completing an AUSkey registration
    * Cannot login to government online services using AUSkey
    * Cannot remember your AUSkey password
    * Lost or stolen computer or USB stick
    * AUSkey corrupted
    * Received an operating system not supported message
    * Received an error message or experienced an issue while trying to register
      or download an AUSkey
    * Creating new user accounts
    * Why have I been redirected to the AUSkey software installation page

Sunday, 7 August 2011

Suggest you check this out - Unstoppable Affiliate

No comments:
Have a read though the feedback on warrior forum and then have a look at the product.
It might be worth your time to investigate it.
Andrew Hansen is a name that can be trusted. Elite Niche Research was a great product

I like Todo Backup free home version so much ...

1 comment:
I like the free Todo Backup product so much that I will gladly make a contribution for each copy that I use.
Is there some way I could make a donation for each copy I choose to use on my home pc’s?

The old-fashioned idea of being able to fully trial for an unlimited period, then being able to buy single-version copies outright, without having to “subscribe” or “renew” or “regularly upgrade”, suits my needs perfectly.
Your product, however, is so good that I would gladly pay a token amount per copy to support the continued free-access home-use policy.

I have two small usability improvement suggestions to offer.
On the Backup tab In the Backup Management dialog where it shows all tasks/plans, it would be great to see the last-run and/or next scheduled time for each task/plan.
I would find this more useful than the Created Time field, currently shown.

Another little bit of feedback was when I started using the product, in that same summary dialog it has the Status column.
To me, “Started” means the backup task is actually performing a backup, though I quickly realised it meant the task was loaded and waiting for the next execution.
Maybe a status of “Scheduled” would be more descriptive?
(e.g. Status’ could be .... Started(or Running); Scheduled(or Pending);Paused)

Thanks for a great product.
Keep up the great work and please keep a “free” (or very cheap) version for other small users like myself – with the option to donate

Colin J Sanders  Automation Analyst, Dip Elec., MCSE, ITIL, PRINCE
Technology Tamed ®
A.B.N.  13 442 206 580
Blogs:  TechTamed Discussion digital-video-security
Twitter:  @automation_man
Skype:   automation_man