Question about Microsoft Office Standard for PC

1 Answer

How to activate command buttons

Hello, I added 5 different command buttons to my form with the wizard. I followed all the steps (ie. gave the buttons names and commands such as print record, add record, delete record and so on). However only 2 out of the 5 function properly and carry out the commands (delete and print commands). When I click on the others, a dialogue box pops up and says " You can't go to the specified record" I'm not sure why the others are not working. Can you let me know how I can get the add record command to work? Many Thanks! signed Access beginner

Posted by Lensa on

  • jiggadel Dec 04, 2008

    i am not seeing any instructions to follow when i insert an action button in ms access 2007

×

Ad

1 Answer

Anonymous

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that has over 10 points.

    Mayor:

    An expert whose answer got voted for 2 times.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 9 Answers

Not w/o you sharing how you did it step by step. Can you add some screenshots of the steps you tok to get there? In general "add record" should jump to another form that allows you to enter your data for the new record and "save" it.

Posted on Aug 15, 2007

  • Anonymous Aug 15, 2007

    Found this expertly mention of the type of error you are getting on MS-Access website.
    ---
    SYMPTOMS
    Advanced: Requires expert coding, interoperability, and multiuser skills.

    When you perform an action in the BeforeUpdate event, you receive the following error messages, even if you have canceled the event.

    In Microsoft Access 7.0 and 97:

    - Runtime error '2105'
    You can't go to the specified record


    - Runtime error '2115'
    The macro or function set to the BeforeUpdate or ValidationRule property for this field is preventing Microsoft Access from saving the data in the field.

    In Microsoft Access 2.0:

    - Field or record can't be saved while it's being validated.


    - Command not available: UndoCurrentRecord.


    - Can't go to specified record.
    CAUSE
    Microsoft Access cannot perform the specified command because the BeforeUpdate event procedure is still running. This is true even if the Cancel parameter is set to True or if a CancelEvent macro attempts to cancel the action.

    These error messages are generated by the following statements in the BeforeUpdate event procedure:

    ' Undo the current record. (Microsoft Access 2.0 only)

    ' NOTE: This behavior no longer occurs in Microsoft Access 7.0 and 97)

    DoCmd DoMenuItem A_FORMBAR, A_EDITMENU, 1

    ' Goto a new record.
    DoCmd.GoToRecord , , acNewRec '(Microsoft Access 7.0 and 97)
    DoCmd GoToRecord , , A_NEWREC '(Microsoft Access 2.0 )

    ' Find a record
    DoCmd.FindRecord "Smith", , True, acAll, True '(Microsoft Access 7.0 and 97)
    DoCmd FindRecord "Smith", , True, A_ALL, True '(Microsoft Access 2.0)
    RESOLUTION
    Instead of setting the Cancel parameter to True, or using the CancelEvent action, use a SendKeys statement if that is an option with the command you are trying to use. The SendKeys statement sends keystrokes to the Microsoft Access buffer, where they wait until the BeforeUpdate event procedure is finished.
    ---
    Not sure if it helps you as an Access beginner.

×

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

3 Answers

I want factory setting keys


To access System Restore via Safe Mode, follow these steps:
  1. Start the PC
  2. Press and hold the F8 key before the Windows Vista logo appears on your monitor
  3. At the Advanced Boot Options, select Safe mode with Command Promp


26085599-qw2ileno352me4xhttjvbrdq-5-5.png
4. Press Enter
5. When Command Prompt is available, type the following command:
  1. rstrui.exe
6. Press Enter
7. Enter the password for the Administrator and press Enter, if prompted to do so.
8. Follow the wizard instructions to choose a restore point

Feb 07, 2016 | Computers & Internet

1 Answer

Change the display name?


