SSW Monthly Newsletter And User Group Reminder
This newsletter is a service offered exclusively to clients of Superior
Software for Windows.
It offers the latest product news as well as Hot Tips which will help
you get the most from your existing SSW Products and Services.
1. THE ACCESS/ASP/SQL SERVER USERS GROUP SYDNEY, Wednesday 16th August
2. PRODUCT NEWS: SSW DATA RENOVATOR - Data Renovator gets rave review
in Technical Magazine Smart Access
3. HOT TIPS FOR DEVELOPERS
4. DATABASE NEWS - THE HOME LOAN COMPANY
5. ASP Guru? Work at SSW!
1. The Access/ASP/SQL Server User Group
Sponsored by Microsoft and SSW Wednesday 16th
August 2000, 5:45 pm ==========================================================================
SQL Server 2000 Tools
Overview This Month
We have a couple of presentations, the feature one from Dave Lean of Microsoft.
Dave will be presenting a detailed overview of all the tools and their
enhancement in SQL Server 2000.
What do I bring along?
Just your self.... and a hot tip on any of these topics:
* HTML / Front Page
* SQL Server or
* Hot Sites
Tips to get there You can catch the following buses from Town Hall City:
288 - Express to Epping. 290 & 292 - Epping via Crows Nest. Ask your friendly
bus driver to let you off near Microsoft. See the map at www.ssw.com.au/accessUG
2. SSW DATA RENOVATOR
Data Renovator gets rave review in Technical Magazine Smart Access by
Garry Robinson www.vb123.com
What does he say?
"Into this minefield of complexity and valuable live data steps an Access
utility called SSW Data Renovator. The program is designed to transfer
information from an old database structure to a new database structure.
It does this by analyzing both databases and working out what has changed
between the old and the new... "I would recommend the product for a lot
of transfer exercises as it will allow you to concentrate on the job of
getting the newest database design correct... "Thinking back this program
could have saved me about 30 hours in the last year and as the program
is delivered to you fully operational for 50 trials, then you should have
no trouble deciding if it OK for you..." visit http://www.ssw.com.au/ssw/DataRenovator/
to see how SSW tools can make development that much easier... Get more
info at the web site - http://www.smartaccessnewsletter.com/ or contact
Garry Robinson www.VB123.com.
3. Hot Tips for Developers
The SQL Server 7.0 "Currency" data type stores monetary information to
four decimal places. This can get messy when calculating and storing values
such as GST Amounts. To avoid repeatedly using "CAST" and "CONVERT" and
"ROUND" in stored procedures, you should try using a user-defined datatype.
A data type of decimal (19,2) should do the trick. 19 is the total length
of the number ("precision"), and 2 is the number of decimal places ("scale")
of the number. To make it even easier to use, create a new default of
"(0)" and assign it to the datatype. Using data types and defaults in
this way allows greater consistency between fields in the database.
VB/ Access Beginners Tip
Don't use If...ElseIf...ElseIf... when a Select Case is more appropriate
Example of code in the OnCurrent Event
If DateDiff("d", [LastPay], Date) <= 30 Then
Me.Detail.BackColor = vbWhite
ElseIf DateDiff("d", [LastPay], Date) < 60 Then
Me.Detail.BackColor = vbYellow ElseIf
DateDiff("d", [LastPay], Date) > 90 Then
Me.Detail.BackColor = vbRed
This code more efficient and more easily updated with this Select Case...
lngDays = DateDiff("d", [LastPay], Date)
Select Case lngDays
Case <= 30
Me.Detail.BackColor = vbWhite
Case 31 to 59
Me.Detail.BackColor = vbYellow
Case 60 to 89
Me.Detail.BackColor = vbBlue
Me.Detail.BackColor = vbRed
Thanks to Brendan Reynolds email@example.com
Got a hot tip you want to share? Email 696e666f72407373772e636f6d2e6175
4. DATABASE NEWS - THE HOME LOAN COMPANY =========================================================================
The Home Loan Company SSW has worked with The Home Loan Company since
1996. The Home Loan Company commissioned SSW to build an Access 97 database
to administrate the businesses customer and financials. Peter Beverley,
The Home Loan Company's General Manager said that "SSW have shown real
expertise in Access, that's why we've kept coming back."
For all your home loan needs call the Home Loan Company 61 2 9840 1011
SSW caters for a broad range of clients, from small single person enterprises
to large multinationals. Our skill set is diverse enough to be able to
meet your range of development needs while maintaining a level of expertise
that ensures we know how to answer your questions. SSW has built up serious
expertise in Access over the last 10 years and still consults in pure
Access as well as SQL, VB & ASP.
Call SSW 61 2 9953 3000 for all your Access, SQL Server, VB ad ASP development
5. Love New Technology? Work at SSW
SSW is looking for an articulate Senior Database Developer focused on
new technology and dedicated to getting the job done.
SQL SERVER + Stored Procedures
Attractive Salary will be negotiated. Call us 61 2 9953 3000 to arrange
SSW’s Marketing Team edits this newsletter. We would like your feedback.
If you have a tip you want to share, a website you want us to review or
comments on our service, please write to 696e666f72407373772e636f6d2e6175
or visit us at
www.ssw.com.au SSW Pty Limited Gateway Court,
Suite 10, 81 - 91 Military Road, Neutral Bay, NSW,2089 Phone: +61 2 9953
3000 Fax: +61 2 9953 3105 www.ssw.com.au SSW specialises
in delivering efficient, cost effective solutions for your database or
Internet requirements. Our ability to integrate these functions together
helps companies streamline operations, while making the most of opportunities
presented by the on-line world. If you can't use our services at the moment
but know someone who may, pass on our details.........it could earn you
some easy $$$$! SSW has a guaranteed $150 Spotters Fee for
any referrals we convert into new Database or Web Site development business.
We're not the people surfing the net, we're the people making the waves.
To unsubscribe from this newsletter: info@s*w.com.au