473,385 Members | 1,326 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

DoCmd.GoToRecord , , acNewRec

Hi

My MS-Access 2003 "Form" is bind to a SQL server 2000 table but I
wonder why doesn't it accept the following command and displays an
error that "You can't go to the specified record". It works well with
MS Access tables but creates problem when the backend table belongs to
SQL server :

DoCmd.GoToRecord , , acNewRec
Can anyone help me with solving this problem.
cheers!!!

Feb 22 '06 #1
3 17292
Br
sa*********@yahoo.com wrote:
Hi

My MS-Access 2003 "Form" is bind to a SQL server 2000 table but I
wonder why doesn't it accept the following command and displays an
error that "You can't go to the specified record". It works well with
MS Access tables but creates problem when the backend table belongs to
SQL server :

DoCmd.GoToRecord , , acNewRec
Can anyone help me with solving this problem.
cheers!!!


Is the new record icon enabled on the form?

What is your recordsource?

Have you set an UniqueTable?

I know in A2000 you had to do some tricks to get your recordset to be
updable... (but that was released before SQL2000).
--
regards,

Br@dley
Feb 22 '06 #2
Does the SQL Server table have a primary key defined? (I suspect it does if
you can update existing records.) Can you open the Table in Datasheet View
and add a new Record? (If not, then it is likely a matter of user
permissions in SQL Server.)

Larry Linson
Microsoft Access MVP

<sa*********@yahoo.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
Hi

My MS-Access 2003 "Form" is bind to a SQL server 2000 table but I
wonder why doesn't it accept the following command and displays an
error that "You can't go to the specified record". It works well with
MS Access tables but creates problem when the backend table belongs to
SQL server :

DoCmd.GoToRecord , , acNewRec
Can anyone help me with solving this problem.
cheers!!!

Feb 22 '06 #3
Br
Larry Linson wrote:
Does the SQL Server table have a primary key defined? (I suspect it
does if you can update existing records.) Can you open the Table in
Datasheet View and add a new Record? (If not, then it is likely a
matter of user permissions in SQL Server.)
Of a BIT field that doesn't have a default value.....
Larry Linson
Microsoft Access MVP

<sa*********@yahoo.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
Hi

My MS-Access 2003 "Form" is bind to a SQL server 2000 table but I
wonder why doesn't it accept the following command and displays an
error that "You can't go to the specified record". It works well with
MS Access tables but creates problem when the backend table belongs
to SQL server :

DoCmd.GoToRecord , , acNewRec
Can anyone help me with solving this problem.
cheers!!!


--
regards,

Br@dley
Feb 22 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Eric | last post by:
What's the best way to cancel the new record when doCmd.GoToRecord , , acNewRec is executed and before the new record is actually written to the database. I'm maintaining an existing Access 97...
1
by: STeve Lefevre | last post by:
Hey folks -- I'm using the DoCmd.GoToRecord , , acNext to jump to the next record after the user enters a value. The problem is, it throws an error if it's already on the last record! What's the...
0
by: Timppa | last post by:
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...
5
by: Stack | last post by:
Hello, I have my data sorted on date desc in my form (multiple recs/table style). When I want to insert a new record (with my self made button and vba code(DoCmd.GoToRecord , , acNewRec)) the...
1
by: vostrixos | last post by:
Hi all,i need some help I'm working on a access project were i use a lot the docmd.gotorecord ,,next ..first ..last method and i use only once the DoCmd.GoToRecord , , acNewRec.Everything was...
2
by: vostrixos | last post by:
Hi I can't make a code work.What i do is that i'm creating a fileDialog object and later in the same function i use a Docmd.GoToRecord.I've notice that after i use the '.show' property within the...
3
martintallett
by: martintallett | last post by:
Help! I am trying to replace the Access Find button functionality on an old database. I can make it work when I use a basic form with bound fields and a button which shows a popup form which...
2
by: aaronyoung | last post by:
I have been using this forum to answer many questions regarding an Access database I am building (my first attempt at something like this - teaching myself as I go), and I've always been able to find...
5
by: phill86 | last post by:
Hi I have a main form that holds records for scheduled meetings, date time location etc... in that form i have a sub form that has a list of equipment resources that you can assign to the meeting in...
10
by: MyWaterloo | last post by:
My database has a form used to view maintenance for selected equipment. I select the equipment item from a combo box; the subform is then updated with all the relevant maintenance for that equipment...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.