NewsLine 2000: Tips, Tricks and Information

 


Free News by Email
Want your free newsletter emailed directly to you?
Your Email Address :


    In this issue:
  • Are you committing a data crime?
  • Microsoft dumps Java
  • Screen Calipers pixel measuring on screen
  • Words own Hot-Spots!
  • How to get a different last page footer
  • Access: creating "vertical" queries
  • Changing the NT organisation name
  • Mapping drive letters to directories
  • Printing from the command line in Win2K
  • Running linux programs on SCO Open Server
  • Restricting choices in a Uniplex database form
  • ICANN announces new selections for top-level domains
  • Paint Shop Pro Quick Tip
  • Privacy Statements for your Web Site
  • Windows Scripting: Running DOS commands from WSH
  • Formatting Time and Date cells in Excel.
  • Subject: Re: What should I pack?

 

ARE YOU COMMITTING A DATA CRIME?
New European laws affect US companies

 

Laws enacted this year now mean that the transfer of data from European companies to the US requires the express consent of the data subjects and the written agreement from the US receiver that they will comply with European data leglislation.

This is an issue for European companies with US divisions, or US companies taking data from European web sites. Not surprisingly, most US companies have no knowledge of this requirement, but their failure would mean the European operation is liable for any breach.

There are a number of ramifications of this and if this affects you then you really ought to start at the European Data Protectin Authority at www.europa.eu.int.

By the way, this does not affect personal data transfers, so your personal email address list is OK. However, your corporate email address list is not.

See http://www.europa.eu.int for more information  

MICROSOFT DUMPS JAVA
Monopoly? Moi?

 

It's astonishing isn't it? Before moving to the appeal court to claim they are not a monopoly Microsoft announced this week it would not be supporting Java in their new .NET initiative.

Of course, Microsoft are not new to Java controversy after the lost the court battle over the Java licence from Sun and their modifications to render it proprietary to Windows by including specific Windows code and calls.

So, first they want us all to drop C/C++ in favour of C# (exclusive to Microsoft) and now Java, a specifically independent and open language for Internet programming has also been dropped.

Now, don't get me wrong, I believe Microsoft has the right to develop or not develop products as they see fit, but Gordon Smillie, head of strategic business at Microsoft UK said that developers looking at Java face a choice of choosing .NET and having "a career" or learning Java and having "work for the next 12 months".

I find the language used amazing, clearly Microsoft won’t be adopting a softly, softly approach and repent their previous monopolistic behaviours.


In the meantime, if you need someone who can program in C, Basic, SQL, Java or even Cobol and Fortran then why not give us a call…

See http://www.c2000.com/ for more information  

SCREEN CALIPERS PIXEL MEASURING ON SCREEN

 

This nifty little utility lets you measure pixels on screen. That's all it does, but if you are building web sites or laying out program forms and you need exact pixels sizes, then screen calipers is the man!

Runs on Windows 95, 98, NT and 2000 - completely free.

See http://www.c2000.com/software for more information  

WORDS OWN HOT-SPOTS!
DO Touch That Mouse moments!

 

OK, just this once, we'll let you use the mouse...

There are some places on the Word screen called hotspots that you can double click on to take you to certain dialog boxes. Double click...
... on the ruler to display the Page Setup dialog box
... on the page number at the bottom left of the screen to display the GoTo dialog box
... on a tab marker on the ruler to display the Tabs dialog box
... on a paragraph marker to display the Paragraph dialog box
... in the space to the right of a toolbar to display the Customize dialog box
... on your header or footer text to edit it
... on the icons in the status bar (just above the TaskBar) to go to the associated feature
... on the title bar to restore or maximise your window

See http://www.c2000.com/mswindow for more information  

HOW TO GET A DIFFERENT LAST PAGE FOOTER

 

I suppose a common example of this is where you have "Continued/.." at the bottom of every page - but the last. The solution lies in using Words fields. It looks a little hairy, but its not so bad when you are used to it:

1) Move to your footer section

2) Press Control-F9 (this opens field mode and enters a greyed {} pair.

3) Inside the curly brackets type:

{ if { NUMPAGES } > { PAGE } "Continued/.." "-- ENDS --" }

Note: where you see {NUMPAGES} and {PAGE} you must enter the # and #/# marks from the header toolbar which inserts the page numbers for you.

See http://www.c2000.com/mswindow for more information  

ACCESS: CREATING "VERTICAL" QUERIES
Or how to sum data across many rows

 