Administering a 1400 Series Digital Deskphone
Perform the following steps for each 1400 Series Digital Deskphone:
1. Log into the Avaya Aura Communication Manager administration interface.
2. Perform one of the following steps:
? If you are adding a new extension and want to assign a specific extension number, use
the add station nnnn command, where nnnn is the new extension you want to assign.
? If you are adding a new extension and want to assign the next available extension
number, use the add station next command.
? If you are installing the 1400 Series Digital Deskphone at an existing extension, use the
change station nnnn command, where nnnn is the existing extension you want to
modify.
The Station screen appears.
3. Perform one of the following steps:
? If you are administering a 1408 telephone, type 2410 in the Type field.
? If you are administering a 1416 telephone, type 2420 in the Type field.
4. In the Port field, type the port address.
5. In the Name field, type the name to associate with this telephone. Administering 1400 Series Digital Deskphones
20 Avaya 1400 Series Digital Deskphones Installation and Maintenance Guide
6. Configure the remaining fields on the Station screen pages. Keep in mind the following
information:
? If you are administering a 1408 telephone, the first eight call appearance/feature buttons
displayed on the Station screen are administered on the 1408 telephone. (Since the 1408
telephone is aliased as a 2410 telephone, the Station screen displays 10 call
appearance/feature buttons.) The remaining buttons displayed on the Station screen are
not administered.
? If you are administering a 1416 telephone, the first 16 call appearance/feature buttons
displayed on the Station screen are administered on the 1416 telephone. (Since the 1416
telephone is aliased as a 2420 telephone, the Station screen displays 20 call
appearance/feature buttons.) The remaining buttons displayed on the Station screen are
not administered.
? If you are administering a 1416 telephone with a DBM32 Button module, the first 16 call
appearance/feature buttons displayed on the Station screen are administered on the
1416 telephone. The remaining eight call appearance/feature buttons displayed on the
Station screen are administered on the first eight buttons of the DBM32 Button module.
The 24 buttons of the EU24 expansion module displayed on the Station screen are
administered for the remaining 24 buttons of the DBM32 Button module.
For more information about administration and features, see:
- Administering Avaya Aura™ Communication Manager, Document Number 03-300509
- Avaya Aura™ Communication Manager Feature Description and Implementation,
Document Number 555-245-205
- Avaya Aura™ Communication Manager Screen Reference, Document Number
03-602878
7. When finished administering this extension, save your changes.

Online Virus Removal 39 99 Online Virus Removal and Online PC Help

Dec 19, 2014 | Avaya Ip Office 1416 Digital Deskphone -...

1 Answer

Hello when i am opening device manager its not opening showing some error mmc console error


Hi Welcome to FixYa!
You could try different steps below on how to fix this problem.
1)You could download an automatic fix from Microsoft with this link: http://go.microsoft.com/?linkid=9657414
Then click Run in the File Download dialog box, and follow the steps in this wizard.
2) This issue may occur when one or more of the .dll files that are used by the Microsoft Management Console (MMC) are missing or corrupted. These files include the following:
  • Msxml.dll
  • Msxml2.dll
  • Msxml3.dll
To resolve this issue, follow these steps:
  1. Click Start, click Run, type cmd, and then click OK.
  2. At the command prompt, type cd %windir%\system32, and then press ENTER.

    Note The %Windir% folder is the folder where you installed Microsoft Windows.
  3. Type the following commands. Press ENTER after each command. Regsvr32 Msxml.dll Regsvr32 Msxml2.dll Regsvr32 Msxml3.dll
  4. Type exit, and then press ENTER to close the Command Prompt window.
  5. Restart the computer.
Hope this would be a big help!

Jun 22, 2011 | Computers & Internet

1 Answer

Black screen with white arrow


Step 1: Opening a command promptThis error prevents Windows XP from opening. This problem has to be addressed from a command prompt environment. Use the following steps to open a command prompt environment:
  1. Turn on the PC and press the F8 key repeatedly when the first screen appears.The Windows advanced options menu appears.
  2. Use the Up and Down Arrow and Enter keys to select Return to OS choices .
  3. Select Microsoft Windows Recovery Console .
    NOTE: If "Microsoft Windows XP Recovery Console" is not listed, restart the PC with a Windows XP CD, Recovery Console CD, or Recovery Tools CD in the top CD or DVD drive and open Microsoft Windows Recovery Console. If a Windows XP Setup screen appears when using Recovery Console CD's, press the R key to open the Recovery Console.
    NOTE: If "Microsoft Windows XP Recovery Console" does not list and you do not have a CD with recovery console, try the following:
    1. Turn on the PC, and press the F10 key repeatedly at the first screen.
    2. At the Recovery screen, click Advanced Options .
    3. Press the Alt + D keys at the same time to open a command prompt window and skip to step 5.
  4. When the log in prompt appears, press the number next to the windows version (min int or Windows) and type the log on password. Try pressing Enter if you do not know the password.
  5. At the command prompt, type the following: disk part
  6. Press Enter , do one the following:
    • If a table of volume names appears, remember the drive letter next to the main drive volume name (usually D or H next to HP_PAVILION or PRESARIO) and press the Esc key.
    • If a disk part prompt appears, type list volume , press Enter , remember the drive letter next to the main drive volume name (usually D or H next to HP_PAVILION or PRESARIO), type exit when done, and then press Enter .

    NOTE: If the main drive volume name does not appear in the list, the PC needs to be recovered. For more information, refer to Performing a Full System Recovery in XP .
