vb123.com

Garry Robinson's Popular MS Access, Office and VB Resource Site

 

Home  Contact Us
Order our Software

RSS & Newsletter  
Join our XML/RSS Newsfeed or sign up for our informative newsletter on Office Automation, Access and VB topics
Read More

Get Good Help
If you need help with a database, our Professionals could be the answer
Read More

  Is Your Database Corrupt ?
If you have a corrupt database, Try our Access Recovery service

The Workbench  Find out who has your database open, start the correct version of Access, easy compacting and backups, change startup options, mde compile,  shutdown database Read and Download

The Toolshed 
Searchable help file comprising of all the information at vb123.com plus hidden downloads etc. Read More



The Toolbox

Libraries of software that we regularly import into our projects. This is a newer version of the Toolshed More..


Access >>> SQL 
Upsize to SQL Server 2005 or 2008, easily repeated conversions, highly accurate SQL query
translation and web form conversion.
Read More

SharePoint
For our company file sharing and task management, we use
SharePointHosting

DryToast 
Backup and query your BaseCamp
® projects
Read More


Datamining/Graphs

Explore your data with this versatile graphing and data mining shareware tool.  Read More

Garry's Blog
Find out a few other things that Garry has been writing about Microsoft Access. Read more

Like FMS Products?
Purchase them from us and get a free Workbench or Toolbox  More

About The Editor Garry Robinson writes for a number of popular computer magazines, is now a book author and has worked on 100+ Access databases. He is based in Sydney, Australia
Contact Us ...

Search ...

or try our new site built with SharePoint Designer
 vb123.com.au
 

 

The VB123 Newsletters   Latest Newsletters Here 


 
Monthly Receive our standard Access content by email once a month. 

 


 

Weekly MaxOut  Receive our standard Access content plus content from other prominent Access MVP's (Steve, Oli, Tony, Alex, George and the MSoft) once a week 

 

Click here for the Access content RSS Feed (It looks terrific in Internet Explorer 7 or Outlook 2007)


Thicktoast
Receive our monthly Web2 newsletter and find out about 37Signals and other sites we use

 

Allow this email address in your spam filters >>>

Unsubscribe using the link at the bottom of the newsletter 
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. 

Rename by unsubscribing and then joining with a new email address

Note:  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



Table Of Contents

Latest gossip and short tips in Garry's Blog  http://vb123.blogspot.com/

All the Access Unlimited News for Jan-April 2008

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 | Access 12 beta | Librarian Services at vb123

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 Toolshed | 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 | toolshed 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, Office Balloon and Access Links.

Newsletter 24   Getting on top of vb programming in excel | smart selection combo boxes for queries | Access Unlimited has a new name | win a copy of the toolshed (buddy bonus) | 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 | Access security - last editions winners of the toolshed | good reading and useful sites

Newsletter 22    Office XP - the Access upgrade mystery | vb.not - some thoughts | Access security - win a copy of the toolshed | 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

Newsletter 15    Simple Solutions To Protect from VB Script Viruses and Converting Excel Spreadsheets to (Access) Databases

Newsletter 14   Compact your screen dumps before emailing | tracking changes to records | Access security and passwords | vb6 ado add-in released 

Newsletter 13    Properties window | caching, xml, ado | mapping in Access | calendar and time picker | freestuff browser | changing external database properties 

Newsletter 12    The sunbaked calendar form - a must download | New features in Access 2000 | Access 2000 conversions - gotcha (plus decompile) | Alternate visual basic graph objects 

Newsletter 11    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 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 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 

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