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
Re: How to activate command buttons II

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

Add Your Answer

0 characters

Uploading: 0%


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


3 Points

Related Questions:

3 Answers

Activation key microsoft home and student office 2007

If you want to activate office 2007, this site:
will help u a lot when you meet with problems.

Mar 23, 2013 | Microsoft Office Home and Student 2007...

3 Answers

My msoffice 2010 do not activated properly

Did you enter your key and activate (e.g. did you do the steps outlined in this page)

If you have followed the steps and did not work please try the following. Go to File tab \' Help and click on the Change Product Key link.

Enter the key on the page corresponding to your product (e.g. if you\'re running Word, enter the Professional Plus key, since Word is part of the Professional Plus suite).

Click Install to install the key. Then restart Word, and you should be prompted to activate.

Continue with activation, and restart Word again. If you click File tab \' Help, you should see "Product Activated" on the right hand side.

Mar 14, 2011 | Microsoft Office Professional 2007 Full...

1 Answer

My product key turned to non functionality mode because I didnt entered it within 60 days. Now I cant use the MS Word 2007. How can I turn that to normal?

on the top tool bar, click on the down arrow button on the left. That should give you a drop down list of commands. click on Resources command. You will see Activate function there. click and follow the prompts. I am assuming you have got the activation code for your microsoft office.

Feb 27, 2011 | Microsoft Office Professional 2007 Full...

1 Answer

SIR, I wish to known MS Office 2007 advance functining & sortcuts

Function keysTo do this Press
Get Help or visit Microsoft Office Online. F1
Move text or graphics. F2
Repeat the last action. F4
Choose the Go To command (Home tab). F5
Go to the next pane or frame. F6
Choose the Spelling command (Review tab). F7
Extend a selection. F8
Update the selected fields. F9
Show KeyTips. F10
Go to the next field. F11
Choose the Save As command (Microsoft Office Button ). F12

SHIFT+Function keyTo do this Press
Start context-sensitive Help or reveal formatting. SHIFT+F1
Copy text. SHIFT+F2
Change the case of letters. SHIFT+F3
Repeat a Find or Go To action. SHIFT+F4
Move to the last change. SHIFT+F5
Go to the previous pane or frame (after pressing F6). SHIFT+F6
Choose the Thesaurus command (Review tab, Proofing group). SHIFT+F7
Shrink a selection. SHIFT+F8
Switch between a field code and its result. SHIFT+F9
Display a shortcut menu. SHIFT+F10
Go to the previous field. SHIFT+F11
Choose the Save command (Microsoft Office Button ). SHIFT+F12

CTRL+Function keyTo do this Press
Choose the Print Preview command (Microsoft Office Button ). CTRL+F2
Cut to the Spike. CTRL+F3
Close the window. CTRL+F4
Go to the next window. CTRL+F6
Insert an empty field. CTRL+F9
Maximize the document window. CTRL+F10
Lock a field. CTRL+F11
Choose the Open command (Microsoft Office Button ). CTRL+F12

CTRL+SHIFT+Function keyTo do this Press
Insert the contents of the Spike. CTRL+SHIFT+F3
Edit a bookmark. CTRL+SHIFT+F5
Go to the previous window. CTRL+SHIFT+F6
Update linked information in an Office Word 2007 source document. CTRL+SHIFT+F7
Extend a selection or block. CTRL+SHIFT+F8, and then press an arrow key
Unlink a field. CTRL+SHIFT+F9
Unlock a field. CTRL+SHIFT+F11
Choose the Print command (Microsoft Office Button ). CTRL+SHIFT+F12

ALT+Function keyTo do this Press
Go to the next field. ALT+F1
Create a new Building Block. ALT+F3
Exit Office Word 2007. ALT+F4
Restore the program window size. ALT+F5
Move from an open dialog box back to the document, for dialog boxes such as Find and Replace that support this behavior. ALT+F6
Find the next misspelling or grammatical error. ALT+F7
Run a macro. ALT+F8
Switch between all field codes and their results. ALT+F9
Maximize the program window. ALT+F10
Display Microsoft Visual Basic code. ALT+F11

ALT+SHIFT+Function keyTo do this Press
Go to the previous field. ALT+SHIFT+F1
Choose the Save command (Microsoft Office Button ). ALT+SHIFT+F2
Display the Research task pane. ALT+SHIFT+F7
Run GOTOBUTTON or MACROBUTTON from the field that displays the field results. ALT+SHIFT+F9
Display a menu or message for a smart tag. ALT+SHIFT+F10

CTRL+ALT+Function keyTo do this Press
Display Microsoft System Information. CTRL+ALT+F1
Choose the Open command (Microsoft Office Button ). CTRL+ALT+F2

Jan 05, 2011 | Microsoft Office Standard 2007: Windows

2 Answers

Ms office

u need to uninstall it and reinstall it again.
and use a serial key to activate ur MS Office.

Sep 17, 2009 | Microsoft Office Professional 2007 Full...

1 Answer

Bought Microsoft office student version last april, downloaded it, and spend the 9.00 to get a key and the ability to download again. Now we have a new computer. We can download from the site, but we get...

Usually this is good for three computers. Install the software and activate it as if it were the fisrt time. Do not use the key you obtained when you activated the first time.
Hope it helps.

Aug 29, 2009 | Microsoft Office Professional 2007 Full...

1 Answer

Macros Command Help

Your Excel may have a different "Macro Security" setting. Your "Macro Security" can be adjusted: Tools, Macro, Security. I highly recommend the "Medium" setting. This will prompt you when an Excel file is opened that contains Macros to Enable or Disable. If you choose a security setting of "Low" please be very careful as this will allow Macros to run without any notice, VERY DANGEROUS.

Oct 04, 2007 | Microsoft Office Standard for PC

2 Answers


It is very useful to learn excel shortcut realy i thank you

Sep 26, 2007 | Microsoft Office Standard for PC

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

109 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18257 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides