Friday, May 9, 2008

Apple Keys

Apple Keys
original form
http://www.jacsoft.co.nz/Tech_Notes/Mac_Keys.htm

This list of special key combinations has been compiled for your information. I cannot always verify the information so if there is an error please let me know. I have not included special Finder keys or standard CMD-SHIFT-# shortcuts because Apple has done such a good job of documenting them in the Finder Help.
Apple Boot Key Combos:
Bypass startup drive and boot from external (or CD).... CMD-OPT-SHIFT-DELETE
Boot from CD (Most late model Apples) ................. C
Boot from a specific SCSI ID #.(#=SCSI ID number)...... CMD-OPT-SHIFT-DELETE-#
Zap PRAM .............................................. CMD-OPT-P-R
Disable Extensions .................................... SHIFT
Rebuild Desktop ....................................... CMD-OPT
Close finder windows.(hold just before finder starts).. OPT
Boot with Virtual Memory off........................... CMD
Trigger extension manager at boot-up................... SPACE
Force Quadra av machines to use TV as a monitor........ CMD-OPT-T-V
Boot from ROM (Mac Classic only)....................... CMD-OPT-X-O
Force PowerBooks to reset the screen................... R
Force an AV monitor to be recognized as one............ CMD-OPT-A-V
Eject Boot Floppy...................................... Hold Down Mouse Button
Select volume to start from............................ OPT
Start in Firewire drive mode........................... T
Startup in OSX if OS9 and OXS in boot partition........ X or CMD-X
Hold down until the 2nd chime, will boot into 9?....... CMD-OPT
OSX: Watch the status of the system load............... CMD-V
OSX: Enter single-user mode (shell-level mode)......... CMD-S

After startup:
Bring up dialogue for shutdown/sleep/restart........... POWER
Eject a Floppy Disk.................................... CMD-SHIFT-1 or(2) or (0)
Force current app to quit.............................. CMD-OPT-ESC
Unconditionally reboot................................. CTRL-CMD-POWER
Fast Shutdown.......................................... CTRL-CMD-OPT-POWER
Goto the debugger (if MacsBug is installed)............ CMD-POWER
Reset Power Manager on PowerBooks...................... USE THIS LINK
Put late model PowerBooks & Desktops to sleep.......... CMD-OPT-POWER

Application Specific Keys:
Startup key combos to reset the resolution on video boards:
SuperMac (at least some models)press&hold.............. OPT
Imagine 128 Card (reset resolution).................... N
RasterOps (at least some models)press&hold............. CMD-OPT-SHIFT
Radius (Use cable sense pins to set resolution)........ U
Radius (Cycle through available resolutions)........... T

Conflict Catcher:
Pause Boot........................................... P
Launch CC at Startup................................. SPACE or CAPS LOCK
Skip remaining extensions............................ CMD-PERIOD
Reboot cleanly while loading extensions.............. CMD-R

RAM Doubler:
Disable at Startup................................... ~ (Tilde) or ESC

Apple System Installer:
Change custom install to clean install............... CMD-Shift-K

Claris Emailer:
Bypass specified startup connections................. Hold CMD at launch
Bring up rebuild options............................. Hold OPT at launch

Controlling the Post-Startup Environment

Most Macintosh users know about holding the Shift key down to prevent extensions from loading, but there are numerous startup modifiers that affect the state of the system after the boot process finishes.

* Shift causes the Mac to boot without extensions, which is useful for troubleshooting extension conflicts. If you hold down Shift after all the extensions have loaded but before the Finder launches, it also prevents any startup items from launching.

* Spacebar launches Apple's Extensions Manager early in the startup process so you can enable or disable extensions before they load. Casady & Greene's Conflict Catcher, if you're using it instead of Extensions Manager, also launches if it sees you holding down the spacebar, or, optionally, if Caps Lock is activated. Conflict Catcher also adds the capability to configure additional startup keys as ways of specifying that a particular startup set should be used. Choose Edit Sets from the Sets menu, select a set in the resulting dialog and click Modify. In the sub-dialog that appears, you can specify a startup key and check the checkbox to make it effective.

