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
|
|||
|
|||
Error: Cannot got to specified record. Access 2007 and SQL 2005
I have inherited an Access 2007 database that has been split so the
tables are on a SQL 2005 server. The database consists of 3 tables and 3 forms. The main form that is used reads and writes to all 3 tables. Data can be edited and deleted OK but trying to add a new record throws an error saying, "You can't go to the specified record" The code for the new record button is an embedded macro with the follow parameters: OnError Next, GoToRecord ,,New, [MacroError]0 MsgBox =[MacroError].[Description],Yes,None, Any advice would be greatly appreciated Thanks, Amy |
#2
|
|||
|
|||
Error: Cannot got to specified record. Access 2007 and SQL 2005
On Thu, 12 Nov 2009 01:52:21 -0800 (PST), Amies
wrote: What is the RecordSource of that form? If you create a View on SQL Server with the same sqlstatement, can you add a row to it? I suspect there are some joins involved and adding data simply is not possible with such complex sqlstatement. Simplify. -Tom. Microsoft Access MVP I have inherited an Access 2007 database that has been split so the tables are on a SQL 2005 server. The database consists of 3 tables and 3 forms. The main form that is used reads and writes to all 3 tables. Data can be edited and deleted OK but trying to add a new record throws an error saying, "You can't go to the specified record" The code for the new record button is an embedded macro with the follow parameters: OnError Next, GoToRecord ,,New, [MacroError]0 MsgBox =[MacroError].[Description],Yes,None, Any advice would be greatly appreciated Thanks, Amy |
Thread Tools | |
Display Modes | |
|
|