vb123.com.au                                                          

The VB123 Newsletters   Latest Newsletters Here 

Monthly Receive our standard Access content by email once a month or so Join by sending a blank email to   tips{@}vb123.com Unsubscribe by sending a blank email to    notips{@}vb123.com

 
Note:  We will only use your email address for newsletters filled with content similar to what you will read below and we will not pass your email address to other companies.  Note 2:  You will soon receive the next newsletter if the email can find its way through the fog of anti-spam systems to your account. Happy reading. Garry Robinson - Editor

Rename by unsubscribing and then joining with a new email address

Click here for the Access content RSS Feed (It looks terrific in Internet Explorer 7+ or Outlook 2007)     or add it to your Google Home Page

Table Of Contents

All the Latest articles, gossip and short tips in Garry's Blog 

 http://vb123.blogspot.com/  or at Twitter

The Access Unlimited Newsletter - March 2010  Outlook Linked Tables and a Flutter On The Stock Market, Transferring Logic Through Your App, Displaying Hierarchical Data in a TreeView, Researching Data, Soundex, Querying a Customer Survey Table  

The Access Unlimited Newsletter - November User Interfaces, Solving common query issues, Access 2010 does the Web, Sub-Sub Forms, Users Sorting Solutions and lots more

The Access Unlimited Newsletter - October  Data sheets, Autoexec Macro, Tables without Joins, Tricks With Combo Boxes, Alternative Access Buttons and lots more

Access Unlimited Newsletter September No. 2  Great reports, multi-column list boxes,  analyze data in grids..

Access Unlimited Newsletter - September No 1  Build Word 2003 Docs with XML, Classes to Enhance List and Combo Boxes, Explore like Forms in Access, Null Fields, Read the Manual, Access Passwords, Access MP3 ...

Access Unlimited Newsletter - August No 3

Access Unlimited Aug 2009 - No 2 Normal forms 2-5, merge to Word, client server issues, handle milliseconds, remote updates of a back-end database

Access Unlimited Aug 2009  Mouse Scroll Wheel, migrate to SQL Server, data modelling

Access Unlimited July 2009  Data Modelling, User queries on the fly, Highlighting search matches in Access 2007, Doug brings families together using SQL, Full Article and Author Index for Smart Access Published,  our brand spanking new huge Smart Access inspired website.   

Access Unlimited June 2009  Explore data with Access 2007, Prepare for SQL Server, Searching All Tables In A Database,  Creating Charts/Graphs in an Access 2007 Database, Smart Access and much more from our blog in 2009.

Access Unlimited News - Issue April 2009  Sent with FMS Email product, Get ready for the Upturn, Office 14 in 64 Bit ?, Creating A SharePoint Task List with a Custom Workflow Reminder, Developers and Information Workers in a tricky business climate

Access Unlimited News - Issue Oct 2008 to March 2009   Link Subforms to the Control rather than the Field, Access Support for New Data Types in SQL Server 2008, Creating A SharePoint Task List with a Custom Workflow Reminder and more

