If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Command button - add entry - getting error.
I get the error: can't go to specified record.
I am using the form to enter production numbers. This is the code created when I used the command button wizard: Private Sub Command32_add_entry_Click() On Error GoTo Err_Command32_add_entry_Click DoCmd.GoToRecord , , acNewRec Exit_Command32_add_entry_Click: Exit Sub Err_Command32_add_entry_Click: MsgBox Err.Description Resume Exit_Command32_add_entry_Click End Sub -- Thanks!! Bonni |
#2
|
|||
|
|||
Command button - add entry - getting error.
The first thing that comes to mind is that the form's Allow Additions is set
to NO. Go to the form's Properties Box, click on the Data tab and set it to YES. IF you want users to be able to edit or delete records, make sure AllowEdits and AllowDeletions are set to YES also. There are other ways (in code) that the form could be set to not allow additions, but, assuming thisis your db abd not inherited from someone else, you'd know if you'd coded this. -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000 Message posted via http://www.accessmonster.com |
#3
|
|||
|
|||
Command button - add entry - getting error.
Thanks I'll try that.
Unfortunatly this is part my db and part inherited. The original author was a programmer and wrote quite a bit of VB into the db. This form is all me so it is pretty basic. -- Bonni "missinglinq via AccessMonster.com" wrote: The first thing that comes to mind is that the form's Allow Additions is set to NO. Go to the form's Properties Box, click on the Data tab and set it to YES. IF you want users to be able to edit or delete records, make sure AllowEdits and AllowDeletions are set to YES also. There are other ways (in code) that the form could be set to not allow additions, but, assuming thisis your db abd not inherited from someone else, you'd know if you'd coded this. -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000 Message posted via http://www.accessmonster.com |
#4
|
|||
|
|||
Command button - add entry - getting error.
I checked the Allow additions and it is set to yes. Anything else I can try?
thanks -- Bonni "missinglinq via AccessMonster.com" wrote: The first thing that comes to mind is that the form's Allow Additions is set to NO. Go to the form's Properties Box, click on the Data tab and set it to YES. IF you want users to be able to edit or delete records, make sure AllowEdits and AllowDeletions are set to YES also. There are other ways (in code) that the form could be set to not allow additions, but, assuming thisis your db abd not inherited from someone else, you'd know if you'd coded this. -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000 Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|