Signup or leave newsletter   |   Contact Us   |   Need programming help?

Hello Access and Office Professionals and anyone else who wants to listen

Should We Develop In Access 2010 ?

A question that I get asked occasionally by my developers is "Shall we develop for the client in Access 2010 even though they are using Access 2007?" The short answer is technically you could but the longer answer is you should develop in the system that the client is using. Remember the client is king and you need to experience what they are experiencing. Should that stop you using Access 2010, absolutely not. As a developer you need to be one step ahead of your client base. What I recommend you do is use Access 2010 for your internal systems like billing and customer details. That leaves you with wondering how to switch between 2010 and 2007. We use the workbench for this and a version to do this is in early test mode now. Email me if you want to try the early release using access at gr-fx dot com.

Enjoy the Newsletter.


Garry Robinson
Microsoft Access MVP

Products

SQL Upsizer

Workbench

Smart Access

FMS Products

Can we help?

	--- 7/10/2010  ------------------------------------------------------------------------------------------
	Data Macros in Access 2010
	Over at Database Journal, Danny Lesandrini writes a practical introduction in Access 2010 data macros. This covers "the AfterUpdate event of the table and figuring out how to debug the macro."
	--- 20/09/2010  ------------------------------------------------------------------------------------------
	I've Got Plenty of Nothing
	Doug Steele starts by looking at a technique for finding unused fields in tables
	--- 7/09/2010  ------------------------------------------------------------------------------------------
	Handling Price Ranges in Microsoft Access
	Rebecca Riordan provides two methods for handling the common case of multiple prices for a given product, depending on the quantity ordered–the customer pays $1.79 each for buying up to nine items, but only $1.69 each when buying 10-14 items, and so on.
	--- 20/01/2009  ------------------------------------------------------------------------------------------
	# VB123 is a Reseller of FMS Total Access Tools #
	Purchase FMS Software from us and you will find yourself with the latest version of our software for almost nothing. If you head to our FMS page, you will find the option to read about and purchase FMS Visual Code Tools, Total Access Analyzer, Total Access Emailer and Total Access Detective. Also if you purchase FMS Software, you can qualify for free copies of our popular Access Workbench or Toolbox Resource kit.
	--- 2/09/2010  ------------------------------------------------------------------------------------------
	Embedded quotes in SQL statements - DAO Code
	Adrian Murphy pointed out to Doug Steele that Parameter queries are another approach to solving the problem of having embedded quotes in the values being used in SQL statements. He sent along the following code sample:
	--- 12/09/2010  ------------------------------------------------------------------------------------------
	Advanced Data Shaping - Using Hierarchial Recordsets
	Mike Gunderloy provides some examples of ADO's SHAPE_APPEND statement in action, including how to synchronize child and parent Recordsets. Mike also introduces the SHAPE_COMPUTE statement.
	--- 17/08/2010  ------------------------------------------------------------------------------------------
	Doug Steele shows how to simulate Cue Banners in Access
	Internet controls such as search boxes have something called "cue prompting" that can help indicate what the user should be entering. Is there some way I can still do something like this?
	--- 8/08/2010  ------------------------------------------------------------------------------------------
	Creating Paired Listbox Controls, Part 2
	Rebecca Riordan continues her examination of paired Listbox controls by adding two additional functions: deferring data updates until users explicitly commit their changes, and restoring the contents of the paired Listbox controls to their initial state.
	--- 18/08/2009  ------------------------------------------------------------------------------------------
	# Convert Access to SQL Server #
	Upsize to SQL Server 2005 or 2008, easily repeated conversions, highly accurate SQL query translation and web form conversion. MUST now supports Access 2010.
	--- 19/07/2010  ------------------------------------------------------------------------------------------
	PivotTables in Access
	Russell Sinclair shows how to summarize data using PivotTables
	--- 16/07/2010  ------------------------------------------------------------------------------------------
	An Access E-mail Application
	Adding an e-mail facility to your Access application is a convenient way to communicate critical data to multiple users, while at the same time producing a trail linked to key records in your database. Keith Bombard shows you how.
	--- 16/07/2010  ------------------------------------------------------------------------------------------
	From Zoom Box to Custom Dialog
	For some applications you just can't get enough screen real-estate, especially when you have fields that display a large amount of text. Mike Toole describes an alternative to the Zoom box that not only looks and works better but avoids the Zoom box's spurious updates. His design can be used for creating any sophisticated custom dialog.
	--- 19/05/2009  ------------------------------------------------------------------------------------------
	# The Access Workbench #
	Find out who has your database open, start the correct version of Access, easy compacting and backups, change startup options, create version zip files, shutdown database all in a simple interface. We use this program a lot.
	--- 15/07/2010  ------------------------------------------------------------------------------------------
	Manage your Update Tables with Query Lists
	In this article, Keith Bombard shows off a routine that can reduce the time it takes to create a form to manage your update tables. This general-purpose routine can be used with any small table for editing, updating, adding, and deleting records.
	--- 10/07/2010  ------------------------------------------------------------------------------------------
	Making the grade
	Doug Steele looks at a common problem in database design: converting from one data classification schema to another. He then moves on to a related question: ensuring that there are no overlapping records in a list of ranges (for example, a list of scheduled events). This results in some thorny SQL, but the results can be used in a wide variety of circumstances.
	--- 8/07/2010  ------------------------------------------------------------------------------------------
	Transfer All Tables from One Database To Another
	This page is updated to show how I transferred from a database to another database (It was actually a SQL back to an Access ACCDB format) using a third database that was linked to both. There was no relationships in the target database so order of transfer wasn't important. Code is at the bottom of the page.
	--- 30/09/2008  ------------------------------------------------------------------------------------------
	# Access Protection and Security Book #
	If you are still using Access 2000, 2002, 2003 or even Access 97, have you considered my book on Access security. Read the 15 5 star reviews at Amazon.

To sign up for Access Unlimited, send a blank email to tips [at] vb123.com.

To subscribe to our RSS feed, head to http://www.vb123.com/news/

To unsubscribe, send an email to notips [ at ] gr-fx.com