Microsoft Office Standard for PC Logo

Related Topics:

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



1 Answer


  • Level 1:

    An expert who has achieved level 1.


    An expert that has over 10 points.


    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.
    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.
    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)
    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.



Add Your Answer


Uploading: 0%


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



Related Questions:


Activating HBOGO

Enjoy HBO go channel on your Roku device from Roku channel store, here we provide some easy steps to HBO go activate on your Roku Device:

    1. First of all, Go to Roku channel store and search for HBO GO channel on search bar
    2. Select HBO GO channel and click on "Add Channel"
    3. Sign in to
    ·account, then select subscribe option
    4. Now, HBO GO CHANNEL is automatically added to your channel list.

hbo go activate-330tiuz34b4op4ogzwskpt5i-5-0.jpg
Mar 03, 2018 • Cell Phones

Can you help me to active windows xp


To activate Windows XP by using an Internet connection, follow these steps:

Click Start, point to All Programs, point to Accessories, point to System Tools, and then click Activate Windows.
Or, click the Windows Activation icon in the notification area.
Click Yes, let's activate Windows over the Internet now.
Click Read the Windows Product Activation Privacy Statement, click Back, and then click Next.
Use one of the following methods:
If you want to register and activate Windows at the same time, click Yes, I want to register and activate Windows at the same time, click Read the Windows Registration Privacy Statement, click Back, click Next, type your contact information in the appropriate boxes in the registration form, and then click Next. An asterisk (*) appears next to required information.
If you only want to activate Windows, click No, I don't want to register now; let's just activate Windows, and then click Next.
The wizard establishes a connection with an activation server, and then processes the activation request.
When activation is completed and you receive the following message, click OK:
You have successfully activated your copy of Windows.

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:
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!

I have genuine windows 7 but computer says that it is not genuine

To resolve this issue, you can either disable the policy setting (Method A), or edit the permissions to provide the Licensing Service the required permissions (Method B). Method A: Disable the Plug and Play Policy
1. Determine the source of the policy. To do this, follow these steps:
a. On the client experiencing the Activation error, run the Resultant Set of Policy wizard by clicking Start, Run and entering rsop.msc as the command.
b. Visit the following location:
Computer Configuration / Policies / Windows Settings /Security Settings / System Services /
If the Plug and Play service is configured through a Group Policy setting, you see it here with settings other than Not Defined. Additionally, you can see which Group Policy is applying this setting.

2. Disable the Group Policy settings and force the Group Policy to be reapplied.
a. Edit the Group Policy that is identified in Step 1 and change the setting to "Not Defined." Or, follow the section below to add the required permissions for the Network Service account.
b. Force the Group Policy setting to reapply: gpupdate /force (a restart of the client is sometimes required)
Method B: Edit the permissions of the Group Policy:
1. Open the Group Policy that is identified in Method A, Step 1 above, and open the corresponding Group Policy setting.
2. Click the Edit Security button, and then click the Advanced button.
3. In the Advanced Security Settings for Plug and Play window click Add and then add the SERVICE account. Then, click OK
4. Select the following permissions in the Allow section and then click OK:
Query template
Query status
Enumerate dependents
User-defined control
Read permissions
Note: The Previous rights are the minimum required permissions.
5. Run gpupdate /force after you apply the previous permissions to the Group Policy setting.
6. Verify that the appropriate permissions are applied with the following command:
sc sdshow plugplay
The following are the rights applied to the Plug and Play service in SDDL:

(A;;CC LC SW LO CR RC ;;;SU is an Access Control Entry (ACE) that allows the following rights to "SU" (SDDL_SERVICE - Service logon user)
A: Access Allowed
CC: Create Child
LC: List Children
SW: Self Write
LO: List Object
CR: Control Access
RC: Read Control
SU: Service Logon User
Note: If there are no GPO's in place, then another activity may have changed the default registry permissions. To work around this issue, perform the following steps:
  1. On the computer that is out of tolerance, start Registry Editor.
  2. Right-click the registry key HKEY_USERS\S-1-5-20, and select Permissions...
  3. If the NETWORK SERVICE is not present, click Add...
  4. In Enter the object names to select type Network Service and then click Check Names and OK.
  5. Select the NETWORK SERVICE and Grant Full Control and Read permissions.
  6. Restart the computer.
  7. After the restart, the system may require activation. Complete the activation.
If you think this solution helps you then your token of appreciation in the form of Rating and a testimonial will be esteemed.
Thank you and Keep Visiting FixYa!

Hwo to instal windows 7


Welcome to FixYa.

Please elaborate your problem providing us with more details.

Thanks for using FixYa.

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 ...:-)


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.



this is not a sufficient to answer. but, you can get some idea in the following information:

if you have a plan to install AD:
  • install AD using manage your server wizard. (or)
  • install AD using DCPROMO command
After, you have to follow the AD installation instructions to store the ntds and sysvol files.

installing dns, is also need for a domain to adding clients.

after this, you can get your desired domain controller and active director users and computers information.

i think, this may be useful for you.



Nothing happens when I click form wizard?????

You might cancel the security wizards option during your 1st time click of "Form Wizards" of More Forms menu. To solve this problem follow this steps.
  1. In Access 2007, click the Microsoft Office Button, and then click Access Options (the office 2007 logo on your left top area of access 2007 or the Circle button on your top)
  2. Click Trust Center.
  3. Click Trust Center Settings.
  4. Click Trusted Locations.
  5. Click Add new location.
  6. In the Microsoft Office Trusted Location dialog box then click Browse.
  7. In the Browse dialog box, locate and select the folder that contains the Access database, and then click OK.
Not finding what you are looking for?


Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts


Level 3 Expert

13435 Answers

David Shaub

Level 3 Expert

2991 Answers

Mandeep  Singh
Mandeep Singh

Level 3 Expert

1184 Answers

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

Answer questions

Manuals & User Guides