* Option, if held down as the Finder launches, closes any previously open Finder windows. On stock older Macs, holding down Option does nothing at startup by default, although some extensions may deactivate if Option is held down when they attempt to load; see below for Option's effect on new Macs and Macs with Zip drives.

* Control can cause the Location Manager to prompt you to select a location. Although Control is the default, you can redefine it in the Location Manager's Preferences dialog, and since Control held down at startup also activates Apple's MacsBug debugger (see below), you may wish to pick a different key combination.

* Command turns virtual memory off until the next restart.

* Shift-Option disables extensions other than Connectix's RAM Doubler (and MacsBug - see below). To disable RAM Doubler but no other extensions, hold down the tilde (~) key at startup.



Choosing Startup Disks
Not surprisingly, many of the startup modifiers affect the disk used to boot the Mac. A number of these are specific to certain models of the Macintosh.

* The mouse button causes the Mac to eject floppy disks and most other forms of removable media, though not CD-ROMs.

* The C key forces the Mac to start up from a bootable CD-ROM, if one is present, which is useful if something goes wrong with your startup hard disk. This key doesn't work with some older Macs or clones that didn't use Apple CD-ROM drives; they require Command- Shift-Option-Delete instead (see below).

* Option activates the new Startup Manager on the iBook, Power Mac G4 (AGP Graphics), PowerBook (FireWire), and slot-loading iMacs. The Startup Manager displays a rather cryptic set of icons indicating available startup volumes, including any NetBoot volumes that are available. On some Macs with Iomega Zip drives, holding down Option at startup when there is a Zip startup disk inserted will cause the Mac to boot from the Zip disk.

