467,905 Members | 1,840 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,905 developers. It's quick & easy.

Converting Access 2000 to SQL Server (docmd.GoToRecord problem)

Hi,

I'm converting ACCESS 2000 database to SQL Server. I have .adp
project.
In the .mdb I have form where I'll insert rows into two different
tables using docmd.GoToRecod ,,acNewRec.

In .adp form's Record source property I have following Stored
Procedure (in .mdb there were similar query).

Stored Procedure: Insert_sp
SELECT [Table1].[Name],
[Table2].[Name] as Name2
FROM Table1
INNER JOIN Table2 ON
Table1.Name = Table2.Name;

return

In the form I have command button (Command4) and its code in VBA
Private Sub Command4_Click()
On Error GoTo Err_Command4_Click
DoCmd.GoToRecord , , acNewRec

Exit_Command4_Click:
Exit Sub

Err_Command4_Click:
MsgBox Err.Description
Resume Exit_Command4_Click

End Sub

I get error message: You can't go to the specified record !
My question is: Is it so that you cannot do docmd.GoToRecord
,,acNewRec when you have more than one table in your stored procedure.

How could I solve this problem ?

Any ideas ?

I'm very glad of any tips !

colpo
Nov 13 '05 #1
  • viewed: 1462
Share:

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

12 posts views Thread by pballou | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.