Question about Microsoft Office Standard for PC

1 Answer

How to activate command buttons II

Hello again, This is a continuation from my last problem. I am having trouble with getting some of my command buttons to work properly. When the add record command button is clicked, a window pops up saying "You can't go to the specified record". I right clicked the command button and went to properties, under the "event" heading and the "On Click" option I clicked the "..." which brings me to the code page which shows the following: Private Sub Add_Record_Click() On Error GoTo Err_Add_Record_Click DoCmd.GoToRecord , , acNewRec Exit_Add_Record_Click: Exit Sub Err_Add_Record_Click: MsgBox Err.Description Resume Exit_Add_Record_Click End Sub I'm not sure what this means but from this information and am not familiar with Microsoft Access. Can you find out what I have to do to get this command button to work properly as simply put as possible? Thanks for your help -Lensa

Posted by on


1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that got 5 achievements.


    An expert who has written 7 tips or uploaded 3 video tips


    An expert who has written 3 tips or uploaded 2 video tips.

  • Expert
  • 58 Answers

Hi Lensa, The code is fine there should not be any problem with it. Do not change anything on it. In my opinion the buttons and code has nothing to do with it since they are done automatically and usually work fine. When you press the add new button you are not just creating a new record you are also updating the last record. This button just send you to a new empty record for you to fill. From my experience the error message is due to 3 major reasons: 1. Your record source for this form is a query that cannot be updated 2. You don't have writing permissions to the database. Check and see if the file is locked or its on read only, Check security options and see if the database is read only etc. 3. Your records are locked by the table setting for some reasons, primary key fields might create duplicates. If its just a table try updating the table without a form and see what happens. As I wrote above the problem is with the record source or the database and since I can't see what you have there I can't help you further. I would also suggest you should practice with a simple table first before going into advance queries. Create a table with some simple fields like: ID - Primary key - Auto Number First name - Text Last name - Text Then create a form of that table and start filling in the names and test all the buttons, that will give you an idea of each button and I am sure it will be easier. Good luck Daniel

Posted on Aug 16, 2007


1 Suggested Answer

  • 2 Answers

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

A 6ya expert can help you resolve that 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.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Good luck!

Posted on Jan 02, 2017


Add Your Answer

Uploading: 0%


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



Related Questions:

1 Answer

Need help with activating sim card tried last nite didn't work

Hello, friend! I also meet this error about my cell phone, I get many help from this forum, and also bought many DIY repair tools from china supplier , and vipprogrammer help me fix this error. maybe you can try it.or contact ther WhatsApp:+ 8615986801289 website: They've solved my cell phone problem and I hope it will help you with your mobile phone trouble.They have professional repair tools.

Oct 17, 2017 | Cell Phones

2 Answers

The machine had to be turned off while in the processing of doing a design. How can I get back to the last stitch so I can continue with the design?

I don't quite understand the question but I'll try to answer what I think you mean.
Most embroidery machines have a command pause and command backspace in order to go backwards to a point that you want to correct. To get it going again it has a continue command in order to get it going on again from the point you backed up to. It is unnecessary to remove the hoop in order to do this.

Aug 29, 2016 | Husqvarna Sewing Machines

1 Answer

Hampton bay model uc 7083t light very dim when turned on

You probably have one or the other of the remotes pictured below:


In both cases, if you press and HOLD the button labeled "Light / Dimmer" (top remote) or the top round button with the light bulb icon on it (bottom remote), the intensity of the lamp will become brighter until it is at maximum and then become dimmer until it almost turns off . If you continue to hold the button, it will begin to get brighter once again. Pressing the button quickly simply turns it off when it is on, and on when it is off.

The buttons on the remote leave a bit to be desired as far as how well they work. You should keep an eye on the red LED indicator while pressing any button. If it fails to light the command is never sent. If it stops lighting while holding a button in, (to send a dimming or brighten command to the lamp) the command stops being sent and the intensity of the lamp no longer changes. I have found that sometimes I have to press the edge of the button to get them to work. If yours is giving you trouble - you might try that, too.

I hope this helps & good luck!