Access Unlimited News - Issue May-Oct 2008  Removing the DBO prefix in Newly Upsized SQL Server Linked tables, 10 Reasons Why IT Pros Hate Access (but Shouldn't) and more

Access Unlimited News for Jan-April 2008 Conditional Formatting,  Integrating Access with Sharepoint Server and more

Newsletter 85 VBA Lives on, Garry uses basecamp, Bill Gates last day, shift key

Newsletter 84  Remote desktop, unnecessary indexes, SimpleDB from Amazon, Office 2007 Service Pack , ACCDE Service Pack 1 Issues, New Jet Engine Release

Newsletter 83  IT Departments and Microsoft Access, add a Tick to your reports, processing SWREG Order Emails in Access and Outlook, report monthly data without code.

Newsletter 82  Access 2007, PDF update, tips and tricks including VBA

Newsletter 81 Using Access libraries, counters in queries, Access team blog

Newsletter 80 Confirm records, Access team blog, sharepoint and Access 2007

Newsletter 79 Right click menus, free Access 2007 Developer Extensions

Newsletter 78 Access 2007 Macro security MSDN article, Google database, books

Newsletter 77  SMS from Access, Macro Protection 2007 Video, Excel vs Access 2007 filtering

Newsletter 76 Access MVP conference and websites of Access MVP's

Newsletter 75 Install Access 2007 with care - Pain reduction keyboard

Newsletter 74 Excel to Access - Data Mining - Access Consulting Services

Newsletter 73 Access 2009 - Optimise Access to SQL Server

Newsletter 72  Internet Explorer RSS Feeds | Optimise VB -| Changing Form Properties on Mass

Newsletter 71  Backing up Multi-User Databases | Original MDE Code in Access 97 databases

Newsletter 69 Is Hiding Databases A Good Idea? | Where are your email files

Newsletter 68 Thanks Peter Vogel | Denormalisation | Access SQL Diffs | Access 2007 Blog | UK Users Group Meeting | Aussie Contract Work

Newsletter 67 Access 2007 - An Overview Of Features | Good reading links

Newsletter 66 Reading Emails With VBA | Access 2007 - Workgroup Security Is On The Way Out | Reading An MDB Database in Outlook | Good reading links

Newsletter 65  Simplifying Complex SQL | Office 12 | Queries to impress your boss | More RSS Feeds

Newsletter 64 Stop Outlook Warnings | HTML Help Tool | Bumper good reading links once again

Newsletter 63 Recent XML feeds at vb123.com

Newsletter 62 Business subscriptions | Understanding what XML feeds are

Newsletter 61 Service Pack introduces Access to Excel Linked Table Problems | Access Workgroup files and shortcuts | New Database Repair service at vb123.com | Good reading links

Newsletter 60 Access setup logging | Viewing Contents of a Text Box in a Zoom Field | Did you know this about VBA? | Jet Virus Wreaks a Little Havoc | How to Customize the MS-DOS Command Window | Bumper good reading links once again

Newsletter 59 How to manipulate Access startup properties | How to easily change Access startup properties with the Workbench | How to change a backend database | Security Tip | Access database recovery service | Good reading

Newsletter 58 How to Change A Backend Database | Making Data Upper Case Revisited | Annoying Hyperlinks in Access 2003 | Vote For The Workbench | Good Reading

Newsletter 57 How to Speed Up Your Access Database | Making Data Upper/ Lower Case | Scatter Plots | Why XML Is Very Important To Microsoft | A Review of the Workbench | Collapsing Menus | Microsoft Trademarks | Adobe V's Microsoft |

Newsletter 56  Hide passwords as they are typed in | VBA Compiler TipHide passwords as they are typed in | VBA Compiler Tip

Newsletter 55 Are Your Users Running The Same Version of The Access Jet Engine? | The Hidden Index Option In Access | Office Security Updates | A Big Update To The Toolbox | The popular GOOD READING section

Newsletter 54 How to setup Version Numbers in a Database | Use The Workbench To Manage Your Release Version Details Internet Explorer Cookies | The 1033 Folder | Access 2003 Linker Problem | Good Reading

Newsletter 53 Home grown Access Security | Find Carriage Returns (in a Field) | Good Reading

Newsletter 52 Conclusion Of The Responses For The Next Version Of Access | MSN Toolbar Searching Suite and More On Desktop Searching | Good Reading

Newsletter 51 Stop Those Access Menus and Toolbars From Moving (97 upwards) | Citrix / Remote Desktop for an Access-developer | Microsoft Baseline Security Analyzer, and all about Anti-Spyware Software | Instant Desktop Searching - A Knowledge Workers Constant Companion | Good Reading

Newsletter 50  Access Unlimited ~ 50 Editions | The Search Engine War Has Started ~ Google Desktop | The Next Version Of Access | Give Your Eyes A Break When Designing Queries | Access 2003 Service Pack Fixes | News on Garry's Access Protection and Security Book | Code Thought for The Day | Good Reading

Newsletter 49 The next version of Access have your say | Workbench now includes version handling and lots a links in the Good Reading section

Newsletter 48 Those naughty cascade deletes | A global error handler | More on subforms in new windows | Denver Access Users Group -Special 10th Anniversary Celebration | New demonstration database available from Microsoft | Good Reading

Newsletter 47 View Subform Or Subreport In A New Design Window |
Mike Gunderloy Grills Garry On Life  As A Developer | Bumper Good Reading

Newsletter 46 - Digital Signatures | Protect A Database Folder Using Windows XP | Database Maintenance - Decompile And Compile | Access Filters | Garry's Ms Access Protection And Security Book | Good Reading | Sample Of Digital Ink from a Tablet

Newsletter 45 - Spell Check an Access Field | Single Record Locking, Bloat And Citrix Bugs | A New Access Add-In and Garry's Access Security Book |  Good Reading

Newsletter 44 SQL Server Developer Pricing Plummets | Reserved Words | Limiting comments from reviewers in Word | Garry's Book Chapter Overview | Good Reading - Another Bumper Edition

Newsletter 43 Garry's Ms Access Protection And Security Book | Free Backup Book Chapter | Installing Access/Office 2003 | Ms Word Protection and Recovery Tips | Google Tips | Upgrades to the Workbench | Good Reading - Another Bumper Edition

Newsletter 42 Database Evolution - From Excel To Access To Enterprise Db | Garry’s Ms Access Protection And Security Book | Hot Microsoft Software Purchasing Tips | Google Tip - Find Out The Dictionary Meaning Of A Word | Books And Websites From A Couple Of Legends | Good Reading - Bumper Edition

Newsletter 41 Switch The Mouse From Right To Left And Back | Access 2003 | About Internet And Learning | Database Evolution | Yet More On The Junk Email Epidemic

Newsletter 40  Speeding up complex query development | software prizes | junk email < 75% | review of access 2002 vba handbook | final word on html emails | the workbench has been revised |

Newsletter 39  Are you keeping time ? | the solutions database | MS Word shortcuts | compact and repair database in workbench | sql server worm. | Access 2002 shortcut keys | good reading | reader feedback on html emails 

Newsletter 38 A new format for access unlimited | excel chart programming | postcard from mongolia | reader feedback | win a copy of some of our software | good reading

Newsletter 37 Garry's Xmas stocking suggestions | win a copy of some of our software | option explicit | the Access 10 commandments | good reading

Newsletter 36  Upgrading office and other software | the workbench gets a major upgrade | windows xp popup keyboard | turn off microsoft reporting on win xp | lists of files in a folder | good reading | wrapping this Newsletter up - getting a job

Newsletter 35  My second favourite newsletter | the workbench | pdf generation | good reading | not so extreme programming

Newsletter 34  Re-using the format painter | resending messages in outlook | sql in ado in access | access security wizard | google groups are great for searching | add a line number to your error messages | speech recognition in office xp | computer security downloads for visual basic 6 service pack 5 | insert statements in sql in access | cheap pdf alternative | good reading | the workbench has arrived - editorial

Newsletter 33   Incorporating Outlook tasks into Access | saving space in outlook | cleanup your Access database | get out of database jail with excel | security of hard drives

Newsletter 32   Default values for combo boxes | software does get too old for microsoft | Access 2002/2000 forms display property box | do not open a 97 database in Access 2000/XP | logging of users activities in a database | more competition - informix and ibm | great tips from readers | windows XP cd-rom recording | frontpage space saving tip

Newsletter 31  Finding send to | lookup tables - improve data quality in your database | backing up local versions of microsoft outlook | revamped vb123.com search engine | Office XP activation issues | good reading | excelent $$$'s to be made

Newsletter 30  New software at vb123.com | get the design right and you are almost home | read the books that we read | explicitly close recordsets | windows XP upgrade | building hyperlinks to jump into a web site | good reading

Newsletter 29   Duplicate data entry for Access | FMS becomes a sponsor | big brother - Office XP activation wizard | regional date checker | outlook/exchange linked tables | good reading links - bumper Access msdn links

Newsletter 28   User interface housekeeping task | save as pdf from Access | Toolbox exclusives | completely delete email messages and files | making your buttons more keyboard friendly | more user friendly searching in Access | red balloons | date bug to watch for | frontpage XP - first look | good reading links | shark infested Access

Newsletter 27   User interface issues - the first record | turn Access rows into columns  | compacting - repairing databases | Outlook security patch - 2002/XP | multi-column reports  | good reading links | offsite backup

Newsletter 26   Searching through multiple Excel worksheets | give Outlook a tuneup | vb123 jobs | winzip 8.0 | four foot gators | writing around word pictures | does an Access 97 subform have any records in it | balloon flying with Office XP | good reading and useful sites | Access bugs fixes | Office XP - a first look |

Newsletter 25   Microsoft Office Conference & Access Links.

Newsletter 24   Getting on top of vb programming in excel | smart selection combo boxes for queries | Access Unlimited has a new name | all the latest articles etc on Access 2002 | good reading and useful sites

Newsletter 23    Page formating of reports in Access 2000 bug | seven performance hints for combo and list boxes  | good reading and useful sites

Newsletter 22    Office XP - the Access upgrade mystery | vb.not - some thoughts  | search your Access help for some good reading | and yet there is more | good reading and useful sites

Newsletter 21    email and remote email in Access | a quick record counting trick | backup your tables using xml (text) | Access 2000 verses Access 97 | search your Access help for the following phrase | and yet there is more ... | good reading and useful sites

Newsletter 20 windows key - it's a hot key when used with other keys | vb123 in the usa | finding a field in Access datasheet view | search your Access help for the following phrase | has a table been created today ??? | saving the current Access record | and yet there is more ... | good reading and useful sites

Newsletter 19   going backwards in a form | small screen dumps | how does graf-fx work ? | visual basic for ce windows | msdn online- some great free articles | free stuff | data transformation services | corrupted Access 97 database - an unlikely repair idea | good reading and useful sites

Newsletter 18   shaping ado queries with Access subdatasheets | a searchable ebook for Access developers | creating an index search facility for your web site | Access snapshots - save your reports as secure documents | constructing html help files | are you ready to call microsoft ??? Office service pack 1 | good reading and useful sites

Newsletter 17    Access form and report toolbar tuneup | hyperlinks in Access - no more annoying web toolbar | Access 2000 keyboard locking bug | Access 2000 - why does it have to happen to me | switching to landscape mode in Access 2000 reports | good reading and useful sites section

Newsletter 16     projecting the correct online image with asp | a great new web site for Access programmers | vbscript - a follow up to last months edition | daylight savings changes in australia | tiny trainers for beginner Access and excel users | a selection of sendkeys vb's | moving around a busy Access form - a quick wizard | and lots lots more

Newsletters 11 -15    Simple Solutions To Protect from VB Script Viruses and Converting Excel Spreadsheets to (Access) Databases | Compact your screen dumps before emailing | tracking changes to records | Access security and passwords | vb6 ado add-in released  | Properties window | caching, xml, ado | mapping in Access | calendar and time picker | freestuff browser | changing external database properties  | New features in Access 2000 | Access 2000 conversions - gotcha (plus decompile) | Alternate visual basic graph objects  | Reports and forms - get control of those controls | colour those dull reports | web style over content | converting excel data - its the wrong way round | get control of excel using visual basic | Access 2000 tip - useful properties 

Newsletter 6 -10    Ed's top tip | Ed's favorite shareware | preparing for year 2000 - a few late tips | dueling Access 2000 and 97 

Newsletter 9    Access filters - how to use them | Access pizaz - mouse move and mouse hover methods |

Newsletter 8    Access Reports - No Data | Search For Text Anywhere In A Database | A Tool To View Images Quickly | Time Is Ticking Down To Windows 2000 | Windows Quick Tips | Under 18 ? | Combo Boxes That Look To Themselves For Inspiration | Updates To

Newsletter 7   a great vb debugging tip | emailing using Access and word | fx classes - Office automation source code | save your reports and maps with adobe acrobat | getting support details into your Access application | Access security 

Newsletter 6    getting your information into excel | put your database to work | vb123 wins site of the week award | making a professional looking web site | hardware bugs 

Newsletter 2 thru to 5    finding things in reports | building documentation | microsoft y2k guide | dates are hard enough even without y2k | controlling microsoft graph and chart - free download 

Newsletter 4    microsoft solutions database | announcing vb123 - the software resource site | making arrow keys work in continuous forms view | indexing fields in microsoft Access | making excel a reporting and graphing tool | controlling microsoft graph

Newsletter 3    Download a useful TimeClock control | Learn how to round significant figures in queries | A find and replace add-in for Access | A review of a find and replace tool for Windows files |

Newsletter 2    Office-Access 2000 installations issues | Simple Year 2K checklist | Making the data in graphs your own | Data Mining - Reading Material | Links, Articles online etc.

Newsletter 1    jazz up your forms | year 2000 | advanced group by | popular Access pages on our site |

View latest RSS Feeds as HTML