|
Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word? Home Page Bloglines 1906 CelebrateStadium 2006 OfficeZealot Scobleizer TechRepublic AskWoody SpyJournal Computers Software Microsoft Windows Excel FrontPage PowerPoint Outlook Word 
Host your Web site with PureHost! 
|
 
Monday, June 29, 2009 – Permalink – Access Tools for Free or FeeShareware/FreewarePeter De Baets has some for pay and some for free downloads at Peter's Software. In the past I have used his Shrinker-Stretcher ShrinkerStretcher will automatically rescale/resize your MS Access forms, controls, and fonts to fit any screen resolution, desktop scheme, or font setting. For free includes:
See all Topics access Labels: Add-in <Doug Klippert@ 3:36 AM
Comments:
Post a Comment
Thursday, June 25, 2009 – Permalink – Compact Before SynchronizingA DB two stepIf you're working with a replicated database, always compact it twice before you synchronize. The first time you compact, Access marks objects that need to be deleted, but it doesn't actually remove them. The flagged objects are removed the second time you compact the database. Although there's no harm in additional compacting, there's no added benefit. This is particularly important to do when working with the Design Master. Each time you make design changes to the Design Master, a copy of the original object is kept in the database. If you edit and save a Report or Form 10 times, your database actually has 9 older versions of the form in it. The same is true if you change the schema of a Table or Query If you synchronize before compacting, all of the versions are sequentially sent to the other replicas until everything is in synch, and you can't reclaim the space taken up by the older versions. However, if you compact the database first, only the most recent form version is sent to the replica. See all Topics access Labels: Tips <Doug Klippert@ 3:29 AM
Comments:
Post a Comment
Tuesday, June 23, 2009 – Permalink – Mail Your MDB-ACDBDon't let Outlook stop youThere was a lot of frustration with Outlook 200x. If an Access MDB file is received, Outlook expects the worst and blocks the attachment. The trick has been to ZIP the file or change the extension to something like .DAT. Here's a registry trick that restores Outlook to the good old days. Outlook 2007, 2003, 2002 and Outlook 2000 SP3 allow the user to use a registry key to open up access to blocked attachments. (Always make a backup before editing the registry.) To use this key: If you are using this registry entry, a glance at Help>About Microsoft Outlook will show Security Mode: User Controlled above the license information.Slipstick.com: Opening .exe Attachments Also see: Shortcuts for Sending Access Objects via Email See all Topics access <Doug Klippert@ 3:33 AM
Comments:
Post a Comment
Sunday, June 21, 2009 – Permalink – Clip Art at HomeInstall moreDo you remember all of the clip art that was available locally with Office XP? When you have an Internet connection, you have access to the Office Online collection, but if you would like more clip art installed on your machine: A small amount of sample clip art images was included The 2007 Office systems and Office 2003 and is part of the "local collection" that is searched when you do not have Internet access to the Microsoft Office Online Clip Art and Media Web site. Office 2003 no longer included a media content CD with additional clip art. However, the Microsoft Office XP Media Content CD can still be installed locally or on a network share.Support.Microsoft.com How to add clip art to Clip Organizer in a 2007 Office system and in Office 2003 See all Topics access Labels: Graphics <Doug Klippert@ 3:02 AM
Comments:
Post a Comment
Wednesday, June 17, 2009 – Permalink – VBA Variable ProblemsExplicit protectionIt's good practice to always use the Option Explicit statement in the beginning of your code modules to ensure that all variables are unambiguously declared in your procedures. With this process in place, you'll receive a "Variable not defined" error if you try to execute code containing undeclared variables. Without this statement, it's possible to mistype variable names, which would be interpreted as new Variant type variables. This could severely impact the results of your code, and you might not ever know it. If you do find a problem, tracking down where the error is can be a chore. Although you can manually type the statement into your modules, changing a setting in Access can ensure that the statement is always added to new modules.
 See all Topics access Labels: VBA <Doug Klippert@ 3:37 AM
Comments:
Post a Comment
Wednesday, June 10, 2009 – Permalink – Automaticaly Setup a DatabaseLink in a snapWhen you're creating a new database that will link to data that isn't in an Access format, you can speed up the setup process. Rather than creating a new database and then using the File>Get External Data>Link Tables,
See all Topics access <Doug Klippert@ 3:55 AM
Comments:
Post a Comment
Thursday, June 04, 2009 – Permalink – Database ExamplesClever timesaversRoger Carlson, RogerCarlson.com, has collected a group of Access databases that demonstrate different functions. The Library includes tutorials and a good list of files that can be downloaded. See the Table of Contents
And many more See all Topics access <Doug Klippert@ 3:34 AM
Comments:
Post a Comment
|