Step 2: Replacing the file from a backup folderUse the following steps to find and replace the L sass file from the command prompt environment:
  1. Type the following at the command prompt: CD X:\i386 (where X is the main drive letter)
  2. Press the Enter key. If the error The system cannot find the path specified appears, enter the following paths, in order, until the error does not occur:
    • cd X:\Windows\i386 (where X is the main drive letter)
    • cd c:\i386
    • cd c:\Windows\i386
  3. Press the Enter key, and type the following at the command prompt: expand lsass.ex_ X:\windows\system32 (where X is the drive letter)
  4. Press the Enter key, and type the following at the command prompt: cd X:\windows\system32 (where X is the drive letter)
  5. Press the Enter key, and type the following at the command prompt: attrib lsass.exe -r
  6. Press the Enter key, and type the following at the command prompt: rename lsass.exe lsass.bak
  7. Press the Enter key, and type the following at the command prompt: rename lsass.ex_ lsass.exe
  8. Press the Enter key, and type the following at the command prompt: exit
  9. Press Enter and the PC restarts without the error. If the error persists, go to the next step.
Step 3: Recovering the PC If the error still continues, recover the PC .

Please rate me if this solution works for you

Thanks......Have a great time.

Jul 11, 2010 | Dell Inspiron 530s Desktop Computer

1 Answer

How to create macro button in microsoft excel 2007 because


well follow the steps below to get your job done:

To create an option button in Microsoft Office Excel 2007, make sure that you add Option Button (form control) to the Quick Access Toolbar. To do this, follow these steps:
  1. Click the Microsoft Office Button, and then click Excel Options.
  2. Click the Customize category, select All Commands in the Choose commands from list, select Option Button (form control), and then click OK.
To create an option button and to assign a macro to it, follow these steps:
  1. In Excel 2003 and in earlier versions of Excel, click Option Button on the Forms toolbar, and then draw the outline of the button on the sheet.

    In Excel 2007, click Option Button (form control) on the Quick Access Toolbar, and then draw the outline of the button on the sheet.
  2. Select any cell in the worksheet.
  3. In versions of Excel that are for Microsoft Windows, right-click the option button, and then click Assign Macro.

    In versions of Excel that are for Macintosh, press COMMAND while you click or press CTRL while you click, depending on your operating system version. Then, click Assign Macro.
  4. In the Assign Macro dialog box, click the name of the macro that you want to assign to the option button, and then click OK.
When you click the option button, the macro will run.


good luck ...:-)

Apr 08, 2010 | Microsoft Office Excel 2007

2 Answers

I BOUGHT A 95 LINCOLN CONTININTAL USED AND I DO NOT KNOW WHAT THE CODE IS ON THE DOOR KEYPAD AND I WOULD LIKE TO RESET THE CODE HOW DO I CHANGE IT WITHOUT KNOWING WHAT THE OLD CODE WAS.


The factoty code is found in the trunk on the right side lift support. The factory code can never be deleted. To reset and delete any added codes, key in the 5 digit factory code. Within 5 seconds press the 1/2 button. Within 5 seconds again press the 1/2 button again. All previously added codes are delete. To add your own code, key in the 5 digit factory code. Within 5 seconds press te 1/2 button. Within 5 seconds again enter your personal 5 digit code. Note that when you complete these steps, the doors will lock then unlock meaning that the command to add or delete a code is complete. You can add 5 different codes in the memory, but when you complete the delete command, it deletes all added codes but never the factory code.

Feb 23, 2010 | 1995 Lincoln Continental

1 Answer

Logitech Harmony One remote is controlling 2 TiVOs at once.


Please try learning the some commands from one of the original remotes for thr tivo. If this fixes the problem, i suggest that you learn all commands from that remote.

Launch the Logitech Harmony Remote software and login to your account

1. Click on the Devices tab
2. Click on the Learn IR button for the device you want to learn command(s) to.

