G
Guest
Hello,
I have read previous discussions on this issue but it does not satified my
problem with this error.
I will be VERY, VERY grateful if someone can help some my problem:
I am currently creating an expense tracking program using Access 2002 and I
have encountered an error stating "You can't go to the specified record" when
you are trying to add a new record into an ODBC table called "Project Code".
I have various tables (in ODBC) in which I am successfully able to add,
update and edit but with this particular table, I am not able to add records
(through the program, but can do it manually).
Here is a breakdown of what I have:
The form - "Add New Project Code" has all of its properties turned on to YES
(such as Allow New Additions). Plus I have the Recordset Type pointing to
Dynaset (Inconsistent Updates).
The macro behind a click button (Add New Record) states the following:
DoCmd.GoToRecord , , acNewRec
The macro in open this form (Add New Project Code) is the following:
Function Menu_Add_New_Project_Code1()
On Error GoTo Menu_Add_New_Project_Code1_Err
DoCmd.OpenForm "Add Accounting Project Code", acNormal, "", "", acAdd,
acNormal
DoCmd.Maximize
Menu_Add_New_Project_Code1_Exit:
Exit Function
Menu_Add_New_Project_Code1_Err:
MsgBox Error$
Resume Menu_Add_New_Project_Code1_Exit
End Function
Does anyone have a solution??? :-(
I have read previous discussions on this issue but it does not satified my
problem with this error.
I will be VERY, VERY grateful if someone can help some my problem:
I am currently creating an expense tracking program using Access 2002 and I
have encountered an error stating "You can't go to the specified record" when
you are trying to add a new record into an ODBC table called "Project Code".
I have various tables (in ODBC) in which I am successfully able to add,
update and edit but with this particular table, I am not able to add records
(through the program, but can do it manually).
Here is a breakdown of what I have:
The form - "Add New Project Code" has all of its properties turned on to YES
(such as Allow New Additions). Plus I have the Recordset Type pointing to
Dynaset (Inconsistent Updates).
The macro behind a click button (Add New Record) states the following:
DoCmd.GoToRecord , , acNewRec
The macro in open this form (Add New Project Code) is the following:
Function Menu_Add_New_Project_Code1()
On Error GoTo Menu_Add_New_Project_Code1_Err
DoCmd.OpenForm "Add Accounting Project Code", acNormal, "", "", acAdd,
acNormal
DoCmd.Maximize
Menu_Add_New_Project_Code1_Exit:
Exit Function
Menu_Add_New_Project_Code1_Err:
MsgBox Error$
Resume Menu_Add_New_Project_Code1_Exit
End Function
Does anyone have a solution??? :-(