Welcome To Access Unlimited - Edition 13
See all newsletters

Access Unlimited is a email newsletter that provides free tips, help and information for skilled Microsoft Access users and related software disciplines.

In this edition

QUICKLY OPEN THE PROPERTIES WINDOW IN ACCESS
CACHING, XML, ADO AND COMBO BOXES
MAPPING AND MINING SOFTWARE IN ACCESS
VB123 WINS VB-ZONE SITE OF THE WEEK.
SEARCHING OLD EDITIONS OF Access Unlimited
MORE ABOUT THE CALENDAR AND DATE TIME PICKER
HOW DO I BUILD A WORD PROCESSOR INTO MY VB APP?
MICROSOFT ACCESS 97 AND 2000 FREE GOODIES
DON'T PANIC - HERE COMES THE BOSS
CHANGING EXTERNAL DATABASE PROPERTIES
GOOD READING AND USEFUL SITES
-------------------------------------------------------

PUT THE DESKTOP IN YOUR EXPLORER FAVORITES

Go to Internet Explorer and click on the down arrow on the address bar. Now choose Desktop. This will show all the shortcuts on your desktop. Save it as a Favorite and you will now be able to go to your desktop using Explorer favourites without minimising all your windows.

-------------------------------------------------------

QUICKLY OPEN THE PROPERTIES WINDOW IN ACCESS

Make an Access macro called AutoKeys
View The Macro Name column

The Macro Name will be called ^X
The action will be SendKeys
The keystrokes will be %VP

This will open the properties window whenever you hit Control X

Those of you who use Control X for Cutting, will need to choose different key strokes e.g. Control Q

-------------------------------------------------------
MORE ABOUT THE CALENDAR AND DATE TIME PICKER

by Eric Hertig

I enjoy the newsletter and it has lots of helpful info. I found some
other informative vb stuff at this link
http://www.microsoft.com/officedev/articles/integoff.htm .

I also tinker with Visual C++ and the microsoft date-time picker control is another alternative for a clock/calender which I have successfully used in Access,
VB6.0, VC++5.0/6.0. It does require registration since it is an ActiveX
control but that can be done with Basic or C++ without too much pain.

For VB I found it on codeguru at

http://codeguru.developer.com/vb/articles/1771.shtml .

It was a winner for their VB contest. As mentioned you can also use the regsvr32.exe to do it but this does it in code that can be embedded in your own app. The date-time picker control comes with VC and VB and resides in mscomct2.ocx.

Pickup your free calendar and clock forms for Access from

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

-------------------------------------------------------

CACHING, XML, ADO AND COMBO BOXES

Learn to use these local persistent recordsets to cache information for display in ComboBoxes or ListBoxes on Access forms. An Article by GR which you can find at

http://www.msOfficePRO.com/

for this month by clicking on the persistent caching graphic or the Take A Load of the server link or simply use this direct link if you read this after March.

Persistent Caching >>>Take a Load Off Your Server with Access 97-2000

-------------------------------------------------------

MAPPING AND MINING SOFTWARE IN ACCESS

Garry Robinson, with some help from Scott McManus, demonstrates techniques that can be used for statistics, graphs, and extending your crosstab queries, regardless of how you want to lay out your data.

Purchase this revolutionary article from Pinnacle for only $5 and find out how to do some really interesting things with grids using Access queries ….

http://www.pinpub.com/access

-------------------------------------------------------

CHANGING EXTERNAL DATABASE PROPERTIES

In the last edition, Peter Hallinan from 3rd Millenium posed a really curly question about how to change external database properties. The winning answer and a real good second are described in the following page and in the download file.

http://www.vb123.com/toolshed/00_accvb/mdbproperties.htm

If you are interested in a tool to help with the hassles of front-end database distribution, contact Peter at http://www.3rdmillennium.com.au/

-------------------------------------------------------

VB123 WINS VB-ZONE SITE OF THE WEEK.

VB123 gets a good review from one of the biggies

http://www.devx.com/free/links/siteview.asp?content_id=1335

For a new site every week try

http://www.vb-zone.com/free/site.asp

-------------------------------------------------------

SEARCHING OLD EDITIONS OF Access Unlimited

As the newsletter is getting quite popular, we have set up a table
of contents page for all the old editions of the magazine as follows

http://www.vb123.com/toolshed/news/toc.htm

If you wish to search the old newsletters, try

http://www.vb123.com/search

Enter the keyword "Tips" as well as your own keywords.

-------------------------------------------------------

Online Software and Book Purchases From Amazon.Com

Try out the new electronics section at Amazon.

Click here to enter the store at places suited to
the readership of this magazine

http://www.vb123.com#software

-------------------------------------------------------

MICROSOFT ACCESS 97 AND 2000 FREE GOODIES

http://www.vb123.com/toolshed/99/freestuff.htm

-------------------------------------------------------

Search the net from inside visual basic. This is really easy to install and works straight away. Highly recommended search tool but it only works in Visual Basic. If you are programming in Access, this site is good for things such as ADO, Office Automation and other external stuff.

http://www.codehound.com/

* Is There Any Way to Limit the Amount of Memory Used by ADO?
http://www.inquiry.com/techtips/thevbpro/answer.asp?pro=thevbpro&docID=4285

Codeguru ran a Visual Basic competition.

http://codeguru.developer.com/vb/vb_codeguru/codeguru.shtml

Here are some of the entries

Raising ColumnResize event in MSFlexGrid
HTML Syntax Highlighting
Leap Year Validation
Standard Name Formatting Routine
Improved Mid$ Statement
VB Syntax Coloring
Formatting Strings
Run an application inside of the previous application instance

Database web sites and articles at CodeGuru

http://codeguru.developer.com/vb/Database/index.shtml

Advanced ADO for the VBA Programmer
By Stephen Forte

http://www.microsoft.com/ACCESSDEV/Articles/lavs305.htm

Notes On The Access 97 Treeview Control
http://www.vb123.com/toolshed/00_accvb/treeview.htm

Searching for help online. Try
http://www.myhelpdesk.com/

All about using the debugger.
http://www.msOfficePRO.com/features/2000/03/vba200003ec_f/vba200003ec_f.asp

If you think you are not being watched when on line, then look at the patent from one of the biggest banner distribution companies. They know where you have been, what you like and even how many times you have seen an advertisement. Think of that for a database.

http://www.patents.ibm.com/details?&pn=US05948061__&s_detd=1#detd

Administration

PREVIOUS EDITIONS OF Access Unlimited
http://www.vb123.com/toolshed/news/toc.htm

-- OUR SOFTWARE AND RESOURCES -----------------------

Explore your data visually using our popular Access
data mining shareware

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

View our web site on your computer rather than the slow
old web and have access to all the software discussed in
the articles and information pages at www.vb123.com

---> http://www.gr-fx.com/toolshed/

So thanks for reading our popular newsletter.

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

°`°º¤ø,¸¸,ø¤º°`°º¤ø¤º°`°º¤ø,¸¸,ø¤º°`°

Garry Robinson - Software Consultant

Click on this button to read the previous edition of Access Unlimited 

Published  2000-01

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