**NOTE: When learning new commands, there are three different options available:
-You want the Harmony Remote to learn a single command that is already listed in the software
-You want the Harmony Remote to learn more than one command at a time
-You want the Harmony Remote to learn a new command, which is not listed in the software

You want the Harmony Remote to learn a single command that is already listed in the software
a. Click on the Learn button next to the command you want to learn - Proceed to Step 5

You want the Harmony Remote to learn more than one command at a time
a. select one or more commands by clicking on the check box next to the command(s) you want to learn and then
b. click on the Learn Selected Commands button
c. Proceed to Step 5

You want the Harmony Remote to learn a new command, which is not listed in the software:
a. Scroll down to the button of the page
b. In the Learn a New Command box click on the text MyNewCommand
c. enter the name of the command you would like to teach.
d. Click on the (Learn New Command) button
e. Proceed to Step 5

5. Follow the onscreen directions for learning commands, plugging in your Harmony remote when asked and lining up your original remote to the Harmony as illustrated on the screen.
6. When a command is successfully learned, a check mark will appear next to it. If learning more than one command, the software will then prompt you to learn the next command.
7. The commands that were learned should now be identified as from "Your original remote" and highlighted in turquoise.
8. When you have finished teaching the commands, click Done button to save your changes
9. Click on the Update Remote button to update your remote


If this does not work, try :


To teach commands for your Device that did not work properly in normal mode:

1. Click the Devices button on your home page.
2. Select the Device you wish to learn commands to.
3. Select Learn Infrared Commands.
4. Click Custom. The page will reload.
5. Select the boxes for commands you would like to teach, and click Learn Selected as Raw.

NOTE: When teaching each command, press the button on the original remote for as long as required to control the device. The commands will be learned with the exact format that is sent by the original remote.

If you have any trouble teaching the commands in RAW, complete the following steps:

1. Verify you are pointing the original remote at bottom end of your remote, and are holding the remotes 2-4 inches apart.
2. Minimize the amount of light that could interfere with the learning process by covering the distance between the remotes. Block out sunlight, or turn off the lights.
3. Check that you have installed new batteries in the original remote you are trying to use to learn commands. If the batteries are low, the signal coming from your original remote may be too weak for the remote to detect.
4. Be sure to hold down the button on the original remote for at least 1-2 seconds, otherwise the signal may be too short for the remote to process.
5. If you continue to have trouble teaching the commands, start with the remotes 2 inches apart. Then try again with, slightly increasing the distance each time (2.5 inches, 3 inches, etc).
6. Vary the angle at which the original remote is pointing at the bottom of the remote.
7. Ensure the device's original remote is sending infrared (IR) commands.

NOTE: The original remote is sending RF or UHF commands from the original remote if it will control the device from another room, through a wall).

Oct 04, 2009 | Logitech Harmony One Advanced Universal...

1 Answer

HP photosmart C7180 all in one not printing properly.


Hi,

As explained by you it seems to be an issue with the printer drivers.you can follow the following steps .

steps ...

1. Open a Command Prompt window

key the commands
net stop spooler

2. In the run (Start Search for Vista) type : c:/windows/system32/spool/drivers…look for w32x86 folder.

3. Inside w32x86, there will be folders with the names 2 and 3 .
delete all of the files and sub-folders in each of the 2 and 3 folders, but not the folders themselves.

4 Start > run > type > regedit .
Navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Print\Environments\Windows NT x86\Drivers
There might be two entries names Version-2 and Version-3 under drivers: click the plus sign against them and remove everything under them.

4. In the run (Start Search for Vista) type : c:/windows/system32/spool/printers: delete any files there.

5. Open a Command Prompt window
key the commands
1. sc config spooler depend= RPCSS
2. net start spooler

Then follow these >>>>

> browse the disc n go to folder util > ccc > there you wud find some uninstall files > run uninstall _L1.bat.

make sure the printer should be unplugged while you perform the steps .

> then insert the disc and click on add a device .
follow the instructions and connect the us cable when prompted .
Hope this helps .
Take care

May 19, 2008 | HP Photosmart C7180 All-In-One InkJet...

3 Answers

System not booting


take windows xp cd and repair from the cd

Sep 01, 2007 | Microsoft Windows XP Professional With...

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

Related Topics:

631 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Ekse

Level 3 Expert

13434 Answers

ThaMp3Doctor
ThaMp3Doctor

Level 3 Expert

8597 Answers

Scoee Scoffer

Level 2 Expert

162 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...