Sep 09, 2011 | Hampton Bay 24002 Ceiling Fan

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

1 Answer

Error code 80010006 and ervery time it gets to 38% and it gives me that error code this was when i was tyying to do the 3.30 firmware update

Hello jenky2010

This error code relates to the PS3 having trouble accessing a file. This usually occurs when the PS3 is turned off while saving or accessing a file.

To rectify the problem, you'll have to into Safe Mode, and then select "Restore File System". If you're not sure how to enter Safe Mode, follow these instructions:

1. Turn off the PS3 by holding down the power button until the power light is red, then release.

2. Hold down the power button again. This should be shortly followed by a short beep, indicating that the PS3 is turning on.

3. Continue holding the power button, and after about 5 seconds you should hear a second beep.

4. Continue holding the power button, and after a further 5 seconds, you should hear a quick double beep. Release the power button. If you've successfully activated Safe Mode, you should receive the message" Connect a controller using a USB cable and then press the PS button". Do this.

5. Select "Restore File System". Follow the on-screen instructions.


Hope this helps, good luck. If you require any further assistance, please contact me.


Jul 18, 2010 | Sony PlayStation® 3 (80GB) Console

1 Answer

When I press the power button of my CPU i hear 3 Continuous beeps which repeats thrice. Again the beeps come during the windows login. This beep was not there in the begining. It started recently. But...

It is true that your computer is working properly without any trouble.Three continuous beeps means that your keyboard component is not ready to input the data.That's why it is calling you as beeps.You might have to check your keyboard that it is attached with the CPU properly or not.

Apr 06, 2010 | ASUS M4A79 Deluxe Motherboard

1 Answer

Volume buttons have to be pressed hard to work

Try mapping the Volume buttons to the LCD screen in each Activity you use them in. To do this, see below.

1. Launch the Logitech Harmony Remote software and login to your account
2. From the Harmony homepage, click on the Customize Buttons button for the Activity you wish to customize.
Additional Buttons:
To modify commands on the LCD screen, click on the Additional Buttons tab at the top of the page.

a. In the Button column, select the button you wish to customize, from 1 to 4 for each page. The illustration of the remote below shows where each button is placed on the display.
b. In the text box in the Button column Type in the name of the button.
c. In the Device column, select the device you wish to send the command to.
e. In the Command column, select the command you want from the dropdown list
f. You can delete a command by clicking the trash can icon beside it
g. You can move commands to different button positions by using the arrows
h. Click on the Add new Page button to add another page
i. Click on the Learn Command button if the command you need is not in the drop-down box. You will be able to capture the button from your original remote.
j. Click on the Add Sequence button to create a custom sequence of 5 commands for a single button.
k. After making any changes, ensure that you click on the Done button to save the button customizations. The last step is to update your remote.
l. Connect the Harmony to your computer’s USB cable and click on the Update Remote button on the Harmony homepage

Test the commands on the LCD. if they do work id advise you to contact logitech.

Jan 14, 2010 | Logitech Harmony 880 LCD Remote Control

1 Answer

Cant restart Vista

To activate the administrator account in Vista, follow these instructions:
  1. Logon to Windows Vista with normal user account username and password (must belongs to Administrators group).
  2. Click on Vista Start button, and type cmd in the Start Search box.
  3. Right click on the Cmd rand select Run as Administrator
  4. In the Command Prompt window, type the following text at the command line to set a password for administrator account.
  5. net user administrator (password)
    Replace password with the actual password string that you have chosen. Press Enter when done.
  6. Next type the following command and press Enter to activate and enable Administrator account: net user administrator activate:yes
  7. The process should completed with the following message: The command completed successfully
    If not success message is returned, repeat the process again.
  8. Logout from Vista by choosing Log Off or Switch User.
  9. Click on Administrator icon and logon with the password you selected. Now view system logs to see what errors were gererated.And run a good virus scanner

Jan 06, 2009 | Computers & Internet

1 Answer

How to activate command buttons

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.

Aug 14, 2007 | Microsoft Office Standard for PC

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

112 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2970 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18417 Answers

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

Answer questions

Manuals & User Guides