Access offers straightforward calculations ACROSS a row (for example Cost: [Price] * [Quantity]). But what about creating a total DOWN the row, say the TOTAL of all Prices?

Method 1 is the complex method which is to use a crosstab query - and Access sort of leads you in that direction, but actually it is the hard way.

Method 2 is the easy way, which is to use a SUM button on a select query, which turns it into a TOTALS Query. The SUM button (a capital sigma character) adds a new row in the query which allows you to select whatever function you need. Amongst others you can select:
SUM for the total of the column
MIN or MAX for the smallest or largest value
AVG for the Average value of the column

See http://www.c2000.com/mswindow for more information  

CHANGING THE NT ORGANISATION NAME

 

OK, as if the job worries weren't enough when your company gets bought out, you also have to change the company names on your systems. Well, here's where for NT:

1) Start the Registry editor
2) Find the HKEY_LOCAL_MACHINE\Software\Microsoft\WindowsNT\CurrentVersion and select the CurrentVersion
3) Double click on RegisteredOrganization and change the value data to your new company name
4) Click OK and exit regedit.

See http://www.c2000.com/mswindow for more information  

MAPPING DRIVE LETTERS TO DIRECTORIES

 

You might want to do this because you anticipate data moving in the future to an independent hard disk (or for that matter, just moving). You may also need to do this as you move systems around.

You can use the SUBST command to map a drive letter to any given folder:

subst X: C:\Example\Files

Would letter you see C:\Example\Files by clicking on the X: drive.

See http://www.c2000.com/mswindow for more information  

PRINTING FROM THE COMMAND LINE IN WIN2K

 

In the old days to print from a command line you could only do this to LPT1, but now you can send any file directly to the printer as long as you know the printers share name, for example:

copy file.txt \\computer\HPLaser

The Windows 2000 Resource Kit also supplies CON2PRT which can be used to connect to a printer, e.g.

C:\> con2prt /c \\computer\HPLaser
Connected to printer: \\computer\HPLaser

Which actually adds the printer as a normal printer under Printers control panel applet. Using /cd sets it to the machines default printer.

See http://www.c2000.com/mswindow for more information  

RUNNING LINUX PROGRAMS ON SCO OPEN SERVER
and vice-versa

 


Both SCO OSR5 and Unixware can run Linux binaries using the "lxrun" utility found on the Skunkware CD.

Generally you can also run OSR5 binaries on linux too. You will need the ibcs2 module. There are some places where problems may occur - SCO and Linux directory structures are different, you may not want to mix and match directories. Application calls to system utilities might need new links making or may use slightly different arguments.

Not a route recommended for large scale systems, but probably fine for smaller utilities.

See http://www.c2000.com/uniplex for more information  

RESTRICTING CHOICES IN A UNIPLEX DATABASE FORM

 

The Uniplex database uses the same mechanism as the screen builder for providing restricted lists, just use the REPLY option in the field definition:

reply="Yes!No" gives you two choices

reply="Yes!No!Maybe" gives you three choices

reply="*cat /etc/choices" reads possible options from the system command.

For example:

label = type char, Prompt="Select Gender", reply="Male!Female";

See http://www.c2000.com/uniplex for more information  

ICANN ANNOUNCES NEW SELECTIONS FOR TOP-LEVEL DOMAINS

 

On November 16th the first official selections for new top level domains (like .com or .uk) were announced, as follows:

.aero
.biz
.coop
.info
.museum
.name
.pro

Now, these TLD's are not available yet and won't be until at least the new year.

It's also disapointing to see after so many entries for new TLD's so few have been selected.  

PAINT SHOP PRO QUICK TIP
Some colour selection tips

 

1) Using the eye-dropper tool to select colours, you can right-click to select the background colour.]

2) If you click the corner arrow image on the color palette then foreground and background are switched.

3) If you right-click on the current color in the color toolbox then you get a choice of the most recently chosen colours - now this is very useful…

See http://www.justkiss.com/psp for more information  

PRIVACY STATEMENTS FOR YOUR WEB SITE
Providing re-assurance for your visitors

 

The text below was generated by the TRUSTe wizard at http://www.etrust.com/wizard. You can use the wizard to make your own statement in about 10 minutes, quite neat it is too. We don't normally web links, but we thought this was especially interesting to our corporate customers.


Privacy Statement for WEB-SITE-NAME

COMPANY-NAME has created this privacy statement in order to demonstrate our firm commitment to privacy. The following discloses our information gathering and dissemination practices for this website: WEB-SITE-NAME.

