|
 |
access thread: New Programmability Enhancements with Access 2002
Message #1 by "Bob Bedell" <bobbedell15@m...> on Wed, 23 Oct 2002 15:37:56
|
|
FYI to all who are interested. This is a list of the new programmability
enhancements with Access 2002 (Source: Roger Jennings)
1. New Events for Forms, Controls and Batch Updates:
On Undo
On Mouse Wheel
2. New Properties and the Printers Collection
Application.Printers
{Form}.Printer
{Report}.Printer
{Control}.Recordset
{Report}.Recordset
{Report}.Shape
3. New Application, Project and Access Object Properties
Application.Build
Application.BrokenReference
CurrentProject.FileFormat
{AccessObject}.DateCreated
{AccessObject}.DateModified
4. New Control and Form Methods
{Control}.AddItem
{Control}.RemoveItem
{Control}.Move
{Form}.Move
5. New and Updated Application Methods
Application.CompactRepair
Application.ConvertAccessProject
Application.CreateNewWorkgroupFile
Application.ExportXML
Application.ImportXML
Application.FileDialog
Application.OpenCurrentDatabase
Application.SetDefaultWorkgroupFile
6. VBA 6.0 Functions Now Supported in Access 2002
FormatCurrency
FormatDateTime
FormatNumber
FormatPercent
InstrRev
MonthName
Replace
StrReverse
WeekdayName
So far I give Application.FileDialog the coolest new feature
award. It opens the File Open or File Save As dialogs with ease,
eliminating the need for the Common Dialog ActiveX control or messy API
calls.
Best,
Bob
Message #2 by "John Ruff" <papparuff@c...> on Wed, 23 Oct 2002 07:46:34 -0700
|
|
Thanks Bob, but to All - Remember. If you are developing with XP
(Access 2002) for a client who is using Access2K or Access97, these new
features will cause the application to fail if you incorporate them in
the program.
John V. Ruff - The Eternal Optimist :-)
Always Looking For Contract Opportunities
www.noclassroom.com
Live software training
Right over the Internet
Home: xxx.xxx.xxxx
Cell: xxx.xxx.xxxx
9306 Farwest Dr SW
Lakewood, WA 98498
-----Original Message-----
From: Bob Bedell [mailto:bobbedell15@m...]
Sent: Wednesday, October 23, 2002 3:38 PM
To: Access
Subject: [access] New Programmability Enhancements with Access 2002
FYI to all who are interested. This is a list of the new programmability
enhancements with Access 2002 (Source: Roger Jennings)
1. New Events for Forms, Controls and Batch Updates:
On Undo
On Mouse Wheel
2. New Properties and the Printers Collection
Application.Printers
{Form}.Printer
{Report}.Printer
{Control}.Recordset
{Report}.Recordset
{Report}.Shape
3. New Application, Project and Access Object Properties
Application.Build
Application.BrokenReference
CurrentProject.FileFormat
{AccessObject}.DateCreated
{AccessObject}.DateModified
4. New Control and Form Methods
{Control}.AddItem
{Control}.RemoveItem
{Control}.Move
{Form}.Move
5. New and Updated Application Methods
Application.CompactRepair
Application.ConvertAccessProject Application.CreateNewWorkgroupFile
Application.ExportXML
Application.ImportXML
Application.FileDialog
Application.OpenCurrentDatabase Application.SetDefaultWorkgroupFile
6. VBA 6.0 Functions Now Supported in Access 2002
FormatCurrency
FormatDateTime
FormatNumber
FormatPercent
InstrRev
MonthName
Replace
StrReverse
WeekdayName
So far I give Application.FileDialog the coolest new feature
award. It opens the File Open or File Save As dialogs with ease,
eliminating the need for the Common Dialog ActiveX control or messy API
calls.
Best,
Bob
Message #3 by Beth Moffitt <BethMoffitt@i...> on Wed, 23 Oct 2002 10:42:01 -0500
|
|
Unless you first check for the version they are running, and then run the
applicable code :)
Regards,
Beth
-----Original Message-----
From: John Ruff [mailto:papparuff@c...]
Sent: Wednesday, October 23, 2002 9:47 AM
To: Access
Subject: [access] RE: New Programmability Enhancements with Access 2002
Thanks Bob, but to All - Remember. If you are developing with XP
(Access 2002) for a client who is using Access2K or Access97, these new
features will cause the application to fail if you incorporate them in
the program.
John V. Ruff - The Eternal Optimist :-)
Always Looking For Contract Opportunities
www.noclassroom.com
Live software training
Right over the Internet
Home: xxx.xxx.xxxx
Cell: xxx.xxx.xxxx
9306 Farwest Dr SW
Lakewood, WA 98498
-----Original Message-----
From: Bob Bedell [mailto:bobbedell15@m...]
Sent: Wednesday, October 23, 2002 3:38 PM
To: Access
Subject: [access] New Programmability Enhancements with Access 2002
FYI to all who are interested. This is a list of the new programmability
enhancements with Access 2002 (Source: Roger Jennings)
1. New Events for Forms, Controls and Batch Updates:
On Undo
On Mouse Wheel
2. New Properties and the Printers Collection
Application.Printers
{Form}.Printer
{Report}.Printer
{Control}.Recordset
{Report}.Recordset
{Report}.Shape
3. New Application, Project and Access Object Properties
Application.Build
Application.BrokenReference
CurrentProject.FileFormat
{AccessObject}.DateCreated
{AccessObject}.DateModified
4. New Control and Form Methods
{Control}.AddItem
{Control}.RemoveItem
{Control}.Move
{Form}.Move
5. New and Updated Application Methods
Application.CompactRepair
Application.ConvertAccessProject Application.CreateNewWorkgroupFile
Application.ExportXML
Application.ImportXML
Application.FileDialog
Application.OpenCurrentDatabase Application.SetDefaultWorkgroupFile
6. VBA 6.0 Functions Now Supported in Access 2002
FormatCurrency
FormatDateTime
FormatNumber
FormatPercent
InstrRev
MonthName
Replace
StrReverse
WeekdayName
So far I give Application.FileDialog the coolest new feature
award. It opens the File Open or File Save As dialogs with ease,
eliminating the need for the Common Dialog ActiveX control or messy API
calls.
Best,
Bob
|
|
|
View Cart