* Command-Shift-Option-Delete bypasses the disk selected in the Startup Disk control panel in favor of an external device or from CD-ROM (on older Macs). This is also useful if your main hard disk is having problems and you need to start up from another device. (On some PowerBooks, however, this key combination merely ignores the internal drive, which isn't as useful.)

* The D key forces the PowerBook (Bronze Keyboard and FireWire) to boot from the internal hard disk.

* The T key forces the PowerBook (FireWire) (and reportedly the Power Mac G4 (AGP Graphics), though I was unable to verify that on my machine) to start up in FireWire Target Disk Mode, which is essentially the modern equivalent of SCSI Disk Mode and enables a PowerBook (FireWire) to act as a FireWire-accessible hard disk for another Macintosh.




Seriously Tweaky Startup Modifiers
Only programmers and the most geeky of users will find these startup modifiers useful.

* Control activates Apple's MacsBug debugger as soon as it loads. If you rely on this frequently, you may want to redefine the default key for selecting the Location Manager location at startup from Control to something else.

* Shift-Option disables extensions and virtual memory but still loads MacsBug, which would otherwise be disabled by the Shift key.

* Command-Option-O-F puts you into Open Firmware mode on PCI-based Macs and clones. Open Firmware is a cross-platform firmware standard for controlling hardware that all PCI-based Macs use. It's mostly of interest to hardware developers, but it can be a fun way to freak out a new user who's not expecting to see a command line on the Mac. To exit Open Firmware and continue booting, type "mac-boot" or "bye" (depending on Macintosh model) and press Return. For a list of commands you can enter while in Open Firmware mode, see the Tech Info Library article.



Just for Fun
Although Apple has moved away from relatively frivolous "Easter Eggs" connected with startup modifiers, there are a few available for old Macintosh models.

* Command-X-O, when held down at startup on a Macintosh Classic boots the Classic from a built-in ROM disk.

* Command-Option-C-I, when held down at startup on a Macintosh IIci whose date has been set to 20-Sep-89 (the machine's introduction date), produces some sort of graphical display that I can't check for lack of a relevant machine. A different display appears if you hold down Command-Option-F-X at startup on a Macintosh IIfx with the date set to 19-Mar-90.

Jim A. Creak
Last modified: 28 December 2003.


Locations of visitors to this page

Apple imaging

Copying MacBook images


Software to use

SuperDuper

free form
http://www.shirt-pocket.com/SuperDuper/SuperDuperDescription.html


copy the disk to the firewire external disk

use alt key to restart form the firewire disk

restore to the Macbook( or different one) back

Friday, December 8, 2006

Basics for Building Microsoft Office Access 2003 Runtime-Based Solutions


Basics for Building Microsoft Office Access 2003 Runtime-Based Solutions

Jan Fransen
Office Zealot.com

February 2004

Applies to:
Microsoft® Office Access 2003
Microsoft Office System

Summary: Jan Fransen reviews how to use the Microsoft Office Access 2003 Runtime with the Microsoft Access 2003 Developer Extensions so users without Microsoft Access 2003 installed can still use Access-based applications. (8 printed pages)

Contents

Introduction
Running in Runtime vs. Full Access 2003
Creating User Interface Objects
Setting Startup Options
Error Handling in VBA Code
Protecting Your Code with MDE Files
Streamlining the Distribution Process with the Access 2003 Developer Extensions Tools
Conclusion

Introduction

Legend has it that some developers of business applications work in environments where all the computers run the same—and latest—version of all software. Here in the real world, though, it is rather common for Microsoft® Office Access developers to create applications that must run on computers that do not have Microsoft Office Access 2003 installed, or are running older versions of Access. For those developers, Access 2003 Runtime is a necessity.

The Access 2003 Runtime license comes with the Microsoft Office Access 2003 Developer Extensions, which is a component of Microsoft Visual Studio® Tools for the Microsoft Office System. A developer who owns Visual Studio Tools for Office can bundle his application (MDB files and any other support files) with Access 2003 Runtime and distribute it to as many users as necessary. The physical runtime files are included with Microsoft Office 2003 Professional Edition or Microsoft Office Access 2003.

Running in Runtime vs. Full Access 2003

Access 2003 Runtime is, in essence, Microsoft Access 2003, but with a few key features disabled. A user with Access 2003 Runtime installed instead of full Access can open and run an Access application (either an MDB file or, with a few extra steps, a SQL Server back-end database) but does not see the Database Window and cannot switch the view of any Access object to Design view.

The following features are not included as part of Access 2003 Runtime without additional customization:

  • The Database window
  • Title bar text/icon (can be specified by the MDB instead of by Access)
  • Some menu items, such as Open and Save in the File menu, and the entire View, Format, and Tools menus
  • Shortcut menus
  • Built-in toolbars
  • Access Help
  • Designers (including Filter by Form)
  • VBA editor

Figure 1 shows two instances of the same minimal MDB application. The instance on the left is running using Access Runtime, and the instance on the right is running in full Access. Not only is the difference stark, but the Access Runtime instance does provide a direct UI for opening objects as the intent is for developers to create the UI for this purpose.

Figure 1. An Access Runtime instance of a sample application compared to a full Access instance of the same application

The developer of an application destined for an Access Runtime environment must create the application in such a way that the "missing" features of Access in the Access Runtime version are not obvious to the user. This document focuses on the steps the developer should take to create an Access application that runs just as effectively in an Access 2003 Runtime environment as it does with full Access installed.

Simulating the Access 2003 Runtime Environment from Full Access 2003

If you want to see how your application looks and works in an Access Runtime environment, you can use the /runtime command line switch with the full Access executable. Create a shortcut with a target like this:

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" /runtime "drive:\path\file_name"
Note The line above has wrapped for printing. No line wrapping is supported in command line switches.

Test your application under Access Runtime (either by using the command line switch or by installing with Access Runtime on a clean computer) before deploying the application to other users.

Creating User Interface Objects

At a bare minimum, every Access application destined for an Access Runtime environment must include a user interface object that allows navigation through the application. This object might be a main menu, but is more typically a replacement for the Database window—a form that allows the user to open the forms and reports that make up your application. You can use the Switchboard Manager (from the Tools menu, select Database Utilities and then choose Switchboard Manager) to create a standard switchboard, like the one shown in Figure 2, or you can create your own unbound or bound form to act as the main form for your application.

Figure 2. Access 2003 provides the Switchboard Manager to create a startup form for your application quickly

The limited menu provided by Access Runtime may be sufficient for simple applications, but most applications benefit from custom menus, toolbars, and shortcut menus. To create custom menus and toolbars, use the Customize dialog box (on the toolbar, choose Tools and then Customize) and select New on the Toolbars page of the dialog box. To create menu items or buttons, select and drag standard Access menu items onto your new menu or toolbar. You can also add menu items or buttons that call Access macros you created. By default, items created through the Customize dialog box are toolbars. You can change them to menus or shortcut menus by clicking the Properties button on the Toolbars page of the Customize dialog box.

If you create toolbars, menus, or shortcut menus that are specific to a certain form, you can use the Form properties Menu Bar, Toolbar, and Shortcut Menu Bar to specify the items you created. You can specify default toolbars, menus, and shortcut menus for all forms in the application in the Startup options discussed in the next section.

None of the standard Help for Access is available in Access Runtime. Often, a few well-written Help topics can head off a multitude of support calls and you can use a help authoring tool to create custom Help for your application. Once you have created the file, set the Help File property of each form to the name of your Help file. If your Help file includes topics for each form, you can also set the form's Help Context ID property so that the Help file opens directly to the most relevant page.

Setting Startup Options

Once you create the items that make up your application's user interface, you can cause most of them to load automatically at startup by using the Access Startup dialog box. Use these startup options whether you are working in Access Runtime or in full Access.

Open the Startup dialog box by selecting the Tools menu then choose Startup in full Access. The Startup dialog box is shown in Figure 3.

Figure 3. The Startup dialog box provides a way to set defaults for your MDB file

You can use the Startup dialog box to specify the following:

  • A title for the application. This title appears in place of Microsoft Access as the title in the application's window.
  • An icon for the application. The icon appears next to the window's title and in the Windows taskbar in place of the standard Access icon.
  • A form that opens automatically when the database is opened.
  • A default menu bar, toolbar, and shortcut menu for the application. You can override these settings for a particular form by changing the corresponding form properties.
  • Whether or not the Status Bar should be displayed on startup.

The following settings are ignored when the application runs Access Runtime and are relevant only when an application runs under full Access:

  • Whether or not the Database window should be displayed on startup.
  • Whether or not the default menus and toolbars should be allowed.
  • Whether or not the user can make changes.
  • Whether or not special keys are enabled in Access. In full Access, these special keys provide shortcuts to display certain windows and cause executing code to pause.

Once Startup properties are set, the application from Figure looks like Figure 4 at startup in Access Runtime.

Figure 4. The application now provides its own user interface when running in Access Runtime

Error Handling in VBA Code

When you run a VBA procedure in full Access and an error occurs, you see an error message like the one shown in Figure 5.

Figure 5. Access uses a default dialog box for unhandled VBA errors

From this message box, you can choose to debug the code in the Microsoft Visual Basic® Editor, or you can stop the code's execution and return to interactive Access.

The default error message for the same error under Access Runtime, shown in Figure 6, is quite different. Your only option is to click OK and subsequently exit the application entirely.

Figure 6. Access Runtime uses a different default dialog box for unhandled errors

Obviously, this is not the user interface you want to distribute to your users. It is always good programming practice to handle errors that may occur in VBA code, but when users work with the application in an Access Runtime environment, such error handling becomes crucial. Every procedure in an application should have, at a minimum, a basic On Error GoTo label error handler.

Access macros provide no structure for handling errors. Macros are useful for creating custom menu items and defining shortcut keys, but because they lack error handling, use them only sparingly in any application.

Protecting Your Code with MDE Files

It is important to remember that although an application looks different in Access Runtime, the MDB file itself is the same regardless of the environment under which it is running. With its hidden Database window and designers, developers are sometimes tempted to think that Access Runtime provides security for the application. It does not. Any user who has full Access installed can open the database, just as the developer can, and change the design of objects or code. If your application requires user-level security, you must implement it with the Security tools supplied as part of Access on the Tools menu, in the Security dialog box.

Access provides a database format that adds a measure of security to the design elements of your application: the form and report designs and code, and the code in VBA modules. This tool is the MDE file.

You can create an MDE file from an MDB file by choosing Tools and then Database Utilities and Make MDE File from the Access toolbar. When you make an MDE file, Access compiles all the code in the database and strips the editable version of the code from the new MDE file. This process both decreases the size of the resulting database and guarantees that no one can change the original source code. When you open an MDE file in Access, the form and report designers and the Visual Basic Editor are not available. In addition, you cannot transfer forms, reports, and modules to another database by export or import.

Note To create an MDE file, the original MDB must be in Access 2002-2003 file format. MDE and ADE files are not backward-compatible. Therefore, you can only open them in the version of Access in which they were created or a later version.

Streamlining the Distribution Process with the Access 2003 Developer Extensions Tools

In addition to the Access 2003 Runtime license, the Access 2003 Developer Extensions include two wizards to streamline the process of packing and distributing Access applications. These wizards are the Custom Startup Wizard and the Package Wizard.

Using the Custom Startup Wizard

The Access Startup dialog box allows you to set several useful restrictions on users of the application, such as disallowing standard menus and certain shortcut keys. However, developers do not usually wish to place such restrictions on themselves. Therefore, in the iterative process of application development, you can switch the startup options many times. You work with the application with one set of startup options, add more restrictions while preparing the application for user testing or deployment, and remove the restrictions again when changes to the application are required.

The Custom Startup Wizard, new in the Access 2003 Developer Extensions, simplifies the process of converting the development version of an application to an end-user version. The wizard asks questions about what the final version should look like and uses the answers to create a database with the appropriate settings. In addition, you can save all the choices made to a template. When you make changes to the original application and require a new deployed version, you can create it by using the wizard's command line interface and specifying the template as a command line argument.

Among the changes the wizard can make are these:

  • Make the final version an MDE.
  • Prevent the Properties dialog box from appearing in Form view.
  • Copy a selected macro to the Autokeys macro, providing shortcut keys for the end user that the developer does not want in his own version.
  • Set startup options that differ from the original database.
  • Disallow the Bypass (SHIFT) key so that users cannot avoid the startup options by holding down the SHIFT key while opening the database file.
  • Digitally sign the database.
  • Check the database for problems such as code that is not compatible with Access 2002, expressions that are blocked in Sandbox mode and missing references.

Using the Package Wizard

In some situations, distributing an Access application is as simple as copying the MDB or MDE file to the user's drive and fixing any data links to point to the appropriate source. However, for applications that include other non-Access files such as Microsoft ActiveX® controls and icons, or applications that you distribute with Access 2003 Runtime, you want a more robust and professional setup routine. The Package Wizard provides an easy way to create a Microsoft Windows® Installer (.msi) setup file that guides the user step-by-step through installation.

Because the Package Wizard's output is based on Windows Installer technology, the solutions that the Package wizard creates are importable by a wide variety of third-party tools, such as Installshield Developer and Wise for Windows Installer. You can use the Package Wizard to prepare the Access portion of a larger application and integrate the result into a package created with another third-party tool.

The Package Wizard provides options that allow you to:

  • Include Access 2003 Runtime as part of the installation.
  • Supply a title for the installation.
  • Provide a name for the destination folder.
  • Choose a language for the installation (you need a CD or folder that contains Access in the language you want to use for this feature).
  • Specify support files such as icons, a Help file, a Workgroup file, an End User License Agreement (EULA) in Rich Text Format, or any other files necessary for your application to run properly.
  • Add information for the msi file's Properties.
  • Specify parameters for a shortcut file created for your solution.

Similar to the Custom Startup Wizard, the Package Wizard allows you to save all choices as a template. The Package Wizard also provides a command line interface that supports a template name as an argument.

Conclusion

If you are creating an application that runs in an Access Runtime environment, you must carefully consider how to provide an interface for the user. You must also consider the fact that some users may own the correct version of Access and run the application in a full Access environment. Take care to test your application under both environments to make sure it properly balances usability in the Access Runtime environment with code security in a full Access environment.

Once you created and tested your application, you can use the wizards in the Access 2003 Developer Extensions to create a final version that you can deploy to end users. It is a good idea to save the settings of both wizards as templates. You can then create a batch file that calls the command line interface of each wizard, sending the names of the respective template files. The next time you change the application and must create a deployment package, the process is as simple as running a single batch file.

About the Author

Jan Fransen, based in Minneapolis, MN, spends her days helping people find ways to use Microsoft Office to do their jobs better. As a consultant, she creates applications in Microsoft Visual Basic for Applications (VBA), Visual Basic 6.0, and Visual Basic .NET. As a trainer and writer, she teaches people both interactive Office tricks and VBA programming.

Targeter And Ms Access 2003 problems

I found some information but not answers for the poblem

first one form goolge grups form the following link - I have highlighted with red some parts.

http://groups.google.co.uk/group/microsoft.public.access.devtoolkits/browse_thread/thread/e45306c6768b9fe5/897c8f0bc48c9a69?lnk=st&q=access++2000+runtime+office+2003+problems&rnum=12&hl=en#897c8f0bc48c9a69

Topic in microsoft.public.access.devtoolkits - view in Groups BetaNew!


Start a new topic - Subscribe to this group - About group Messages 1 - 2 of 2

Fixed font - Proportional font
[Click the star to watch this topic] 2000 Access Runtime running in an Access 2003 Environment
All 2 messages in topic - view as tree

From: Cyndy Sheehan - view profile
Date: Wed 11 May 2005 22:19
Email: "Cyndy Sheehan"
Groups: microsoft.public.access.devtoolkits
Not yet rated
Rating:
show options
Reply | Reply to Author | Forward | Print | Individual Message | Show original | Report Abuse | Find messages by this author

I would like to be able to install a 2000 Access Runtime on a XP computer
that is running the Office 2003 including Access 2003 or Office 2002
including Access 2002. I searched to see if there have been any problems
reported with this type of installation, and from what I have seen, no one
is reporting any. Does any one know of a reason why this will not install
or work or of any problems relating to this installation? I would rather
have a 2003 Runtime installation, but the Packaging Wizard for the 2003 is
being very uncooperative in allowing you to add features like the compact
option which runs under a runtime or to be able to run a batch after the
installation or even change the default directory. I am trying to
successfully package the application for a 2003 environment, but until I
can, I need to release as a 2000 Runtime. Any help on this would
appreciated. Thanks

Reply


From: Paul Overway - view profile
Date: Wed 11 May 2005 23:13
Email: "Paul Overway"
Groups: microsoft.public.access.devtoolkits
Not yet rated
Rating:
show options
Reply | Reply to Author | Forward | Print | Individual Message | Show original | Report Abuse | Find messages by this author

You'll have co-existence issues, i.e., file associations will change to
whichever version was opened last. If they have retail 2003 and get stuck
with your 2000 runtime, users may not be too happy with you.

Really, if you are distributing a 2000 format database and the target system
already has a compatible version of Access, there is no reason for you to
install the runtime. Just use the installed version. There is a white
paper at site below with sample scripts for finding installed version of
Access and creating shortcuts....see Tools/Add-Ins/Extras.

--
Paul Overway
Logico Solutions
http://www.logico-solutions.com

"Cyndy Sheehan" wrote in message

news:Ox8waenVFHA.3432@TK2MSFTNGP10.phx.gbl...

- Hide quoted text -
- Show quoted text -
>I would like to be able to install a 2000 Access Runtime on a XP computer
>that is running the Office 2003 including Access 2003 or Office 2002
>including Access 2002. I searched to see if there have been any problems
>reported with this type of installation, and from what I have seen, no one
>is reporting any. Does any one know of a reason why this will not install
>or work or of any problems relating to this installation? I would rather
>have a 2003 Runtime installation, but the Packaging Wizard for the 2003 is
>being very uncooperative in allowing you to add features like the compact
>option which runs under a runtime or to be able to run a batch after the
>installation or even change the default directory. I am trying to
>successfully package the application for a 2003 environment, but until I
>can, I need to release as a 2000 Runtime. Any help on this would
>appreciated. Thanks

Reply