By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,950 Members | 989 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,950 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.