Welcome To Tips-FX - Edition 3

Rounding Of Numbers

Have you ever added a formula to to a query and found that the answer is something like this

1342.3434553413

You reset the format property in the grid of the query to 2 decimal places and this fixes the display. You then export the file to text or Excel and all the decimals come flooding back. To fix it

First open a new module and add the following code

Function Round2(x)
'
' Rounds a number to 2 decimal places
' Uses arithmetic rounding
'
Round2 = Int(x * 100 + 0.5) / 100
End Function


Close the module and open a query

Enclose the equation inside the Round2 function as follows

round2([Field1]/[field2])

and your output will now be rounded to two decimal places. The following shows it working in a SQL query

SELECT [cost]/[quantity] AS LotsOfDecimals,
round2([cost]/[quantity]) AS TwoDecimals
FROM itemsSold;

You can pick up this routine and plenty of others by downloading the neatcode database from the Microsoft site. Follow the directions from

http://www.gr-fx.com/toolshed/99/freestuff.htm

Now open the database and you will find lots of functions that you can copy into your database free of charge.


Review: Search and Replace tool for Windows Files (Ver 2.94)

http://www.funduc.com/
Company: Funduc software

Funduc has several tools on offer, all of them available as shareware (for 60 days) or registered versions.  The registered version of Search & Replace is $25 US dollars.
At first you think it is just the same as the windows find  tool, but it is different.

Not only can you locate the files but if you specify specific text to find within the file it will also give you the location of the text within the document. With the registered
version of the tool you can also replace the specified text, although that is only recommended for text files such as *.ini, *.txt, *.csv and *.HTML etc. (In the unregistered you can only replace five times in a session)

It operates almost like grep for those who grew up with Unix.

It has many options

Case sensitive search
Search sub directories
Whole word search
Fully user customizable tool bar
Ability to search inside of zip files
Ability to set/change file time, date and attributes of
located files
Date filter
Scriptable

I enjoyed using it and found that the user can modify the tool bar also. The many options make this tool very powerful. I would recommend it to anyone working with text files, or
needing to make bulk changes to file attributes in more than one directory at once.

4 out of 5 stars

Review by Scott McManus
scott@skandus.com

Good Reading and Useful Sites


Find out about the Web Components Of Office 2000
 

Useful Key Strokes

If you are programming in visual basic (in Office or VB), here are three invaluable key strokes that you can call upon.

Definition

If you want to see the code in a subroutine / object class that you are using, right click on the subroutine and choose "Definition". This will take you directly to the code of that subroutine.

Last Position

Now that you have used "Definition" and want to return to where you were before, right click again and choose "Last Position"

Control SpaceBar

Say you have a variable with a name dimensioned as follows

Dim ThisIsAVeryLongVariableName as Integer

When you are typing the variable name, you might type the first
6 characters of the variable name

... ThisIs

Now hit Control Spacebar and VB will fill in the rest of the
variable name for you. I first picked this tip up from the
free tips section of Smart Access

http://www.pinpub.com

Add An Icon File To Your Web Site

If you want to make your web site standout in other peoples favorites list, here is a really useful thing to do.

In the top directory of your web site, add an icon file called favicon.ico like we have

http://www.gr-fx.com/favicon.ico

This will now make your icon appear in the IE 5 browser when people visit your site. It will also save the icon if you are luck enough to have people add your site to their
favorites.

How popular is IE5. We now have 600 people a day visit our
site and they use

IE4 45%
IE5 25%
Netscape 4 19%
IE3 8%
Others 3%

By the way, an icon file is a 40*40 bitmap with a filetype
of ico. Search for *.ico using windows find file.

Previous Editions


http://www.gr-fx.com/toolshed/news/issue2.htm
http://www.gr-fx.com/toolshed/news/issue1.htm


The Revamped Toolshed And Fast Graphs

"The Toolshed" with all our online Access and VB resources has now been enhanced so that it is much easier to find articles and tips. Try it out at

http://www.gr-fx.com/toolshed/tips-fx.htm

A New version of Graf-FX is now available from

http://www.gr-fx.com/graf-fx.htm

A new version of the consolidation query wizard will allow you to graph your information from Access directly into Excel.

http://www.gr-fx.com/wizards/


Feel free to make comments, copy the email to a friend
or maybe even contribute to the next edition.

Thanks for reading our popular newsletter.


Garry Robinson - Software Consultant

GR-FX Pty Limited


Click on this button to read the previous edition of Tips-FX

Published  1999-08

Links >>>  Home | Search | Workbench | Orders | Newsletter | Access Security | Access professionals