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

  • 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

  • Kaj Kandler
    Kaj Kandler 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

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

Can you help me to active windows xp


Hello,

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.

Jun 24, 2011 | Microsoft Windows XP Home Edition English...

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

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

D:(A;;CCDCLCSWRPWPDTLOCRSDRCWDWO;;;SY)
(A;;CCDCLCSWRPWPDTLOCRSDRCWDWO;;;BA)
(A;;CCLCSWLOCRRC;;;IU)
(A;;CCLCSWLOCRRC;;;SU)
S:(AU;FA;CCDCLCSWRPWPDTLOCRSDRCWDWO;;;WD)
(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!

Apr 13, 2011 | Microsoft Windows 7 Ultimate 32 & 64 BIT

1 Answer

Cannot add user in win 7 via cmd. System error 234


In order to make it work, you will need to open super administrator option following steps below:

Right click on CMD / Command Prompt , choose "Run as Administrator" on popup box click on "Continue".
Now type in Net user administrator /active:yes and press Enter.

It will show you "The command completed successfully".

Now try adding new user. Once you are done, please disable administrator option again following same as before, just little change in command as below:

Net user administrator /active:no

That's all. I hope you can do it.

For more assistance, please stay connected with us.

Thanks for joining us.

Have a nice day.

Feb 21, 2011 | Microsoft Computers & Internet

2 Answers

Hwo to instal windows 7


Hi,

Welcome to FixYa.

Please elaborate your problem providing us with more details.

Thanks for using FixYa.

Nov 26, 2010 | Polaroid FLM-3732 Television

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

Ans


Hello,

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.

thanks,

Feb 12, 2009 | Microsoft Windows Server Standard 2003 for...

1 Answer

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.

Nov 18, 2008 | Microsoft Office Professional 2007 Full...

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

Related Topics:

626 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

3015 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18429 Answers

Alun Cox

Level 3 Expert

2678 Answers

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

Answer questions

Manuals & User Guides

Loading...