The conversion of my department's 12 machines has gone really well and
I have had no big problems with any of it. Now for another question --
Are there any new "goodies" in Access 2003 that are really helpful.
And I guess that I could say in 2002 as well as I started with 2000 2 1836
For reports, the Printer object, and OpenArgs for OpenReport.
2003 also offers you the ability to trace dependencies. But because this
requires Name AutoCorrect to be turned on, I've not found that usable.
The themed controls look pretty on Windows XP, but have problems such as tab
controls that don't respect their Transparent property, check boxes that
don't visually distinguish 3 states, and the flickering described in this
article: http://allenbrowne.com/ser-46.html
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Deb" <ko*****@swbell.net> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com... The conversion of my department's 12 machines has gone really well and I have had no big problems with any of it. Now for another question --
Are there any new "goodies" in Access 2003 that are really helpful. And I guess that I could say in 2002 as well as I started with 2000
Here is a re-post of some new featuers: Also, here is a fabulous post by MVP John Viescas on this very subject late last year. Incidentally, he has a book out on Access 2003 so he really knows what he is talking about. (This was comparing Access 2003 to 2002).
Here it is:
They didn't make any major changes. Here's a summary:
View information on object dependencies
In Microsoft Office Access 2003, you can view information on dependencies between database objects. Viewing a list of objects that use a specific object helps maintain a database over time and avoid errors related to missing record sources. For example, the Quarterly Orders query in the Sales database is no longer needed, but before deleting it, you might want to find out which other objects in the database use the query. Then, you could either change the record source of the dependent objects, or delete them, before deleting the Quarterly Orders query. Viewing a complete list of dependent objects helps you save time and minimize errors.
In addition to viewing the list of objects that are bound to a selected object, you can also view the objects that are being used by the selected object.
Macros, modules, and data access pages are not searched for dependencies. Access projects do not support this feature.
Error checking in forms and reports
In Microsoft Office Access 2003, you can enable automatic error checking for common errors in forms and reports. Error checking points out errors, such as two controls using the same keyboard shortcut, and the width of a report being greater than the page it will be printed on. Enabling error checking helps you identify errors and correct them.
Propagating field properties
In previous versions of Microsoft Access, whenever you modified a field's inherited property, you had to manually modify the property of the corresponding control in each of the forms and reports. Now, when you modify an inherited field property in Table design view, Access displays an option to update the property of all or some controls that are bound to the field.
Smart tags
In Microsoft Office Access 2003, you can use the SmartTags property to add a smart tag to any field in a table, query, form, report, or data access page in a database.
Back up a database or project
You can back up the current database or project before making major changes to it. The backup will be saved in the default backup location, or in the current folder.
To restore a database, go to the location of the backup, rename the file, and open it in Access.
Windows XP theme support
The Microsoft Windows XP operating system offers you several themes. If you have chosen a theme other than the default, Access will apply the chosen theme to views, dialog boxes, and controls. You can prevent form controls from inheriting themes from the operating system by setting an option on the database or project.
Improved sorting in controls
You can now specify the ascending or descending sort order of up to four fields in the List Box and Combo Box Wizards in forms and reports, and the Lookup Wizard in an Access database. The sort page added to these wizards looks and behaves like the sort page in the Report Wizard.
Autocorrect options
In Microsoft Office Access 2003, you have more control over the behavior of the AutoCorrect feature. The AutoCorrect Options button appears near text that was automatically corrected. If you find on occasion that you don't want text to be corrected, you can undo a correction or turn AutoCorrect options on or off by clicking the button and making a selection.
Enhanced font capabilities in SQL views
In the SQL and query Design views of a query in both a Microsoft Access database and Microsoft Access project, you can now change the font and font size of the text by using the Query design font option added to the Tables/Queries tab of the Options dialog box under the Tools menu. These settings apply to all databases and work with the high-contrast and other accessibility settings of your computer.
Context-based Help in SQL view
In the SQL view of a query in a Microsoft Access database, you can now get help specific to Jet SQL keywords, VBA functions, and Access functions. Simply press F1 to bring up the help that corresponds to the text near the cursor. You can also search the Jet SQL and VBA function reference topics.
Importing, exporting, and linking
Importing, exporting, and linking to a Microsoft Windows SharePoint Services list from Access
You can perform the following operations with a Windows SharePoint Services list:
?Export the contents of a table or a query to a list.
?Import the contents of a list into a table.
?Link a table to a list.
Exporting and linking to Access data from Windows SharePoint Services
You can now export a list in its Datasheet view from Windows SharePoint Services to a static table or to a linked table in Access. When you export to a static table, you create a table in Access. You can then view and make changes to the table independent of the original list in Windows SharePoint Services. Similarly, you can change the list in Windows SharePoint Services, and that will not affect the table in Access.
When you export to a linked table, you create a table in Access and establish a dynamic link between the table and the list such that changes to the table are reflected in the list, and changes to the list are reflected in the table as well.
Make a local table from a linked table
In Microsoft Office Access 2003, you can make a local copy of the structure or data and structure contained in a linked table.
XML support
With the enhanced XML support in Microsoft Office Access 2003, you can specify a transform file when you import data from or export data to XML. The transform is then applied automatically. When you import XML data, the transform is applied to the data as soon as the data is imported, before any new table is created or an existing one is appended to. When you export data to XML, the transform is applied following the export operation.
Often times a database contains lookup values that are stored in another database. You can now include these related tables when exporting. You can also include any predefined filter or sort order for an object when exporting the object.
Security enhancements
Macro Security Microsoft Office Access 2003 allows you to protect against potentially unsafe Visual Basic for Applications (VBA) code by setting the macro security level. You can set the security level so that you are prompted every time that you open a database containing VBA code, or you can automatically block databases that are from unknown sources.
Additionally, Access uses Microsoft Authenticode technology to enable you to digitally sign a macro project by using a digital certificate. The certificate used to create this signature confirms that the macro originated from the signer, and the signature confirms that it has not been altered. When you set the macro security level, you can run macros based on whether they are digitally signed by a developer on your list of trusted sources.
Block Potentially Unsafe Functions Access utilizes the Microsoft Jet Expression Service enhanced sandbox mode to block potentially unsafe functions from being used in expressions.
------ The last one is a real pain. You need to install JET SP8 from Windows Update (not included with Office 2003) to get this to work properly. I suspect most folks will change their macro security setting to Low to avoid the security prompts.
HTH...
Post a follow-up to this message
--------------------------------------------------------------------------------
Google Home - Advertising Programs - Business Solutions - About Google
©2004 Google This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: David N |
last post by:
In VS.NET 1.0, you can add a folder under your project (right click on the
project, choose Add/New Folder). I found this option so helpful, because
it helps me to organize my files, especially...
|
by: Tom Lee |
last post by:
Hi,
I'm new to .NET 2003 compiler. When I tried to compile my
program using DEBUG mode, I got the following errors in the
C:\Program Files\Microsoft Visual Studio .NET 2003\Vc7
\include\xdebug...
|
by: EP |
last post by:
When running my asp.net hosting service (asp.net without IIS), on server
2003 with IIS not installed, I get the following when trying to process a
request.
"System.DllNotFoundException: Unable to...
|
by: gerryLowry::Ability Business Computer Services {KC |
last post by:
"Getting Back Your Visual Basic 6.0 Goodies" by Billy Hollis, 2003-5-14,
states:
"Getting a Forms Collection
Visual Basic 6.0 developers are often fond of looping through the currently
loaded...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
| |