We use your IP address to help diagnose problems with our server, and to administer our Web site.

Our site uses cookies to keep track of your shopping cart and to make sure you don't see the same ad repeatedly. We use cookies to deliver content specific to your interests, to save your password so you don't have to re-enter it each time you visit our site, and for other purposes.

Our site's registration form requires users to give us contact information (like their name and email address) and financial information (like their account or credit card numbers). We use customer contact information from the registration form to send the user information about our company and promotional material from some of our partners. The customer's contact information is also used to contact the visitor when necessary. Users may opt-out of receiving future mailings; see the choice/opt-out section below. Financial information that is collected is used to bill the user for products and services.

This site contains links to other sites. WEB-SITE-NAME is not responsible for the privacy practices or the content of such Web sites.

Our online surveys ask visitors for contact information (like their email address). We use contact data from our surveys to send the user information about our company and promotional material from some of our partners. The customer's contact information is also used to contact the visitor when necessary. Users may opt-out of receiving future mailings; see the choice/opt-out section below.

Public Forums
This site makes chat rooms, forums, message boards, and/or news groups available to its users. Please remember that any information that is disclosed in these areas becomes public information and you should exercise caution when deciding to disclose your personal information.


Supplementation Information
This site supplements the information that you provide with information that is received from third parties.

Choice/Opt-Out
Our site provides users the opportunity to opt-out of receiving communications from us and our partners at the point where we request information about the visitor.
This site gives users the following options for removing their information from our database to not receive future communications or to no longer receive our service.

You can send email to OPTOUT-EMAIL-ADDRESS
You can visit the following URL: OPTOUT-WEB-ADDRESS

Correct/Update
This site gives users the following options for changing and modifying information previously provided.
email CORRECTION-EMAIL-ADDRESS
visit CORRECTION-WEB-ADDRESS

Contacting the Web Site
If you have any questions about this privacy statement, the practices of this site, or your dealings with this Web site, you can contact

WEB-ADMINISTRATOR
COMPANY-NAME
MAIL-ADDRESS
EMAIL-ADDRESS

See http://www.etrust.com/wizard/ for more information  

WINDOWS SCRIPTING: RUNNING DOS COMMANDS FROM WSH

 

You can use this simple setup if you want to run a DOS command from a Windows Scripting program:

DIM objShell
set objShell = wscript.createObject("wscript.shell")
retval = objShell.Run("cmd.exe /C echo hello, 1, TRUE)

You could use %Comspec% variable instead of cmd.exe if you wish. The /C closes the command window after the command is completed. The actual command "echo hello" is your sample command.  

FORMATTING TIME AND DATE CELLS IN EXCEL.

 

Love these keyboard shortcuts for Excel. From any date or time cell you can:

Apply the Date format CTRL+SHIFT+#
Apply the Time format CTRL+SHIFT+@

See http://www.c2000.com/mswindow for more information  

SUBJECT: RE: WHAT SHOULD I PACK?
Seen on the internet - a slice of real Net life

 

Topic: Re: What should I pack?
From: "Manic"
Newsgroups: uk.local.london.info, uk.local.london

"Rhea Engler" wrote in message

> Coming to London in July (from USA) and would like some
> recommendations on what to pack



Money. Lots and lots of money.

See http://www.c2000.com/fun for more information





Free News by Email
Want your free newsletter emailed directly to you?
Your Email Address :


 

Centreline 2000 - Uniplex, Unix, Windows and Internet
FREEPOST, PO BOX 2000, Pershore, Worcs, WR10 1BR
Tel: (UK) 08000 772000 - Fax: (UK) 08000 772001
 

URL: www.c2000.com/papers/nw_000317.htm
© 1995-2000 Centreline 2000
Last Updated: 06/08/2001
 
  Home
  Products
  Forums
  Contact Us
  Search and Sitemap
 
Home Search and SiteMap How to contact us Free Software for You to Downloads Details on Web Hosting, Design and Programming Full Products Pages NT & Unix Discussion Boards Over 2000 Links to other useful web sites Hot News and Advice on Unix and NT Newsletters packed with great advice, free subscription Full and extensive tutorials and training guides for Uniplex, NT and more Hundreds of Secrets, Tricks and Tips for Linux, Unix, Uniplex and Microsoft products Cream of the Crop: The Best IT Books reviewed and selected Hey, IT doesn't have to be boring!